Thread Terminator Active thread list INDB2_CPU and INDB2_TIME stay at 00:00.000000
Article ID: 235130
Updated On:
Products
Thread Terminator for DB2 for z/OS
Issue/Introduction
Users of Thread Terminator for Db2 for z/OS (PTT) complaining that in panel PTTZ0002 (Active thread list) the values of
INDB2_CPU and INDB2_TIME columns stay at 00:00.000000 for the whole duration of the thread.
Example :
PTTZ0002 ------ Thread Terminator Active Threads Display ----- 02-08-22 09:47
Command ==> Scroll ==> CSR
LINE 1 OF 16
DB2 SSID ==> ssid Filter ==> NO Set Filters ==> _
-------------------------------------------------------------------------------
S -View Thread Detail, T -Terminate thread
PLANNAME OPID STATUS TOKEN SQL GETPAGE INDB2_CPU
-------- -------- -------- -------- ---------- ---------- ------------
_ xxxxx xxxxxxx INAPPL 75018 168 198 00:00.000000
_ yyyyy yyyyyyy INAPPL 75547 1 4 00:00.000000
_ zzzzz zzzzzzz INAPPL 75590 1 4 00:00.000000
PTTZ0002 > ------ Thread Terminator Active Threads Display ----- 02-08-22 09:48
Command ==> Scroll ==> CSR
LINE 1 OF 16
DB2 SSID ==> ssid Filter ==> NO Set Filters ==> _
-------------------------------------------------------------------------------
S -View Thread Detail, T -Terminate thread
PLANNAME ETIME INDB2_TIME OTOKEN COORDMEM SYNCREAD SPFETCH
-------- ------------ ------------ -------- -------- ---------- ----------
_ xxxxx 06:05:22.737 00:00.000000 75018 23 0
_ yyyyy 04:18:09.796 00:00.000000 0 2 0
_ zzzzz 03:53:25.464 00:00.000000 0 1 0
And with a select of a thread for detail also got a value of 00:00.000000 in panel PTTZ0004 (View Thread Detail):
Example :
PTTZ0004 ------- Thread Terminator Thread Time Display --------- 02-08-22 09:49
Command ==> Scroll ==> CSR
LINE 1 OF 37
Option ====> T B=Buffer, S=SQL, C=SQLCall, L=Lock, I=Parallelism
P=Program, R=Drain, Z=SQLtrace, D=Dist, T=Time
-------------------------------------------------------------------------------
DB2 SSID ==> ssid Planname ==> xxxxx Connid ==> xxxxxxx
Opid ======> xxxxxxx Authid ====> xxxxxxx Corrid ==> xxxxxxxxxxxx
Conntype ==> CICS Jobname ===> xxxxxxx Asid ====> nnnn
Time Component Total Time CPU Time Wait Cnt Wait Avgtime
--------------------------- ------------ ------------ ---------- ------------
Elapsed Times
Thread 01:15.132967
Stored Procedure 00:00.000000
User Defined Function 00:00.000000
Trigger 00:00.000000
Non-ZIIP CPU
INDB2 Time/INDB2 CPU 00:00.000000 00:00.000000
CPU Stored Procedure 00:00.000000
CPU User Defined Func 00:00.000000
CPU Trigger 00:00.000000
ZIIP CPU
Thread ZIIP CPU 00:00.000000
Thread ZIIP on CP 00:00.000000
Stored Proc ZIIP CPU 00:00.000000
User Def Func ZIIP CPU 00:00.000000
Trigger ZIIP CPU 00:00.000000
Wait times
Total Wait/Time/Count 00:00.000000 0 00:00.000000
Sync Read I/O 00:00.000000 0 00:00.000000
Lock/Latch 00:00.000000 0 00:00.000000
Log Write I/O 00:00.000000 0 00:00.000000
Other Read I/O 00:00.000000 0 00:00.000000
To configure and apply thresholds for Thread Terminator the only threshold that works is for Elapsed Times.
Resolution
To display values for the INDB2_CPU and INDB2_TIME columns the following ACCTG traces must be started:
START TRACE(ACCTG) CLASS(1,2,3)
Class 1 and Class 2 are for INDB2_CPU and INDB2_TIME columns.
Class 3 gives you wait times and counts if you want those.
Feedback
Yes
No
Powered by
