Sunil wanted to know if there was a way to find out more information about the applications connected, and included this output:
DB2 LIST APPLICATIONS
Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- ------------------------------ -------- -----
TBISDEV db2jd 137 *LOCAL.db2inst1.07C2D2181849 TBIS_DEV 1
TBISDEV db2jd 119 *LOCAL.db2inst1.063DF2173835 TBIS_DEV 1
There are a couple of things you can do. If you add the SHOW DETAIL qualifier to the LIST APPLICATIONS command, you can see the applications' current DB2 status (Lock-wait, UOW Executing, UOW Waiting, etc.)
If you want even more details, you can issue a GET SNAPSHOT FOR APPLICATION AGENTID <Appl. Handle #>. The output of the application snapshot will show lots of information, including grand totals of various I/O and SQL-related counters.
Hopefully the snapshot details will help you in determining which application to force.
Good Luck,
Fred Sobotka
