09 March 2011

Starting DB2 instance to run on TCP port

To run DB2 listen on Port (UNIX) follow the following steps:

There are 2 types of database user for DB2:
1. DB2 database user (DB user)
2. DB2 database instance user(DB_INSTANCE user).

By using root user check if db2 instance is running or not:
# netstat -lnp | grep

Here port number may be 50001 or 50000

If it is allready running skip it or using db user run the following commands:
$db2stop
$db2set DB2COMM=TCPIP
$db2 update dbm cfg using SVCENAME

Run the following command from DB_INSTANCE user
$db2admin start

Now check from root user if the db2sys is started on PORTNUMBER or not use following command:
# netstat -lnp | grep

The output may looks like:
tcp 0 0 0.0.0.0:50001 0.0.0.0:* LISTEN 2278/db2sysc

No comments:

Post a Comment