Using the Central Component › Measurement Lists › DB2 Plan/DBRM Overview

DB2 Plan/DBRM Overview

After selecting a job name with line command SD, the DB2 Plan/DBRM Overview panel displays.

APCJPDBR - PMA - DBRM SQL Overview --------------------------- Row 1 to 5 of 5 
COMMAND ===>                                                   SCROLL ===> HALF
                                                                               
Jobname  Stepname Procstep    Date       Time                                  
DB2DBJOB          DB2DBJPR    2011.01.15 02:13                                 
                                                                               
               STMT             TOTAL                TOTAL    AVERAGE     TOTAL
LC DBRM         NUM TYPE        COUNT CPU-P-CALL       CPU  RESP TIME RESP TIME
-- -------- ------- -------- -------- ---------- --------- ---------- ---------
   DB2DB001    1522 SELECT     150264   0.000027  4.130550   0.000064  9.682120
   DB2DB002    1967 UPDATE     147128   0.000035  5.221276   0.000055  8.149808
   DB2DB003     581 SELECT      10018   0.000186  1.866419   0.000304  3.041948
   DB2DB003     618 UPDATE      10018   0.000059  0.591169   0.000104  1.040037
   DB2DB002    1823 INSERT       3137   0.000091  0.286256   0.000328  1.028155
******************************* Bottom of data ********************************

The DB2 Plan/DBRM Overview panel displays the activity of DB2 statements during the monitored period.