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


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