How to check IP Addresses of connected applications in DB2.

In this blog we will see how to list the connected applications IP on your DB2 database. To find out execute the below command after connecting with your database:

db2 get snapshot for applications on <db_name> | grep -E "handle|Inbound"

Above syntax will show you all connected applications (local and IP numbers) on your database. Let's see an example:

db2inst1@UBNJC66LNX:~$ db2 connect to MITHILA

   Database Connection Information

 Database server        = DB2/LINUXX8664 10.1.4
 SQL authorization ID   = DB2INST1
 Local database alias   = MITHILA

db2inst1@UBNJC66LNX:~$ db2 get snapshot for applications on mithila | grep -E "handle|Inbound"
Application handle                         = 26
Inbound communication address              = *LOCAL.db2inst1
Application handle                         = 32
Inbound communication address              = 121.231.100.209 54286
Application handle                         = 31
Inbound communication address              = *LOCAL.app01
Application handle                         = 30
Inbound communication address              = 121.231.100.209 36489
Application handle                         = 36
Inbound communication address              = *LOCAL.app01
Application handle                         = 29
Inbound communication address              = *LOCAL.app01
Application handle                         = 35
Inbound communication address              = 121.231.100.209 27596
Application handle                         = 28
Inbound communication address              = 121.231.100.209 34865
db2inst1@UBNJC66LNX:~$

That's all in this post. If you liked this blog and interested in knowing more about IBM Db2. Please Like, Follow, Share & Subscribe to www.ImJhaChandan.com.