How Get IP Address of connections to DB2 server

30 January,2015 by Jack Vamvas

Question: How can I get the IP address of connections to a DB2 server? When  connected to a DB2 server and execute db2 list applications, a list of connections are listed . The problem is the information in the Application Id column in the db2 list applications output is not easily readable.

To get the ip address , string manipulation is required, using the SUBSTR function. Is their another way of getting the ip address, without having to use SUBSTR?

Answer: Yes. It is possible get the ip address of connections via the SYSIBMADM.SNAPAPPL administrative view.  The view allows you to get snapshot information for the current database.

 

$ db2 "select inbound_comm_address from sysibmadm.snapappl"


Read More on DB2 snapshots

DB2 manager status and get snapshot for dbm - DBA DB2

DB2 – How to check if autoresize is enabled - DBA DB2

DB2 event monitor and snapshot monitor - DBA DB2

 

Author: Jack Vamvas(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 How Get IP Address of connections to DB2 server

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