Previous Topic: ERXT0365/EZXT0365: WLM Goal Mode Report - Storage and Page-in Rates

Next Topic: ERXT0367/EZXT0367: WLM Goal Mode Report - Execution Delays

ERXT0366/EZXT0366: WLM Goal Mode Report - Performance Analysis by Workload

This report provides information collected by RMF (EXTDATA type R72W) about performance goals and actual performance as viewed by WLM. The data is totaled over all available intervals, and broken down by service class period, service class, and workload. Only service classes are reported.

This report can be used as an overview of service classes that don't meet their goals and need to be tuned.

The fields in the report are as follows:

IMPORTANCE

Workload importance.

GOAL TYPE

Type of goal: RESPPCNT (response time percentile), RESPAVG (average response time), EXECVEL (execution velocity), DISCRET (discretionary) or SYSTEM. MIXED on the total line means that the goals are different, so some summary values may not make sense.

COMPLTD TRANS

Total number of transactions completed over the period covered.

PERF INDEX

Number indicating if the goal is met and how well. If less than or equal to 1, the goal is being met (the less the better). If greater than 1, the goal is not being met.

Note: For response time percentile goal, the performance index is computed differently than WLM computes it, but the above still holds.

AVG RESP TIME

Average transaction response time.

GOAL RESP TIME

Goal transaction response time. For average response time goal, this is the target average transaction response time. For response time percentile goal, this is the time that the defined percentage of transactions must attain in order to satisfy the goal. This number is not defined for other goal types.

RESP PCT

Response time percentile. This is the percentage of transactions that have response time lower than the goal response time.

Note: The goal response time is defined differently depending on the goal type.

GOAL PCT

Goal response time percentile. It is the goal value for response time percentile, and is only defined for response time percentile goal.

EXEC VEL

Actual execution velocity. It is the percentage of time that was spent doing useful work to total time.

GOAL VEL

Goal execution velocity, only defined if the workload has execution velocity goal.

USING/DELAY SAMPS

Percentages of samples during which this work was found executing and found delayed.

AVG ADDR SPACES

Average number of address spaces active at one time for this work.

1 1/07/yy           WLM GOAL MODE REPORT - PERFORMANCE ANALYSIS BY WORKLOAD                                              PAGE 1  REPORT ID: EZXT0366                                    SYSPLEX:  PLEXC1  SOURCE   : SMF 72-3                                     POLICY:  PLEXT1  FROM DATE: yy/12/12                                  FROM TIME:  23:59:00    TO DATE: yy/12/13                                    TO TIME:  23:44:00 -  WORKLOAD  CLASS SERVICE           GOAL    COMPLTD    PERF    AVG RESP   GOAL RESP   RESP  GOAL  EXEC  GOAL USING DELAY AVG ADDR    NAME     NAME PERIOD IMPORTANCE TYPE     TRANS    INDEX      TIME        TIME     PCT   PCT   VEL   VEL  SAMPS SAMPS  SPACES 0BATCHPRD BATCHPRD   1    LOW    EXECVEL         77   150.0      1:16.78                           0.1  15.0   0.1  97.6    0.3  BATCHPRD BATCHPRD        LOW    EXECVEL         77   150.0      1:16.78                           0.1  15.0   0.1  97.6    0.3 0BATCHPRD                 LOW    EXECVEL         77   150.0      1:16.78                           0.1  15.0   0.1  97.6    0.3 0BATCHTST BATCHTST   1    VLOW   EXECVEL         28    50.0   8:11:29.90                           0.2  10.0   0.2  87.4    7.9  BATCHTST BATCHTST        VLOW   EXECVEL         28    50.0   8:11:29.90                           0.2  10.0   0.2  87.4    7.9 0BATCHTST BATSTWLM   1    MED    EXECVEL      18247     9.6     47:59.61                           3.1  30.0   0.0   1.4    0.4  BATCHTST BATSTWLM   2    LOW    EXECVEL     160568     5.4      5:39.71                           3.7  20.0   2.1  55.1   41.2  BATCHTST BATSTWLM   3    VLOW   EXECVEL       3936    20.0      5:06.82                           0.5  10.0   0.4  91.8   10.8  BATCHTST BATSTWLM        MED    EXECVEL     182751    20.0      9:52.61                           1.0  20.0   0.1  13.5    7.1 0BATCHTST                 LOW    EXECVEL     182779    25.0      9:57.03                           0.7  17.5   0.1  18.2   10.9 0DATABASE DATABASE   1    MED    EXECVEL        457     2.2     54:52.75                           9.0  20.0   0.0   0.9   47.7  DATABASE DATABASE        MED    EXECVEL        457     2.2     54:52.75                           9.0  20.0   0.0   0.9   47.7 0DATABASE DATABSQA   1    MED    EXECVEL          1   999.0         9.93                                25.0   0.0  24.1    0.2  DATABASE DATABSQA        MED    EXECVEL          1   999.0         9.93                                25.0   0.0  24.1    0.2 0DATABASE DATBSHOT   1    HIGH   EXECVEL         49     0.7     39:12.60                          39.9  30.0   0.2   0.3   47.7  DATABASE DATBSHOT        HIGH   EXECVEL         49     0.7     39:12.60                          39.9  30.0   0.2   0.3   47.7 0DATABASE                 HIGH   EXECVEL        507     2.4     53:15.41                          10.3  25.0   0.1   0.8   95.8 0DDFDB2   DDFDB2     1    MED    RESPPCNT     45819     0.8         2.29        5.00  99.4  80.0  31.8         2.0   4.4   28.1  DDFDB2   DDFDB2     2    LOW    EXECVEL         61     1.2      3:54.41                          24.8  30.0   1.9   6.0    5.3  DDFDB2   DDFDB2     3    NONE   DISCRET          1     1.0      1:26.11                          39.7        12.3  18.6    0.2  DDFDB2   DDFDB2          MED    MIXED        45881     0.0         2.60              99.3        29.2         2.0   4.9   33.7 0DDFDB2                   MED    MIXED        45881     0.0         2.60              99.3        29.2         2.0   4.9   33.7 0DISCRET  DISCRET    1    NONE   DISCRET        107     1.0   1:03:07.20                                       0.0  56.8   30.9  DISCRET  DISCRET         NONE   DISCRET        107     1.0   1:03:07.20                                       0.0  56.8   30.9 0DISCRET                  NONE   DISCRET        107     1.0   1:03:07.20                                       0.0  56.8   30.9 0ONLINE   ONLPROD    1    MED    EXECVEL          2   999.0         8.59                                25.0   0.0  62.8    0.2  ONLINE   ONLPROD         MED    EXECVEL          2   999.0         8.59                                25.0   0.0  62.8    0.2 0ONLINE   ONLTEST    1    MED    EXECVEL        100     1.0   6:52:53.59                          14.7  15.0   0.3   1.9   46.4  ONLINE   ONLTEST         MED    EXECVEL        100     1.0   6:52:53.59                          14.7  15.0   0.3   1.9   46.4 0ONLINE                   MED    EXECVEL        102     1.0   6:44:48.00                          14.7  15.1   0.3   1.9   46.9