When you create a new database, it is automatically cataloged in the system database directory file. You may also use the CATALOG DATABASE command to explicitly catalog a database in the system database directory file. The CATALOG DATABASE command allows you to catalog a database with a different alias name, or to catalog a database entry that was previously deleted using the UNCATALOG DATABASE command.
The following command line processor command catalogs the personl database as humanres:
catalog database personl as humanres
with "Human Resources Database"
Here, the system database directory entry will have humanres as the database alias, which is different from the database name (personl).
You can also catalog a database on an instance other than the default. In the following example, connections to database B are to INSTANCE_C.
catalog database b as b at node instance_c
| Note: | The CATALOG DATABASE command is also used on client nodes to catalog databases that reside on database server machines. For more information, refer to the Quick Beginnings manual appropriate to your platform. |
For information on the Distributed Computing Environment (DCE) cell directory, see DCE Directory Services and Appendix E, Using Distributed Computing Environment (DCE) Directory Services.
| Note: | To improve performance, you may cache directory files, including the database directory, in memory. (See Directory Cache Support (dir_cache) for information about enabling directory caching.) When directory caching is enabled, a change made to a directory (for example, using a CATALOG DATABASE or UNCATALOG DATABASE command) by another application may not become effective until your application is restarted. To refresh the directory cache used by a command line processor session, issue a db2 terminate command. |
In addition to the application level cache, a database manager level cache is also used for internal, database manager look-up. To refresh this "shared" cache, issue the db2stop and db2start commands.
See Directory Cache Support (dir_cache) for more information about directory caching.