pdns/docs/markdown/authoritative/backend-db2.md

   1 # DB2 Backend
   2 **Note**: This backend is unsupported.
   3
   4 |&nbsp;|&nbsp;|
   5 |:--|:--|
   6 |Native|Yes|
   7 |Master|No|
   8 |Slave|No|
   9 |Superslave|No|
  10 |Autoserial|Yes|
  11 |DNSSEC|No|
  12 |Disabled data|No|
  13 |Comments|No|
  14 |Module name|db2
  15 |Launch name|db2|
  16
  17 PowerDNS is currently ascertaining if this backend can be distributed in binary form without violating IBM DB2 licensing.
  18
  19 ## Queries
  20 The DB2 backend executes the following queries:
  21
  22 ### Forward Query
  23 select Content, TimeToLive, Priority, Type, ZoneId, 0 as ChangeDate, Name from Records where Name = ? and type = ?
  24
  25 ### Forward By Zone Query
  26 select Content, TimeToLive, Priority, Type, ZoneId, 0 as ChangeDate, Name from Records where Name = ? and Type = ? and ZoneId = ?
  27
  28 ### Forward Any Query
  29 select Content, TimeToLive, Priority, Type, ZoneId, 0 as ChangeDate, Name from Records where Name = ?
  30
  31 ### List Query
  32 select Content, TimeToLive, Priority, Type, ZoneId, 0 as ChangeDate, Name from Records where ZoneId = ?
  33
  34 ## Configuration Parameters
  35
  36 ### `db2-server`
  37 Server name to connect to. Defaults to 'powerdns'. Make sure that your nameserver is not needed to resolve an IP address needed to connect as this might lead to a chicken/egg situation.
  38
  39 ### `db2-user`
  40 Username to connect as. Defaults to 'powerdns'.
  41
  42 ### `db2-password`
  43 Password to connect with. Defaults to 'powerdns'.