Example: DBCTL

An example of a Performance Summary report showing a summary of DBCTL activity by transaction is shown in Figure 2. The report is sorted by transaction ID and PSB name.

Sample Report Forms are provided to help you format Summary reports to show DBCTL transaction activity:
IMSDBSUM
Transaction DBCTL Usage Analysis
IMSRQSUM
Transaction DBCTL Req Analysis
IMSSUM
IMS DBCTL PSB Usage Analysis

You can edit the sample forms to tailor your reports. Alternatively, you can create a new Report Form, select to specify Field Categories, and select DBCTL to populate the form with DBCTL fields as shown in Figure 1.

Move the fields of interest above EOR to include them in the report.

Figure 1. SUMMARY Report Form (DBCTL fields)
                   EDIT SUMMARY Report Form - DBCTLSUM
 
     Field    Sort                                               - User Field -
     Name +   K  O  Type    Fn    Length  Dictionary Definition  Offset  Length
 __  TRAN____ K  A  _______ ___        8  TRAN     DFHTASK C001   ___     ___
 __  PSBNAME_ K  A  _______ ___        8  PSBNAME  DBCTL   C001   ___     ___
 __  TASKCNT_       _______ ___        8  TASKCNT  CICSPA  X902   ___     ___
 __  RESPONSE       _______ AVE        8  RESP     CICSPA  D901   ___     ___
 __  CPU_____       TIME___ AVE        8  USRCPUT  DFHTASK S008   ___     ___
 __  DISPATCH       TIME___ AVE        8  USRDISPT DFHTASK S007   ___     ___
 __  SUSPEND_       TIME___ AVE        8  SUSPTIME DFHTASK S014   ___     ___
 __  POOLWAIT       _______ AVE        8  POOLWAIT DBCTL   A002   ___     ___
 __  INTCWAIT       _______ AVE        8  INTCWAIT DBCTL   A003   ___     ___
 __  SCHTELAP       _______ AVE        8  SCHTELAP DBCTL   A004   ___     ___
 __  DBIOELAP       _______ AVE        8  DBIOELAP DBCTL   A005   ___     ___
 __  PILOCKEL       _______ AVE        8  PILOCKEL DBCTL   A006   ___     ___
 __  DBIOCALL       _______ AVE        8  DBIOCALL DBCTL   A007   ___     ___
 __  DLICALLS       _______ AVE        8  DLICALLS DBCTL   A017   ___     ___
 __  EOR_____       _______ ___                                   ___     ___
 __  EOX_____       _______ ___                                   ___     ___
 __  APPLID__ K  *  _______ ___        8  APPLID   CICSPA  C903   ___     ___
 __  START___ K  *  TIMES__ ___        8  START    DFHCICS T005   ___     ___
This produces a report with the following format:
Figure 2. Performance Summary report: DBCTL activity
 V5R3M0                                                 CICS Performance Analyzer
                                                           Performance Summary
 
SUMM0001 Printed at 12:34:56 02/15/2015     Data from 15:58:47  2/19/2010 to 15:58:28  2/21/2010                       Page       1
*** All DBCTL transactions ***
 
                                Avg      Avg      Avg      Avg      Avg      Avg      Avg      Avg      Avg      Avg      Avg
Tran     PSB        #Tasks Response User CPU Dispatch  Suspend PoolWait   ICwait SchedElp DBIOElap PILockEl DBIOcall DLIcalls
                               Time     Time     Time     Time     Time     Time     Time     Time     Time    Count    Count
DLI0     DDLPSB51       16   9.3221    .0255    .5016   8.8205    .0000    .0000    .0104    .0000    .0000        0        0
DLI0     PSB99          13   1.4249    .5201    .7799    .6450    .0000    .0000    .0780    .0000    .0000        0        1
DLI0                    29   5.7820    .2472    .6264   5.1556    .0000    .0000    .0407    .0000    .0000        0        1
 
DLI1     DDLPSB51        4  26.4267    .0125    .8290  25.5977    .0000    .0000    .0041    .0000    .0000        0        0
DLI1     PSB99           1  95.2870   1.9511  16.4508  78.8363    .0000    .0000    .0050    .0000    .0000        0        1
DLI1                     5  40.1988    .4003   3.9534  36.2454    .0000    .0000    .0043    .0000    .0000        0        0
 
DLI2     DDLPSB51        4  19.3463    .0125    .2029  19.1433    .0000    .0000    .0040    .0000    .0000        0        0
DLI2     PSB99           1  91.8213   1.8717   2.0128  89.8085    .0000    .0000    .0010    .0000    .0000        0        1
DLI2                     5  33.8413    .3843    .5649  33.2764    .0000    .0000    .0034    .0000    .0000        0        0
Note: IMS™ Performance Analyzer (IMS PA) can provide a more comprehensive analysis of IMS DBCTL performance.