To verify server settings for AIX Servers

  1. The /etc/services file must contain connect and interrupt port definitions for DB2, for example:

db2cdb2  50000/tcp   # Connection port for DB2 instance db2aix

db2idb2  50001/tcp   # Interrupt port for DB2 instance db2aix

The db2idb2 port value is always 1 greater than the db2cdb2 port number.

The value of the DB2 connection port service name varies per DB2 UDB AIX installation, but it must match the corresponding SVCENAME configuration variable in step 3.

  1. Using the DB2 administrator account, log on to the DB2 UDB AIX server and issue the following command:

$ db2set -all

 

The following environment variable/value is necessary to support TCP/IP connectivity from CONNX to DB2 UDB:
 

DB2COMM=TCPIP

 

If the DB2COMM environment variable is not set, update it as follows:
 

$ db2set DB2COMM=TCPIP

  1. Next, enter the following:

$ db2 get dbm cfg

Verify that the following configuration variables are set:
 

Database manager authentication

AUTHENTICATION) = SERVER

TCP/IP Service name  SVCENAME) = db2cdb2

 

If the AUTHENTICATION or SVCENAME variables are null or incorrect, update them as follows:
 

$ db2 update dbm cfg using authentication server

$ db2 update dbm cfg using svcename db2cdb2

  1. Finally, if the any updates were made to the DB2 configuration or environment variables, stop and restart the DB2 instance with the following commands:

$ db2stop

$ db2start