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.
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
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
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