Threads Summary Including Idle Threads
This panel shows an overview of the activity of all threads (including idle threads) that are connected to DB2.
________________ ZALLTQ VTM O2 V540.#P DC11 S 06/30/16 21:33:17 2
> Help PF1 Back PF3 Up PF7 Down PF8 Sort PF10 Zoom PF11
> T.Q
> Thread Activity: Enter a selection letter on the top line.
> A-All-Idle B-TSO C-CICS D-IMS E-Background F-Dist Allied
> G-Dist DBAC H-Util I-Inact J-Filter K-Functions L-Stored Proc
> M-Triggers N-Sysplex O-Enclaves P-Worksta *-All+Idle
===============================================================================
> Threads Summary Including Idle Threads
THDQ
+ *
+ Elapsed Planname CPU Status WFCurr Update Commit CORRID/JOBN
+ ---------- -------- ----- ------------ ------ ------ ------ ------------
+ 00:00:06.3 DSNTEP12 01.3% WAIT-SYNC-IO 65024 67515 0 HONGDGTS
+ 00:00:06.6 DSNTEP12 01.2% IN-SQL-CALL 60928 62836 0 HONGDGTB
+ 00:00:06.6 DSNTEP12 01.1% WAIT-SYNC-IO 58880 60681 0 HONGDGTD
+ 00:00:05.6 DSNTEP12 00.9% WAIT-SYNC-IO 58368 60152 0 HONGDGT1
+ 00:00:06.6 DSNTEP12 00.9% WAIT-SYNC-IO 55296 56909 0 HONGDGT4
+ 00:00:06.7 DSNTEP12 00.9% WAIT-SYNC-IO 53248 54431 0 HONGDGTA
+ 00:00:06.7 DSNTEP12 00.9% WAIT-SYNC-IO 53248 54631 0 HONGDGT2
+ 00:00:06.6 DSNTEP12 00.9% WAIT-SYNC-IO 52736 53895 0 HONGDGT3
+ 00:00:06.5 DSNTEP12 00.8% WAIT-SYNC-IO 50176 50881 0 HONGDGTC
+ 06-20:44 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 SZ91DM31
+ 06-20:46 KO2PLAN 00.0% NOT-IN-DB2 0 0 19 SZ91DM31
+ 00:00:00.0 00.0% NOT-IN-DB2 0 0 0 SZ91DM31
+ 07-11:23 00.0% NOT-IN-DB2 0 0 0 OMPEDA5S
+ 06-20:46 00.0% NOT-IN-DB2 0 0 0 SZ91DM31
+ 00:00:00.0 DISTSERV 00.0% NOT-IN-DB2 0 0 0 NONE
+ 00:28:54.4 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 OMPEHZ7S
+ 00:29:34.2 00.0% NOT-IN-DB2 0 0 0 OMPEHZ7S
+ 00:29:34.2 KO2PLAN 00.0% NOT-IN-DB2 0 0 7 OMPEHZ7S
+ 00:29:34.2 KO2PLAN 00.0% IN-SQL-CALL 0 0 0 OMPEHZ7S
+ 00:00:00.0 00.0% NOT-IN-DB2 0 0 0 OMPEHZ7S
+ 07-11:23 KO2PLAN 00.0% NOT-IN-DB2 0 0 11 OMPEDA5S
+ 07-11:23 00.0% NOT-IN-DB2 0 0 0 OMPEDA5S
+ 07-10:19 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 OMPEDA5S
+ 00:00:00.0 00.0% NOT-IN-DB2 0 0 0 OMPEDA5S
+ 01:26:46.1 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 OMPEHZ8S
+ 01:27:22.1 KO2PLAN 00.0% NOT-IN-DB2 0 0 7 OMPEHZ8S
+ 01:27:22.1 00.0% NOT-IN-DB2 0 0 0 OMPEHZ8S
+ 01:27:22.2 KO2PLAN 00.0% NOT-IN-DB2 0 0 0 OMPEHZ8S
+ 00:00:00.0 00.0% NOT-IN-DB2 0 0 0 OMPEHZ8S
=============================================================================== This panel is identical (except for idle threads being included) to the Threads Summary Excluding Idle Threads panel. Highlighting information, navigation hints, and fields are described in Thread Activity, panel Threads Summary Excluding Idle Threads.