See some info here ->
Applications Hanging around ?? Is this normal ??
Example from db2pd -applications and db2pd -dynamic :
Code:
Applications:
Address AppHandl [nod-index] NumAgents CoorEDUID Status C-AnchID C-StmtUID L-AnchID L-StmtUID Appid
0x0780000000AF0080 3973 [000-03973] 1 1544 UOW-Executing 351 1 0 0 *LOCAL.xxxxxx.110501015459 1 1 N C N
Applications:
0x0780000000AF0080 3973 [000-03973] 1 1544 UOW-Waiting 0 0 351 1 *LOCAL.xxxxxx.110501015459 1 1 N C N
Dynamic SQL Statements:
Address AnchID StmtUID NumEnv NumVar NumRef NumExe Text
0x07000000348A03E0 351 1 1 1 1 1 SELECT substr(tabschema,1,15)
as schema, sum(data_object_p_size) / 1024 as table_size_in_MB, sum(index_object_p_size) / 1024 as index_size_in_MB,
sum(long_object_p_size) / 1024 as long_size_in_MB, sum(lob_object_p_size) / 1024 as lob_size_in_MB, sum(xml_object_p_size) /
1024 as xml_size_in_MB FROM SYSIBMADM.ADMINTABINFO group by tabschema
C-AnchID and C-StmtUID aren't empty when it's UOW Executing