Strange INDB2_TIME in Detector PLAN PROGRAM DISPLAY
search cancel

Strange INDB2_TIME in Detector PLAN PROGRAM DISPLAY

book

Article ID: 12768

calendar_today

Updated On:

Products

Detector for DB2 for z/OS

Issue/Introduction

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?

Resolution

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)