Workload Overview Report

The idea for the Workload Overview report is to monitor the CPU utilization for your most important service classes.

The template for the Overview Records contains the overview control statements for workload utilization (APPLPER) and EXCP rate (EXCPRT) for one service class. You have to define these statements for each selected service class. In addition, the total workload utilization and EXCP rate, as well as the CPU utilization and the number of processors is added at the end of the template. The EXCP rate and the total numbers are used to calculate and distribute the uncaptured CPU time across the service classes.

Template:

                           -----------------------
OVW(CPUclass(APPLPER(S.class.p)))      This part must be repeated for each service
OVW(EXPclass(EXCPRT(S.class.p)))       class; replace class by a service class name

OVW(MPLclass(TRANSAVG(S.class.p)))     These conditions can be added optionally
OVW(TOTclass(TRANS(S.class.p)))        and are exploited only with Excel
OVW(RTMclass(RTIME(S.class.p)))
OVW(EVLclass(EXVEL(S.class.p)))
                           -----------------------
OVW(NUMPROC(NUMPROC))                  This part is fixed and must be added
OVW(CPUBUSY(CPUBSY))                   at the end of the report
OVW(APPLPER(APPLPER(POLICY)))
OVW(EXCPRT(EXCPRT(POLICY)))

The basic control set with the two conditions APPLPER and EXCPRT can be enhanced by up to four conditions for each service class. The corresponding Excel spreadsheet macros can process the Overview Records with or without the additional information. If you do not specify all information, some of the reports in the macro show that no information is available for display. Otherwise the functionality of the macros is not restricted.

In order to use the additional control statements you must adhere to the following rules:

• Whenever you add additional control statements, you must add them for all service classes contained in the control set.
• It is not necessary to add all four statements, you can add and combine them in the following three groups:

  1. Information about transactions:

  TRANSAVG

  Average number of active transactions

  TRANSMPL

  Average number of resident transactions

  2. You must always specify the following two exceptions in common:

  TRANS

  Number of ended transactions per second

  RTIME

  Transaction execution time

  TRANSTOT

  Total number of ended transactions

  RTIMETOT

  Total transaction time (execution and queue time)

  3. Execution velocity

  EXVEL

  Execution Velocity

  This means that you can add them all for all service classes, or any combination of the three groups for all service classes. Only keep in mind that you must always add the same conditions for all service classes.

• When you add the additional definitions, it is required to add them in the sequence listed above. Also make sure that the prefix of the column header is always MPL, TRX, RTM and EVL.
• You can use the macro Create Overview Control Statements to generate the control statements for your favorite service classes and workloads. You can also specify report classes instead of service classes.
  To specify a report class TSOR, use:

  OVW(CPUTSOA1(APPLPER(R.TSOR.1)))

  To specify a service class TSOS, use:

  OVW(CPUTSOA1(APPLPER(S.TSOS.1)))

If you want to report service class CICS® and the first and second period of service class TSO, you have to define the records as follows:

OVW(CPUCICS(APPLPER(S.CICS.1)))
OVW(EXPCICS(EXCPRT(S.CICS.1)))
OVW(MPLCICS(TRANSAVG(S.CICS.1)))
OVW(TOTCICS(TRANS(S.CICS.1)))
OVW(RTMCICS(RTIME(S.CICS.1)))
OVW(CPUTSO1(APPLPER(S.TSO.1)))
OVW(EXPTSO1(EXCPRT(S.TSO.1)))
OVW(MPLTSO1(TRANSAVG(S.TSO.1)))
OVW(TOTTSO1(TRANS(S.TSO.1)))
OVW(RTMTSO1(RTIME(S.TSO.1)))
OVW(CPUTSO2(APPLPER(S.TSO.2)))
OVW(EXPTSO2(EXCPRT(S.TSO.2)))
OVW(MPLTSO2(TRANSAVG(S.TSO.2)))
OVW(TOTTSO2(TRANS(S.TSO.2)))
OVW(RTMTSO2(RTIME(S.TSO.2)))
OVW(NUMPROC(NUMPROC))
OVW(CPUBUSY(CPUBSY))
OVW(APPLPER(APPLPER(POLICY)))
OVW(EXCPRT(EXCPRT(POLICY)))