Changing system names displayed in the Control Center - IBM DB2 9.7 for Linux, UNIX, and Windows

Systems are displayed in the Control Center object tree, and each system represents a physical server. The system name that is displayed for each system is stored in the corresponding admin node directory entry for the system.

Before you begin

To change system names, you must have SYSADM or SYSCTRL authority.

About this task

Note: For remote systems, it is recommended that you use the remote hostname as the system name. This will ensure that the system names are unique in the Control Center object tree.

When you change a system name displayed in the Control Center using the Change System window, the system name of the nodes under the same system are also updated.
When you change a system name using the CLP, you will have to update each child node individually.

To change a system name using either the Control Center or the Configuration Assistant:

Open the Change System window using one of the following methods:
- From the Control Center, expand the object tree until you find the system that you want to change. Right-click the All Systems folder and select Change from the pop-up menu. The Change System window opens.
- From the Configuration Assistant Advanced view, click the Systems tab. Select the system that you want to change and click Selected–>Change System. The Change System window opens.
  Note: You cannot open the Change System window from the Selected menu unless you are in the Advanced view. To switch to the Advanced view, select View–>Advanced View.
Change the system name and other fields as required. If you are changing protocol information, you may require the assistance of your network or database administrator.

To change a system name using the CLP, use the CATALOG ADMIN NODE and CATALOG NODE commands.For example, suppose that you have the following entries in the node directory and in the admin node directory:

DB2 LIST ADMIN NODE DIRECTORY SHOW DETAIL
   Node Directory
   Number of entries in the directory = 1

   Node 1 entry:

   Node name = HONCHO
   Comment =
   Directory entry type = LOCAL
   Protocol = TCPIP
   Hostname = honcho
   Service name = 523
   Remote instance name =
   System = HONCHO
   Operating system type = WIN

DB2 LIST NODE DIRECTORY SHOW DETAIL
   Node Directory

   Number of entries in the directory = 1

   Node 1 entry:

   Node name = NODE1
   Comment =
   Directory entry type = LOCAL
   Protocol = TCPIP
   Hostname = honcho
   Service name = 78787
   Remote instance name = db2inst1
   System = HONCHO
   Operating system type = WIN

To change the system name from HONCHO to PLATO, you would issue the following commands to recatalog the above nodes with a new system name:

   DB2 UNCATALOG NODE HONCHO                                                                       
   DB2 CATALOG ADMIN TCPIP NODE HONCHO REMOTE HONCHO SYSTEM PLATO OSTYPE WIN 
   DB2 UNCATALOG NODE NODE1                                                                        
   DB2 CATALOG TCPIP NODE NODE1 REMOTE HONCHO SERVER 78787                                         
      REMOTE_INSTANCE db2inst1 SYSTEM PLATO OSTYPE WIN

On restarting the Control Center, the system name is now displayed as PLATO. The system will still have a single instance (db2inst1) located under it in the object tree.