Using the Central Component › Data Mining › Data Mining DB2 Plans

Previous Topic: Column Descriptions

Next Topic: Line Command

Data Mining DB2 Plans

To list all DB2 plans used by job steps within the Data Mining Scope, enter option 4 on the Data Mining Menu.

 APCBP501 - PMA - Data Mining   DB2 Plans ----------------      Row 1 from 1158
 COMMAND ===>                                                   SCROLL ===> PAGE

 DB2 Plan.....: *                             CPU calculation method: LAST
 Commands.....: SORT N/C/F/J   - Name / Cpu / Frequency / No. Job steps
 Line Commands: XJ -Xref Job step
                    Annual CPU         Annual        No. of
 LC DB2 Plan           h:mm:ss      Frequency     Job Steps
 -------------------------------------------------------------------------------
    DSNTIAUL          89:54:37          2,490            73
    DSNTEP2Z          23:37:34            386            15
    DT501              8:04:28            188            13
    DT502              6:29:34             58             1
    DT512P             6:03:25            801            30

All DB2 plans belonging to the most current measurements of job steps within the Data Mining Scope are listed. Use the panel to identify plans with high annual CPU consumption and cross reference those plans to the job steps that use them.