Source IP for connected applications in DB2

Usually when there are performance problems you need to track who is connected to the database. Especially in development environments because production environments are more restricted with who has access to the DB.

You can easily list the applications connected to your DB2 database using the control center application or from the command line.

From the control center:

1. First check that the Objects Detail Pane is active

1. In the Objects Details Pane, click the application list link

1. This will open a window like this:

From the command window just do something like:

DB2 LIST APPLICATIONS

Now to get the real juicy and useful information execute from the command line:

DB2 GET SNAPSHOT FOR APPLICATION AGENTID ###

And use the number that is under the Appl. Handle column, this will show the ip address and other info.