How to update an entry in the Database Directory or Node Directory
Resolving The Problem
In the example of updating an IP address of a Node directory entry, the Node entry must be uncataloged and then cataloged again with the new IP address.
- Run the following command to list the current node entry:
db2 list node directory
Node name = DBSERV1
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = 188.8.131.52
Service name = 50002
- db2 UNCATALOG NODE DB2SERV1
- db2 CATALOG TCPIP NODE DB2SERV1 REMOTE 184.108.40.206 SERVER 50002
- db2 TERMINATE
You would run similar commands to modify the Database directory, for example.
- db2 uncatalog db sample
- db2 catalog db sample at new_node
- db2 terminate
Note that the final 'db2 terminate' command is important. It stops the command line processor's backend process and flushes the old directory information from its cache.
db2 "change db sample comment with 'new string'"
Related informationConfiguration Assistant
CATALOG DATABASE command
CATALOG TCPIP NODE command
UNCATALOG DATABASE command
UNCATALOG NODE command
CHANGE DATABASE COMMENT command
More support for:
DB2 for Linux, UNIX and Windows
Component: Connectivity - Cataloging
Software version: 9.7, 10.1, 10.5, 11.1
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Software edition: Enterprise Server, Express, Personal, Personal Developer's, Workgroup Server
Reference #: 1381896
Modified date: 25 January 2019