Thursday, 4 April 2013

How to assign a Port Number to instance ?

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:

db2c1svc 50000/tcp # DB2 Instance connection port for instance DB2C1
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 update it. 
    On a Windows system, the Services file is located in the directory path of  
\windows\system32\drivers\etc\services.

3. On an AIX system, synchronize the /etc/services file and the inetd daemon by
executing the following commands:
# inetimp
# refresh -s inetd

$ db2 update dbm cfg using  SVCENAME 50000

 After the database manager is stopped and started again, view the database manager configuration file to ensure that these changes have taken effect

No comments:

Post a Comment