How to list IP's from connected applications on your database

Statement to check the applications IP numbers

To do this, perform the following command:

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

It will show you all applications (local and IP numbers) connected to your database.

Example:

=> db2 get snapshot for applications on DB_SAMPLE | grep -E "handle|Inbound"

Application handle                         = 344
Inbound communication address              = 123.234.100.210 44274
Application handle                         = 286
Inbound communication address              = 123.234.100.210 44272
Application handle                         = 295
Inbound communication address              = 123.234.100.210 34848
Application handle                         = 375
Inbound communication address              = 123.234.100.210 34846
Application handle                         = 212
Inbound communication address              = *LOCAL.app01
Application handle                         = 8
Inbound communication address              = *LOCAL.app01