DB2 Version 9.7 for Linux, UNIX, and Windows

UNCATALOG NODE command

Deletes an entry from the node directory.

Authorization

One of the following:
  • sysadm
  • sysctrl

Required connection

None. Directory operations affect the local directory only.

Command syntax

Read syntax diagramSkip visual syntax diagram
>>-UNCATALOG NODE--nodename------------------------------------><

Command parameters

NODE nodename
Specifies the node entry being uncataloged.

Usage notes

UNCATALOG NODE can be executed on any type of node, but only the local directory is affected, even if there is an attachment to a remote instance, or a different local instance.

If directory caching is enabled, database, node, and DCS directory files are cached in memory. To see if directory caching is enabled, check the value for the dir_cache directory cache support configuration parameter in the output from 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 the database manager's shared cache, stop (db2stop) and then restart (db2start) the database manager. To refresh the directory cache for another application, stop and then restart that application.