Locate the DB2 connection port number on Linux

21 November,2008 by Tom Collins

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

grep <my service> /etc/services

you'll get back something like


<my service > 50000/tcp

Read More on DB2 list schemas, connections, db2expln

DB2 list schemas of a database - DBA DB2

Force connections of a database in DB2

DB2 Query Tuning – db2expln

Author: Rambler(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Locate the DB2 connection port number on Linux

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright