You can refer to this link for the details on these elements:
http://publib.boulder.ibm.com/infoce.../r0007641.html
"db2 list applications show detail" will give the details of all applications that are running under the instance. It displays all information about the agents that are serving the applications. It does display the client Auth ID.
A sample output:
db2 list applications show detail
CONNECT Auth Id Application Name Appl. Application Id Seq# Number of Coordinating DB Coordinator Status Status Change Time DB Name DB Path
Handle Agents partition number pid/thread
-------------------------------------------------------------------------------------------------------------------------------- -------------------- ---------- -------------------------------------------------------------- ----- ---------- ---------------- --------------- ------------------------------ -------------------------- -------- --------------------
SAKUMAR9 db2stmm 66037 *N1.DB2.080207111334 00011 0 1 0 Decoupled Not Collected SAMPLE /home/sakumar9/sakumar9/NODE0000/SQL00001/