3. REPORTS › 3.1 MICF Inquiries › 3.1.1 Service Analysis Inquiries › 3.1.1.1 CICCDB: Daily CICS Service Ranking

3.1.1.1 CICCDB: Daily CICS Service Ranking

The Daily CICS Service Ranking inquiry produces a color
graph which identifies the top 10 CICS applications that have
received the worst average response time in a given day.

REPORT FORMAT:

This inquiry produces a side-by-side horizontal bar chart
which shows the top 10 applications with the worst average
response time.  The chart also shows the transaction volume
for each of the 10 applications in the same order as the
response ranking.  By default, only one chart is produced for
all input data which is summarized across SYSIDs and CICSIDs.
To produce a ranking graph for a specific system or CICS
region, you must specify the value for SYSID, CICSID, or
CENTER at inquiry execution time.  See the description below
for execution-time parameters.


INQUIRY ID:

     CICCDB (color graphic format)

DATA SOURCE (file/timespan):

     CICCAU01 in the DAYS timespan.


     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:

     CAUTRANS - Transactions Processed
     CAUTRSTM - Transaction Response Time Total
     CICAPU   - CICS Application Unit ID
     CICSID   - CICS System Identifier
     DAY      - Day of Month
     MONTH    - Month of Year
     SYSID    - System Identifier
     YEAR     - Year of Century
     ZONE     - Time Zone

   CALCULATIONS:

     Average response time = CAUTRSTM/CAUTRANS

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.



     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.


     CENTER - Optionally, specify the CENTER to be reported.
              If no value is specified, the value *ALL is
              used which causes all CENTERs found in input to
              be summarized together.  CENTER is a logical
              grouping of SYSIDs which you assign in the
              global exit %GCNTR.  If this exit is not
              defined, CENTER is set to the value of SYSID.


     DATE   - Optionally, enter the date to be reported in
              ddmmmyy format.

              For this inquiry, the default is yesterday.

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


     RESP   - Optionally, select the type of responses to be
              ranked.  The response types are AVG, SHORT,
              MED, LONG, or CONV.  The default value is AVG
              which produces ranking by average response
              seconds.


     DEVICE - Optionally, override the default colors and
              patterns used by specifying a different device
              type.  The default is TERMINAL.  Because the
              code for color graphics is not generated by
              MICF, the device parameter you specified in
              MICF is not applicable here.


     FOOTNOTE-Optionally, specify whether or not the MICF
              inquiry ID should be displayed as a footnote on
              the graph.  The default value is NO.


     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.