Verifying Server Settings for AIX Servers
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 2.
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
2. Enter the following:
$ db2 get dbm cfg
3. 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
4. Finally, if any updates were made to the DB2 configuration or environment variables, stop and restart the DB2 instance with the following commands:
$ db2stop
$ db2start