What increments the ?Duration? fields are being reported in Plan Suspension Summary panel?

Document ID : KB000013746
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

What increments the “Duration” fields are being reported in? Are these seconds? i.e. is 10.0882 representative of 10 seconds?

The field level help indicates the following:

Field Level Help            

Event Duration:             

Elapsed time between a  start/end pair of events.   

IQL Name: EVENT-DUR         

DB2 Name: Delta of QWHSSTCK

 

 

Menu  Print  Tools  Help    CA SYSVIEW for DB2  DW2O SYSA     03/16/17 17:12:30                  

                                19.0            DW0O                   TS00J6                    

   1 All  2 Connections  3 Curr Contn  4 D-Lk/T-Out  5 Lk Susp Sum  6 More...                    

                                                                                                 

R/PLANLOCK      Plan Suspension Summary                         Row 118-130/516                  

                                                                                                 

From 03/12/17 19:04:12 To 03/16/17 17:11:48                                                      

                                                                        Avg      Max      Min    

  Plan        -Object- -Locked-       Scope    P/L     Type     Count Duration Duration Duration 

-------- --------------------------- ------ -------- -------- ------- -------- -------- -------- 

DISTSERV DSNDB06 .SYSTSTPT .DW0O     GLOBAL LOGICAL  ROW            2   0.0000   0.0000   0.0000 

DISTSERV DSNDB06 .SYSTSVOL .DW0O     GLOBAL LOGICAL  DATASET        4   0.0000   0.0001   0.0000 

DISTSERV LEDS000O.HUBMQRTG .DW0O     GLOBAL LOGICAL  DATAPAGE     182   0.0049   0.1536   0.0000 

DISTSERV LEDS000O.HUBMQRTG .DW0O     GLOBAL LOGICAL  DATASET      335   0.0117   0.8256   0.0000 

DISTSERV LEDS000O.HUBMQRTG .DW0O     GLOBAL LOGICAL  MASS DEL     258   0.0132   1.8943   0.0000 

DISTSERV LEDS000O.HUBMQRTG .DW0O     GLOBAL LOGICAL  PSET PC        1   0.0103   0.0104   0.0104 

DISTSERV LEDS000O.LEDSCONS .DW0O     GLOBAL LOGICAL  MASS DEL      10   0.0001   0.0003   0.0000 

DISTSERV LEDS000O.LEDSMSGS .DW0O     GLOBAL LOGICAL  DATAPAGE 1020002   0.0096   6.2334   0.0000 

DISTSERV LEDS000O.LEDSMSGS .DW0O     GLOBAL LOGICAL  DATASET   274132   0.0213   6.3634   0.0000 

DISTSERV LEDS000O.LEDSMSGS .DW0O     GLOBAL LOGICAL  MASS DEL  125350   0.0454  10.0882   0.0000 

DISTSERV LEDS000O.LEDSMSGS .DW0O     GLOBAL PHYSICAL P/P PLCK       7   0.0008   0.0046   0.0001 

DISTSERV LEDS000O.LEDSMSGS .DW0O     GLOBAL LOGICAL  PSET PC     6288   1.6861  20.1266   0.0009 

DISTSERV LEDS000O.LEDSMSGS .DW0O     GLOBAL LOGICAL  SYSLGRNG      10   0.0526   0.0871   0.0000

 

 

Thanks

Daniel

Answer:

The timestamp format for EVENT-DUR in PLANLOCK is SS.TTT. If you include fewer "T"s (or more), the conversion program will attempt to use them. So, SS.T and SS.TTT and SS.TTTTTT are all valid.