Previous Topic: Buffer Pool UtilizationNext Topic: BYPASS Parameter


MANAGEMENT RANKING Report

The following is the REPORT parameter syntax for designating the MANAGEMENT RANKING report.

Up to twenty requests for Management Ranking reports can be specified in a single run of CA IDMS Journal Analyzer.

Note: The following syntax contains all the keywords which are used for designating this report. However, only the keywords not previously defined will be described in detail.

 REPORT = RANK [ ,RANK# = number of items ]

 ┌              /ONL\ ┐
 │ ,RANKPROG =  <BTC> │
 └              \SYS/ ┘

 / ,RANKWHAT = item  \

 \ ,RANKITEM = nn    /

             /           \
             │ LOW       │
             │ HIGH      │
             │ LT: value │
 ,RANKHOW =  < LE: value >
             │ GT: value │
             │ GE: value │
             \           /

 ┌             / MEAN     \  ┐
 │ ,RANKVALU = < MEDIAN   >  │
 └             \ ABSOLUTE /  ┘

 [,START = start date/time ]

 [ ,STOP = stop date/time ]

 [ ,INTVL = length ]

where:

REPORT = RANK

indicates that a MANAGEMENT RANKING report is to be printed.

, RANK# = number of items

indicates the number of items to be ranked. The maximum number is 50. The default value is 20.

            /ONL \
,RANKPROG = <BTC >
            \SYS /

indicates the type of program to be used in the ranking.

ONL - indicates that only ONLINE programs are to be ranked.

BTC - indicates that only BATCH programs are to be ranked.

SYS - indicates that ONLINE and BATCH programs are to be ranked. This option is the default value.

, RANKWHAT = item

specifies the attribute to be ranked in the report. This keyword is mutually exclusive from the RANKITEM keyword. There is no default value.

, RANKITEM = nn

specifies a numeric identifier (1 to 13) for the attribute to be ranked. This keyword is mutually exclusive from the RANKWHAT keyword. There is no default value.

The following example shows Management Ranking Report Attributes:

RANKWHAT    RANKITEM   ATTRIBUTE

 #RU         1      #RUN UNITS (#BGIN)
 #SUCCESS    2      #SUCCESSFUL (#ENDJ)
 #ABORT      3      #ABORTED (#ABRT)
 %ABORT      4      %ABORTED (#ABRT/#BGIN)
 DURATION    5      DURATION
 REC-UPD     6      RECORDS UPDATED
 PG-READ     7      PAGES READ
 PG-WRITTEN  8      PAGES WRITTEN
 PG-10       9      PAGES WRITTEN + PAGES READ (TOTAL I/O'S)
 LOCK-REQ   10      LOCKS REQUESTED
 PG-RATIO   11      PAGES REQUESTED/PAGES READ
 CALC-RATIO 12      CALC RECORDS OVERFLOW/
                    RECORDS ON HOME PAGE
 VIA-RATIO  13      VIA RECORDS OVERFLOW/
                    RECORDS ON OWNER PAGE

           / LOW        \
           │ HIGH       │
           │ LT:value   │
,RANKHOW = < LE:value   >
           │ GT:value   │
           \ GE:value   /

specifies how the attribute is to be ranked.

LOW - the attribute will be ranked from its lowest value in an ascending order.

HIGH - the attribute will be ranked from its highest value in a descending order.

LT:value - the attribute will be ranked from a point less than the specified value in ascending order.

LE:value - the attribute will be ranked from a point less than or equal to the specified value in ascending order.

GT:value - the attribute will be ranked from a point greater than the specified value in ascending order.

GE:value - the attribute will be ranked from a point greater than or equal to the specified value in ascending order.

Note: If RANKITEM = 1, 2, 3, 4 or RANKVALU = MEAN or MEDIAN, then RANKHOW will default to HIGH if anything other than LOW is specified.

The specified values for LT, LE, GT, and GE must include two (2) decimal positions when ranking durations or ratios (e.g., duration of 5 seconds is 500; a ratio of 3.14 is 314).

Note: There is no default value for the RANKHOW operand.

/ MEAN \

,RANKVALU = < MEDIAN >

\ ABSOLUTE /

specifies the value type of the attribute to be ranked.

MEAN - indicates an average value for all executions of the ranked program.

MEDIAN - indicates a middle value for all executions of the ranked program.

ABSOLUTE - indicates a value from a single execution of the ranked program. This option is the default value.

Note: If RANKITEM = 1, 2, 3, or 4, then RANKVALU must be specified as ABSOLUTE.