Personal tools
You are here: Home DB2 How To's How to list IP's from connected applications on your database
Navigation
Log in


Forgot your password?
 
Document Actions

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
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls