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