Deletes a database entry from the system database directory.
Authorization
One of the following:
Required Connection
None. Directory operations affect the local directory only.
Command Syntax
>>-UNCATALOG----+-DATABASE-+--database-alias-------------------><
'-DB-------'
Command Parameters
Usage Notes
Only entries in the system database directory can be uncataloged. Entries in the local database directory can be deleted using DROP DATABASE.
To recatalog the database, use CATALOG DATABASE. To list the databases that are cataloged on a node, use LIST DATABASE DIRECTORY.
The authentication type of a database, used when communicating with a down-level server, can be changed by first uncataloging the database, and then cataloging it again with a different type.
| Note: | If directory caching is enabled (see the configuration parameter dir_cache in GET DATABASE MANAGER CONFIGURATION), database, node, and DCS directory files are cached in memory. 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 may not be effective until the application has restarted. |
To refresh the CLP's directory cache, use TERMINATE. 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.