Directory entries for user databases on independent auxiliary storage pools

 

For a system with only one database (that is, without independent auxiliary storage pools (independent ASPs) configured), the *LOCAL entry refers to the single local database. For systems with multiple databases (one system database and one or more user databases), the *LOCAL entry refers to the system database.

The local user databases are represented by entries similar to remote *IP entries. The main difference is the Remote location field. In cases where the database cannot be switched to a different system, this field normally contains the word LOOPBACK. LOOPBACK represents the IP address of the host system. If the database can be switched, it is suggested that the user configure the system in such a way that a specific IP address is associated with the database regardless of the system to which it is attached. For an explanation on how dedicated IP address configuration is done, see the Managing application CRG takeover IP addresses topic. In that case, the IP address is used in the Remote location field.

If LOOPBACK is used for a switchable database, then whenever it is switched from the local system, the user will have to manually change the directory entry to replace LOOPBACK with the IP address of the new system to which it is attached, and then change it back to LOOPBACK when the database is switched back.

 

Parent topic:

Working with the relational database directory

 

Related reference

Managing application CRG takeover IP addresses