Example: DBCTL

Sample Report Forms are provided to help you format a List report to show DBCTL transaction activity:
IMSDBLST
Transaction DBCTL Usage Analysis
IMSRQLST
Transaction DBCTL Req 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.
Figure 1. New Report Form - Select Field Categories: DBCTL
                         Select Field Categories                         
Command ===> ____________________________________________________________
                                                                         
CMF Groups:                                                              
/  DFHAPPL - Application naming     /  DFHJOUR - Journal                 
/  DFHBTS  - BTS                    /  DFHMAPP - BMS Maps                
/  DFHCHNL - CHANNEL option         /  DFHPROG - Program Control         
/  DFHCICS - CICS task information  /  DFHRMI  - Resource Manager (RMI)  
/  DFHDATA - Data processing        /  DFHSOCK - Secure Sockets          
/  DFHDEST - Transient Data         /  DFHSTOR - Storage Control         
/  DFHDOCH - Document Handler       /  DFHSYNC - Syncpoint processing    
/  DFHEJBS - EJB Server             /  DFHTASK - Task Control            
/  DFHFEPI - Front End (FEPI)       /  DFHTEMP - Temporary Storage       
/  DFHFILE - File Control           /  DFHTERM - Terminal Control        
                                    /  DFHWEBB - Web Interface           
Region Types:                                                            
_  AOR     - Application-owning     User Fields:                         
_  FOR     - File-owning            /  DBCTL   - IMS DBCTL               
_  TOR     - Terminal-owning        _  CROSSYS - Cross-System            
_  DB2     - AOR with DB2           _  OMCICS  - OMEGAMON                

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

Figure 2. LIST Report Form: DBCTL fields
                     EDIT LIST Report Form - DBCTLIST
 
     Field                                               - User Field -
     Name       Type      Length  Dictionary Definition  Offset  Length
 __  TRAN____   _______        4  TRAN     DFHTASK C001   ___     ___
 __  PSBNAME_   _______        8  PSBNAME  DBCTL   C001   ___     ___
 __  START___   TIMET__       12  START    DFHCICS T005   ___     ___
 __  RESPONSE   _______        8  RESP     CICSPA  D901   ___     ___
 __  CPU_____   TIME___        8  USRCPUT  DFHTASK S008   ___     ___
 __  DISPATCH   TIME___        8  USRDISPT DFHTASK S007   ___     ___
 __  SUSPEND_   TIME___        8  SUSPTIME DFHTASK S014   ___     ___
 __  POOLWAIT   _______        8  POOLWAIT DBCTL   A002   ___     ___
 __  INTCWAIT   _______        8  INTCWAIT DBCTL   A003   ___     ___
 __  SCHTELAP   _______        8  SCHTELAP DBCTL   A004   ___     ___
 __  DBIOELAP   _______        8  DBIOELAP DBCTL   A005   ___     ___
 __  PILOCKEL   _______        8  PILOCKEL DBCTL   A006   ___     ___
 __  DBIOCALL   _______        8  DBIOCALL DBCTL   A007   ___     ___
 __  DLICALLS   _______        8  DLICALLS DBCTL   A017   ___     ___
 __  EOR_____   _______                                   ___     ___
 __  EOX_____   _______                                   ___     ___
 
This will produce a report with the following format.
Figure 3. Performance List report: DBCTL transactions
 V5R1M0                                                 CICS Performance Analyzer
                                                            Performance List
 
LIST0001 Printed at 12:03:45 04/17/2013    Data from 15:58:48  2/19/2010                         APPLID CICPAOR1      Page       1
DBCTL transactions
 
 Tran PSB      Start        Response User CPU Dispatch  Suspend PoolWait   ICwait SchedElp DBIOElap PILockEl DBIOcall DLIcalls
               Time           Time     Time     Time     Time     Time     Time     Time     Time     Time
 DLI0 DDLPSB51 15:58:47.251   1.0479    .0483    .9427    .1052    .0000    .0000    .0079    .0000    .0000        0        0
 DLI0 DDLPSB51 15:58:49.634    .0615    .0118    .0168    .0447    .0000    .0000    .0034    .0000    .0000        0        0
 DLI0 DDLPSB51 16:51:16.979   1.4467    .0474   1.2820    .1648    .0000    .0000    .0080    .0000    .0000        0        0
 DLI0 DDLPSB51 16:58:03.662    .0934    .0114    .0176    .0758    .0000    .0000    .0034    .0000    .0000        0        0
 DLI0 DDLPSB51 16:58:04.244    .0933    .0114    .0161    .0772    .0000    .0000    .0035    .0000    .0000        0        0
 DLI2 DDLPSB51 17:00:16.874   3.0710    .0110    .1065   2.9644    .0000    .0000    .0034    .0000    .0000        0        0
 DLI7 DDLPSB51 17:00:17.180   3.0274    .0116    .1441   2.8833    .0000    .0000    .0245    .0000    .0000        0        0
 DLI3 DDLPSB51 17:00:17.212   3.2297    .0129    .0108   3.2189    .0000    .0000    .0056    .0000    .0000        0        0
 DLI4 DDLPSB51 17:00:17.213   3.7488    .0109    .0112   3.7375    .0000    .0000    .0036    .0000    .0000        0        0
 DLI9 DDLPSB51 17:00:17.217  18.7260    .0108   2.8553  15.8707    .0000    .0000    .0034    .0000    .0000        0        0
 DLI1 DDLPSB51 17:00:17.218  18.8168    .0131    .0227  18.7941    .0000    .0000    .0041    .0000    .0000        0        0
 DLI0 DDLPSB51 17:00:17.217  18.9042    .0130   2.7601  16.1441    .0000    .0000    .0034    .0000    .0000        0        0
  . . .
 DLI0 DDLPSB51 13:14:14.187    .5046    .0439    .1369    .3676    .0000    .0000    .0035    .0000    .0000        0        0
 DLI0 PSB99    13:01:22.918   5.9288   2.1340   3.8341   2.0947    .0000    .0000   1.0004    .0000    .0000        0        2
 DLI0 PSB99    13:17:35.232   3.5302   2.1659   2.7387    .7914    .0000    .0000    .0010    .0000    .0000        0        2
 DLI0 PSB99    13:45:38.833   3.4382   2.1744   2.4742    .9640    .0000    .0000    .0010    .0000    .0000        0        2
 DLI0 PSB99    13:48:16.354   1.0711    .0428    .2282    .8429    .0000    .0000    .0024    .0000    .0000        0        1
 DLI0 PSB99    13:48:24.131    .2516    .0118    .0184    .2332    .0000    .0000    .0010    .0000    .0000        0        1
 DLI0 PSB99    13:48:25.012    .3658    .0117    .0168    .3490    .0000    .0000    .0011    .0000    .0000        0        1
 DLI0 PSB99    13:48:25.963    .3745    .0118    .0174    .3571    .0000    .0000    .0010    .0000    .0000        0        1
 DLI0 PSB99    13:48:26.919    .2871    .0116    .0180    .2691    .0000    .0000    .0010    .0000    .0000        0        1
 DLI0 PSB99    13:48:27.907    .2511    .0117    .0170    .2341    .0000    .0000    .0010    .0000    .0000        0        1
 DLI0 PSB99    15:36:20.458    .7925    .0451    .2664    .5261    .0000    .0000    .0010    .0000    .0000        0        1
 DLI0 PSB99    15:38:29.047    .6985    .0466    .1953    .5032    .0000    .0000    .0011    .0000    .0000        0        2
 DLI0 PSB99    15:38:50.508    .5742    .0457    .1260    .4482    .0000    .0000    .0010    .0000    .0000        0        2
 DLI0 PSB99    15:49:07.072    .9596    .0486    .1879    .7717    .0000    .0000    .0010    .0000    .0000        0        2
 DLI2 PSB99    15:53:29.716  91.8213   1.8717   2.0128  89.8085    .0000    .0000    .0010    .0000    .0000        0        1
 DLI3 PSB99    15:53:30.402  156.501   1.9866  24.4980  132.003    .0000    .0000    .0055    .0000    .0000        0        1
 DLI5 PSB99    15:53:30.497  233.355   1.9771  18.1590  215.196    .0000    .0000    .0049    .0000    .0000        0        1
 DLI1 PSB99    15:56:53.478  95.2870   1.9511  16.4508  78.8363    .0000    .0000    .0050    .0000    .0000        0        1
Note: IMS™ Performance Analyzer (IMS PA) can provide a more comprehensive analysis of IMS DBCTL performance.

Information Information

Feedback


Timestamp icon Last updated: Thursday, 7 November 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//report-reference/cparr50.htm