We have moved to www.dataGenX.net, Keep Learning with us.

Tuesday, July 17, 2012

Locate the DB2 connection port number on Linux/Unix

Hey guys, here we see how to get the port no which is assigned to DB2 Services

1)Open a DB2 command prompt
2)Verify you are on the correct instance

db2 get instance

3)Find the service name of your instance
db2 get dbm cfg | grep SVCE

You'll get back something like :
TCP/IP Service Name     (SVCENAME) = db2mydb2

4)Use the service name to find the port number in the services file

db2 grep <my service> /etc/services

you'll get back something like
<my service > 50000/tcp

gotcha !! you found the port no ;-)

njoy the simplicity.......
Atul Singh

No comments :

Post a Comment