In the Detector for Db2 for z/OS (PDT) Plan Program display, the following INDB2_TIME 17-16:42.11 was displayed as seen below.
PROGRAM TYPE SQL TIMEPCT CPUPCT INDB2_TIME INDB2_CPU GETPAGE
-------- ---- ---------- ------- ------- ------------ ------------ ----------
_ SYSLN200 PKGE 774 76.18% 76.24% 7-16:42.11 00:00.285180 17535
The INDB2_TIME of 17-16:42.11 is strange. What does this strange number indicate?
There are 3 possible formats for this TIME field that vary depending on the amount/value:
if < 1 hour PDT uses the following format MM:SS.ssssss
if > 1 hour PDT uses the following format HH:MM:SS.sss
if > 24 hours PDT uses the following format DD-HH:MM.SS (which matches the situation described above)