Search dba-db2.com
*Use the Comments section for questions
Recent Posts
How Get IP Address of connections to DB2 server
30 January,2015 by Tom Collins
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
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
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.
dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright
Posted by: |