UNCATALOG DCS DATABASE command

Deletes an entry from the Database Connection Services (DCS) directory.

Authorization

Required connection

None. Directory operations affect the local directory only.

Command syntax

>>-UNCATALOG DCS--+-DATABASE-+--database-alias-----------------><
                  '-DB-------'                   

Command parameters

DATABASE database-alias

Specifies the alias of the DCS database to uncatalog.

Usage notes

DCS databases are also cataloged in the system database directory as remote databases and can be uncataloged using the UNCATALOG DATABASE command.

To recatalog a database in the DCS directory, use the UNCATALOG DCS DATABASE and CATALOG DCS DATABASE commands. To list the DCS databases that are cataloged on a node, use the LIST DCS DIRECTORY command.

If directory caching is enabled, database, node, and DCS directory files are cached in memory. See the information provided for the configuration parameter dir_cache in the output of the GET DATABASE MANAGER CONFIGURATION command. An application's directory cache is created during its first directory lookup. Since the cache is only refreshed when the application modifies any of the directory files, directory changes made by other applications might not be effective until the application has restarted.

To refresh the CLP's directory cache, use the TERMINATE command. To refresh DB2®'s shared cache, stop (db2stop) and then restart (db2start) the database. To refresh the directory cache for another application, stop and then restart that application.