Thread Terminator - Active thread list INDB2_CPU and INDB2_TIME stay at 00:00.000000
Article ID: 235130
Updated On:
Products
Detector for DB2 for z/OS
Issue/Introduction
Users of Thread Terminator are 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 ==> DBD3 Filter ==> NO Set Filters ==> _
-------------------------------------------------------------------------------
S -View Thread Detail, T -Terminate thread
PLANNAME OPID STATUS TOKEN SQL GETPAGE INDB2_CPU
-------- -------- -------- -------- ---------- ---------- ------------
_ PTDZ0 S084999 INAPPL 75018 168 198 00:00.000000
_ PTDY0 S847629 INAPPL 75547 1 4 00:00.000000
_ PTDZ0 S084999 INAPPL 75590 1 4 00:00.000000
_ PTD10 S084988 INAPPL 75806 39 279 00:00.000000
_ PTDZ0 S803717 PTASK 75833 1 4 00:00.000000
_ PTDY0 S852686 INAPPL 75973 7 67427 00:00.000000
_ PTDY0 S852686 INAPPL 76088 12 38 00:00.000000
_ PTDY0 S803726 INAPPL 76208 356 11909 00:00.000000
_ PTDY0 S803726 INAPPL 76209 126 931 00:00.000000
_ FRPLN S647601 INAPP/SW 76238 14 59 00:00.000000
_ PTDY0 S622673 INAPPL 77039 2 16 00:00.000000
_ RCUUPLAN S843866 INAPP/SW 78670 13 100 00:00.000000
PTTZ0002 > ------ Thread Terminator Active Threads Display ----- 02-08-22 09:48
Command ==> Scroll ==> CSR
LINE 1 OF 16
DB2 SSID ==> DBD3 Filter ==> NO Set Filters ==> _
-------------------------------------------------------------------------------
S -View Thread Detail, T -Terminate thread
PLANNAME ETIME INDB2_TIME OTOKEN COORDMEM SYNCREAD SPFETCH
-------- ------------ ------------ -------- -------- ---------- ----------
_ PTDZ0 06:05:22.737 00:00.000000 75018 23 0
_ PTDY0 04:18:09.796 00:00.000000 0 2 0
_ PTDZ0 03:53:25.464 00:00.000000 0 1 0
_ PTD10 02:30:48.550 00:00.000000 0 189 0
_ PTDZ0 02:17:22.116 00:00.000000 75813 0 0
_ PTDY0 01:47:40.063 00:00.000000 0 743 0
_ PTDY0 01:45:29.054 00:00.000000 0 24 0
_ PTDY0 01:24:55.430 00:00.000000 0 1169 19
_ PTDY0 01:24:52.871 00:00.000000 0 11 0
_ FRPLN 01:22:11.579 00:00.000000 0 13 0
_ PTDY0 47:54.840483 00:00.000000 0 5 0
_ RCUUPLAN 11:04.111134 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 ==> DBD3 Planname ==> PTD16 Connid ==> CIDIL10
Opid ======> P010DB2 Authid ====> P010DB2 Corrid ==> ENTRVR090004
Conntype ==> CICS Jobname ===> CIDIL10 Asid ====> 00A2
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.
Environment
Release : 20.0
Component : Thread Terminator
Resolution
To display values for the INDB2_CPU and INDB2_TIME columns the following ACCTG traces have to 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
