Previous Topic: 3.1.2.29 CICLML: Monthly CICS Workload Summary Report

Next Topic: 3.1.3 Performance Analysis Inquiries

3.1.2.30 CICLMM: Monthly CICS Workload Detail Report

The Monthly CICS Workload Detail Report display CICS activity
at the application level and provides workload
characteristics and application profile information.  It also
provides a summary section which shows CICS activity by hour
and the top application in transaction volume for each hour.

REPORT FORMAT:

This inquiry produces a tabular report which provides a
summary section and a detail section for each combination of
SYSID and CICSID.  The summary section shows CICS activity
for each hour.  The detail section shows the transaction
processed by each application in each CICS region on each
system, and provides profile information such as average CPU,
average file control calls, average DBMS calls, and average
storage used.

A sample output of this inquiry is shown in Figure 3-30.
Each field in the report is described below:

SYSTEM SUMMARY:

# REGIONS:  Total number of SYSID/CICSID combinations found
            in input.


TRANS:      The total number of transactions processed,
            excluding those assigned as TRANTYPE X in your
            CICRLRT exit in prefix.MICS.PARMS.


%SHORT:     The percentage of short transactions processed.


%MED:       The percentage of medium transactions processed.


%LONG:      The percentage of long transactions processed.


% CONV:     Percentage of conversational transactions
            processed.


AVG RESP:   The average response time for all transactions,
            excluding those assigned as TRANTYPE X in your
            CICRLRT exit in prefix.MICS.PARMS.


CPU:        The total TCB CPU time consumed.


AVG         The average number of file control calls issued
FC CALLS:   per transaction.


AVERAGE     The  average  number  of input and out characters
CHAR:       per transaction generated by this application.


TOP APPL:   The application for which CICS processed the
            highest number of transaction in an hour.


TOP TRANS:  The total number transactions processed in an
            hour for the top application.


TOP RESP:   The average response time received by the top
            application for the hour.


TOP CPU:    The average TCB CPU time consumed by the top
            application for the hour.


TOP AVG     The average number of file control calls issued
FC CALLS:   per transaction by the top application.


TOP AVG     The average number of input and output characters
CHAR:       generated per transaction by the top application.


TOP AVG     The average number of input and output messages
MSG:        generated per transaction by the top application.

DETAIL SECTION:


SYSID:      System identification. This field is set to ALL
            for data that is summarized for all systems.


CICSID:     CICS system identification as assigned by
            CA MICS.  This field is set to ALL if the data is
            summarized for all CICS regions.


APPL:       Application identification.


TRANS:      The total number of transactions processed. For
            TYPE=ALL, this number excludes transaction type X
            (TRANTYPE=X as assigned by the CICRLRT exit).


AVG RESP:   The average response time for the transactions
            processed.  For TYPE=ALL, this number excludes
            transaction type X (TRANTYPE=X as assigned by the
            CICRLRT exit).


TOTAL CPU:  The total TCB CPU time consumed by all
            transactions, excluding transaction type X.


FC CALLS:   The total number of file control calls issued by
            this application.


DBMS CALLS: The total number of data base calls (DB2 and IMS)
            issued by this application.


TOT CHARS:  The total number of input and output characters
            generated by this application.


MAX         The maximum amount (in 1024 bytes) of terminal
STORAGE:    and user storage used by this application.


AVERAGE     The average TCB CPU per transaction  consumed  by
CPU:        this application.


AVERAGE     The average number of file control calls per
FC CALLS:   transaction issued by this application.


AVERAGE     The average number of data base (DB2 and IMS)
DBMS CALLS: calls per transaction issued by this application.


AVERAGE     The  average  number  of input and out characters
CHAR:       per transaction generated by this application.


AVERAGE     The average amount of dynamic storage (terminal
STORAGE:    and user) per transaction consumed by this
            application.


% ABND:     The percentage of transactions that abended for
            this application.

INQUIRY ID:

     CICLMM (tabular report)

DATA SOURCE (file/time-span):

     CICCAU01 in the MONTH time-span.

     If the CICCAU (CICS Application Unit Activity) file is
     not active, the CICCSU (CICS User Activity) file will be
     used for reporting.  The variable CICACT2 will be used
     in place of the variable CICAPU.

DATA ELEMENTS USED:

     CICAPU   - CICS Application Unit ID
     CICSID   - CICS System Identifier
     CAUABEND - Abnormal Termination Occurrences
     CAUCTRN  - Conv. Transactions Processed
     CAUETRN  - Excluded Transactions
     CAUDLICC - Number of CICS DL/I Calls
     CAUFCOPS - Number of CICS File Control Calls
     CAUINCH  - Input Message Character Traffic
     CAULTRN  - Long Transactions Processed
     CAUMEMRC - Memory Usage Running Count
     CSUMTRN  - Medium Transactions Processed
     CAUMXMEM - Maximum Transaction Storage Used
     CAUOUTCH - Output Message Character Traffic
     CAUCPUTM - Task CPU Time
     CAUSQLTO - Total number of SQL Calls
     CSUSTRN  - Short Transactions Processed
     CAUTRANS - Transactions Processed
     CAUTRSTM - Transaction Response Time Total
     MONTH    - Month of Year
     YEAR     - Year of Century
     ZONE     - Time Zone
     SYSID    - System Identifier

   CALCULATIONS:

     Average response time = CAUTRSTM/CAUTRANS
     Average character = SUM(CAUINCH,CAUOUTCH)/
                         SUM(CAUTRANS,CAUETRN)
     Average CPU time = CAUCPUTM/CAUTRANS
     Average DBMS calls = SUM(CAUDLICC,CAUSQLTO,CICPCT01)/
                          SUM(CAUTRANS,CAUETRN)
     Average file control calls = CAUFCOPS/
                          SUM(CAUTRANS,CAUETRN)
     Average storage = CAUMEMRC/SUM(CAUTRANS,CAUETRN)
     Percent abend = CAUABEND/SUM(CAUTRANS,CAUETRN)
     Percent conv. = CAUCTRN/SUM(CAUTRANS,CAUCTRN)
     Percent long  = CAULTRN/SUM(CAUTRANS,CAUETRN)
     Percent medium= CAUMTRN/SUM(CAUTRANS,CAUETRN)
     Percent short = CAUSTRN/SUM(CAUTRANS,CAUETRN)

EXECUTION-TIME PARAMETERS:

     UNIT   - Select one or more CA MICS data base units by
              entering the data base IDs.  Enter multiple IDs
              with a blank following each ID value.


     CYCLE  - Optionally, define CA MICS input file cycle
              range.

              For this inquiry, the default is the 01 cycle.


     SYSID  - Optionally, specify the SYSID to be reported.
              If no value is specified, the value *ALL is
              used. It causes all SYSIDs found in input to
              be summarized together.


     CICSID - Optionally, specify the CICSID to be reported.
              If no value is specified, the value *ALL is
              used which causes all CICSIDs found in input to
              be summarized together.


     MONTH  - Optionally, enter the month (mm) and year (yy)
              to be reported.

              For this inquiry, the default is previous
              month.

     ZONE   - Optionally, select one or more CA MICS time
              zones.  Valid values are numbers 1 through 9.


     FILE ID- Optionally, select the CICCSU file as input
              when the CICCAU file is active.  If you specify
              this parameter, then you must also specify the
              next parameter to indicate which account code
              (CICACT1-CICACT9) identifies your CICS
              application.


     CICAPU - Optionally, replace CICAPU with any of the
              CICACTx data elements, where x is 1 to 9.  This
              parameter must be specified in conjunction with
              FILE ID.

USER EXITS:

     If the MICF execution-time parameters are insufficient
     to select the data you need, you can invoke one of the
     following global exits to further manipulate the input
     file.  Additionally, you can override the global exit
     definitions in MICF using independent source statements.
     For detailed information on coding the exits, refer to
     Section 3.2 of this guide.

     The global exits are defined by macros in the source
     module CICRPTGL in sharedprefix.MICS.SOURCE.  The
     following exits are available to this inquiry:

     %GAPPL  - Define your CICS application based on any
               variable in the input file.  The default is
               CICAPU.


     %GCIC  -  Select CICSIDs for report.


     %GCNTR -  Assign value to the variable CENTER which
               defines the logical grouping of SYSIDs.
               CENTER is set to SYSID by default.


     %GSYS  -  Select SYSIDs for report.

     In addition to the above exits, the module CICRPTGL also
     contains macro variables which set default values for
     service level objectives.  Please see Section 3.2 to
     override the default values.

MONTHLY CICS WORKLOAD SUMMARY REPORT your_company_name FOR AUGUST, 1991 INQUIRY: CICLMM RUN DATE: 06SEP91 -----------------------------------------------------SYSID=PRD2 CICSID=LCP1------------------------------------------------------ TOTAL AVG TOT FILE CNTL DBMS TOT CHARS MAX -------------- AVERAGES -------------- % APPL TRANS RESP CPU CALLS CALLS (000) STORAGE CPU FC CL DBMS CL CHAR STORAGE ABND AAON 1 34.10 0:00 1 0 0 157K 0.08 1 0 0 157K 0 ACFM 163 0.02 0:00 0 0 162 72K 0.01 0 0 994 70K 0 CATD 15,759 0.07 0:02 0 0 0 297K 0.01 0 0 0 301K 0 CCMF 233 0.00 0:00 0 0 0 4K 0.00 0 0 0 4K 0 CEDA 21 0.20 0:00 82 0 13 282K 0.01 4 0 639 205K 0 CEMT 10 0.07 0:00 0 0 3 91K 0.01 0 0 347 90K 0 CRSQ 3 0.27 0:00 0 0 0 4K 0.00 0 0 0 4K 0 CRSR 29,214 0.02 0:01 0 0 0 11K 0.00 0 0 0 11K 0 CRTE 691 0.02 0:00 0 0 258 11K 0.00 0 0 373 11K 0 CSAC 350 0.00 0:00 0 0 33 11K 0.00 0 0 94 10K 0 CSFU 1 0.83 0:00 0 0 0 35K 0.01 0 0 0 35K 0 CSGM 16,516 0.03 0:01 84 0 14931 10K 0.00 0 0 904 9K 0 CSIR 61 47.96 0:00 0 0 0 5K 0.00 0 0 6 5K 0 CSMI 11 0.01 0:00 0 0 4 10K 0.00 0 0 396 10K 0 CSNE 23,797 0.00 0:01 0 0 0 27K 0.00 0 0 0 27K 0 CSSF 38 0.01 0:00 0 0 10 19K 0.00 0 0 268 19K 0 CSSN 6 0.03 0:00 0 0 4 19K 0.00 0 0 597 19K 0 DATA 14,588 0.14 0:01 21 0 9544 197K 0.00 0 0 654 16K 0 DISP 1 0.03 0:00 0 0 0 13K 0.02 0 0 314 13K 1 D2DA 15 1.42 0:00 0 0 21 16K 0.00 0 0 1425 39K 0 ELON 10 0.24 0:00 0 0 8 198K 0.01 0 0 784 126K 0 EL00 40 0.06 0:00 0 0 35 8K 0.00 0 0 875 7K 0 EL10 9 0.04 0:00 0 0 6 8K 0.00 0 0 631 6K 0 EL20 41 0.15 0:00 0 0 54 8K 0.00 0 0 1322 7K 0 EL22 50 0.14 0:00 0 0 57 8K 0.00 0 0 1150 8K 0 EL29 21 0.11 0:00 0 0 21 8K 0.00 0 0 1011 7K 0 EL30 14 0.07 0:00 0 0 7 8K 0.00 0 0 491 6K 0 EZ 324 0.46 0:00 0 0 519 197K 0.00 0 0 1602 14K 0 IEOL 1,346 0.25 0:00 0 0 1147 13K 0.00 0 0 852 13K 0 LLTP 1 0.01 0:00 0 0 0 12K 0.00 0 0 136 12K 1 LLXW 4 0.04 0:00 0 0 1 11K 0.01 0 0 273 12K 1 LPKD 3 0.00 0:00 0 0 1 10K 0.00 0 0 376 8K 0 LPKE 12 0.00 0:00 0 0 18 8K 0.00 0 0 1460 8K 0 MSAS 69 0.17 0:00 0 0 69 8K 0.00 0 0 1007 11K 0 MSA2 3,240 0.13 0:00 57 0 5251 8K 0.00 0 0 1621 8K 0 SA 39 0.48 0:00 21 0 36 198K 0.00 1 0 927 90K 0 STAR 21 0.00 0:00 0 0 29 8K 0.00 0 0 1399 9K 0 TOSC 344,062 0.13 0:11 42 0 416132 8K 0.00 0 0 1209 8K 0 TOSS 2,558 0.40 0:00 0 0 3937 198K 0.01 0 0 1539 132K 0 TOS1 8,580 0.38 0:01 0 0 13190 197K 0.01 0 0 1537 135K 0 TOTAL: 469,835 0.12 0:18 308 0 465952 297K 0.00 0 0 992 22K 0