Walker News

How To Setup IBM DB2 Control Center

Copyright © Walker 25 Jan 2008 12:22
IBM DB2 Control Center is a graphical user interface (GUI) to manage and administer DB2 server system resides on the local or remote system. Similar to DB2 server side components, Control Center is available on multiple OS platforms (e.g. Windows, Linux, AIX, Solaris, etc).
Here are the steps to configure DB2 Control Center in Windows XP to access DB2 server running in RHEL4
Configure TCP/IP Communication For The DB2 Instance

This server side configuration is only applicable if you’re manually installing DB2 ESE packages with db2_install scripts.

For those who is using db2setup (the GUI installer), the TCP/IP communication should have been done in a point and click fashion.

According to IBM Redbooks, db2_install is normally used to install DB2 on larger, more complex multiple-partition systems. Tasks such as userids / groups set up, instance creation, tools catalog database creation, and notification set up, need to be performed manually after the installation.
  1. Edit the /etc/services system file to append a record of service name and port number that allows DB2 server listen to client connection request. For example, 
    wndbm        3700/tcp     # DB2 Comm Port

    where wndbm is the user-define service name (must be a unique name in the /etc/services file), 3700 is the connection port number (any port number that is not currently used in /etc/services file or avoid those standard TCP port number), and tcp indicates this is a TCP port (i.e. not UDP port)
     
  2. Login with Linux user account of the DB2 instance
     
  3. Execute source sqllib/db2profile to prepare the DB2 instance environment
     
  4. Update the SVCENAME parameter in the DB2 database manager configuration file with the service name specified in /etc/services
    db2 update dbm cfg using SVCENAME wndbm
     
  5. To confirm the previous step has been done,
    db2 get dbm cfg | grep SVC
     
  6. Execute db2set DB2COMM=tcpip to set the DB2COMM registry variable so that the DB2 communications manager will automatically startup together with database manager
     
  7. Stop and re-start the instance for the changes to take effect, i.e. db2stop then db2start

Once the DB2 server side configuration completed, execute either the netstat or lsof command (with root user account) should able to show the port is opened and listening for connection:

The port shown in netstat -tulpan | grep 3700 command output:
tcp   0   0   0.0.0.0:3700   0.0.0.0:*   LISTEN   12808/db2tcpcm

The output shown in lsof -i | grep wndbm:
db2sysc   20476   walker   3u  IPv4 407137   TCP *:wndbm (LISTEN)
db2sysc   20636   walker   3u  IPv4 407137   TCP *:wndbm (LISTEN)


Configure DB2 Control Center To Admin Remote DB2 Instance

Assume the DB Control Center is running on a Windows XP computer and used to admin the remote DB2 instances hosted on RHEL4 machines
  1. Edit the %WINDIR%\system32\drivers\etc\hosts to add in hostname and IP mapping for the remote DB2 servers
     
  2. Open the DB2 Control Center, right-click the SYSTEMS tree icon on the left pane and select ADD
     
  3. In the ADD SYSTEM dialog box, specify the remote DB2 server hostname in SYSTEM NAME text box and click the DISCOVER button. Once the OK button is activated, click OK to proceed (the OPERATING SYSTEM will be reflected to Linux once the discovery done successfully)
     
  4. Double-click the new DB2 server added to the tree on left pane, then right-click on the INSTANCES tree icon and select ADD
     
  5. In the ADD INSTANCE dialog box, click DISCOVER button and then double-click the selected REMOTE INSTANCE NAME discovered in the DISCOVERY SEARCH BOX. Give a meaningful alias for the remote DB2 instance in NODE NAME text box. Set SERVICE NAME text box with the service name given to /etc/services file (remote DB2 server) or the SVCENAME value in database manager configuration file. Click OK button to add.
     
  6. Double-click the newly added DB2 instance on left pane, right-click the DATABASES tree icon and select ADD
     
  7. In the ADD DATABASE dialog box, click DISCOVER button and double-click the selected DATABASE discovered in DISCOVERY SEARCH dialog box. Click ADD to add the selected DB2 database.

Double-click the database added to the tree on left pane, you will likely prompted to provide authentication credential to logon the remote DB2 administration server.


Custom Search