Relational database directory entries

Edit online

Review the relational database (RDB) directory entries on the setup source node.

The RDB name for *LOCAL and the RDB names for mirrored independent auxiliary storage pools (IASPs) must be identical on the Db2® Mirror nodes.

Note: Start of changeThe RDB name for *LOCAL must not be the same as the system name of the setup source node. End of change

To change the *LOCAL RDB name, first remove the current *LOCAL RDB name by using RMVRDBDIRE. Reply 'G' to the CPA3E01 inquiry message. Before the current *LOCAL RDB is removed, record the values for CHGDDMTCPA because they will be reset to their defaults.

Start of changeThe initial Db2 Mirror clone process results in identical RDB directory entries between the two nodes. After the initial clone, RDB directory entries are not replicated by Db2 Mirror. If you don't manually keep the RDB directory entries the same, you might need to reconfigure RDB directory entries if forced to reclone in the future.End of change

For an explicit connection between the nodes in a Db2 Mirror pair, an additional *MIRROR RDB directory entry can be added for each database you intend to connect to. Specify a new relational database alias name and the actual relational database name on the ADDRDBDIRE command.

For Db2 Mirror, a special internal RDB can be used to run SQL statements over an RDMA connection without needing to define a traditional RDB directory entry by using the ADDRDBDIRE command. This RDB name is defined as:
  • The prefix is QIBM_DB2M_
  • The prefix is followed by a 5-digit ASP number NNNNN, where NNNNN is the ASP number of the target relational database you are connecting to.

    Specify ASP numbers 00000 - 00032 for a Db2 Mirror database connection to SYSBAS on the target node. Specify ASP numbers 00033-00255 for a Db2 Mirror database connection to the corresponding IASP on the target node.

For example, to run an SQL statement in SYSBAS on the target node for Db2 Mirror that uses 3-part naming, you can always use the RDB name QIBM_DB2M_00000.

These special RDBs use the MIRROR_DATABASE Network Redundancy Group (NRG). Unlike traditional RDB directory entries, these special RDBs are not listed in the WRKRDBDIRE command. The ASP number of an IASP can be obtained from the ASP_NUMBER column when querying the QSYS2.MIRROR_INFO view.