Steps to configure DB2 to support remote TCP/IP clients
Atul.Singh 270002HUVT Visits (2015)
Sometimes we need to add port which can be listen by DB2. As DB2 can listen any port no lying between 1 to 64000.
Here I am describing how to configure DB2 to listen/support TCP/IP clients.
To configure DB2 to support remote TCP/IP clients:
1. Add an entry to the TCP/IP Services file that looks similar to the following example:
The service name db2c1svc can be any name you choose, but must be unique in the Services file and must match the value you specify for the SVCENAME parameter in the DBM CFG file.
The port number you specify should be an integer greater than 1024. The port numbers must be unique within the Services file.
The maximum length for the SVCENAME value is 14 characters. This parameter is case sensitive.
The tcp after the port number must be in lower case.
2. On a Linux or UNIX system, the services file is located in the directory path of /etc/services. You must be root to update it. On a Windows system, the Services file is located in the directory path of \win
3. On an AIX system, synchronize the /etc/services file and the inetd daemon by executing the following commands:
# refresh -s inetd
** We can add the DB2 service name in DBM CFG file by executing the following commands
db2> update dbm cfg SVCENAME <service_name>
db2> update dbm cfg SVCENAME db2c1svc