Tabular Reports › Use Other Commands with the TAB Command › Define Groups by Values Within Specified Ranges

Define Groups by Values Within Specified Ranges

You can use the GROUP and RANGE commands together to produce a report on groups of resources whose activity falls within different ranges.

Example: GROUP and RANGE Commands

The following example uses both the GROUP and RANGE commands to define 13 groups of transactions in terms of their lifetimes:

 GROUP TRANID RANGE:00.000-01.000(*)  RANGE(TLIFE1)
 GROUP TRANID RANGE:01.001-02.000(*)  RANGE(TLIFE2)
 GROUP TRANID RANGE:02.001-03.000(*)  RANGE(TLIFE3)
 GROUP TRANID RANGE:03.001-04.000(*)  RANGE(TLIFE4)
 GROUP TRANID RANGE:04.001-05.000(*)  RANGE(TLIFE5)
 GROUP TRANID RANGE:05.001-06.000(*)  RANGE(TLIFE6)
 GROUP TRANID RANGE:06.001-07.000(*)  RANGE(TLIFE7)
 GROUP TRANID RANGE:07.001-08.000(*)  RANGE(TLIFE8)
 GROUP TRANID RANGE:08.001-09.000(*)  RANGE(TLIFE9)
 GROUP TRANID RANGE:09.001-10.000(*)  RANGE(TLIFE10)
 GROUP TRANID RANGE:10.001-20.000(*)  RANGE(TLIFE20)
 GROUP TRANID RANGE:20.001-50.000(*)  RANGE(TLIFE50)
 GROUP TRANID RANGE:50.001+(*)        RANGE(TLIFE50+)
 RANGE TRAN LIFE 0-1      ID TLIFE1
 RANGE TRAN LIFE 1-2      ID TLIFE2
 RANGE TRAN LIFE 2-3      ID TLIFE3
 RANGE TRAN LIFE 3-4      ID TLIFE4
 RANGE TRAN LIFE 4-5      ID TLIFE5
 RANGE TRAN LIFE 5-6      ID TLIFE6
 RANGE TRAN LIFE 6-7      ID TLIFE7
 RANGE TRAN LIFE 7-8      ID TLIFE8
 RANGE TRAN LIFE 8-9      ID TLIFE9
 RANGE TRAN LIFE 9-10     ID TLIFE10
 RANGE TRAN LIFE 10-20    ID TLIFE20
 RANGE TRAN LIFE 20-50    ID TLIFE50
 RANGE TRAN LIFE 50-99999 ID TLIFE50+
TAB TRANID(RANGE*) HDR1(TRAN LIFETIME) HDR2(RANGES),
  SORT ALPHA,
                    TRAN USE      AND,
                    TRAN USE PCT  AND,
                    TRAN LIFE     AND,
                    TRAN MAXLIFE  AND,
                    TERM RESP     AND,
                    TRAN CPU      AND,
                    TRAN I/OTIME  AND,
                    TRAN USERTIME AND,
                    TRAN CICSTIME
END
RUN

A report like the following is generated:

  TRAN LIFETIME       TRAN     TRAN     TRAN     TRAN     TERM     TRAN     TRAN     TRAN     TRAN
      RANGES           USE   %  USE     LIFE   MAX LIFE   RESP      CPU      I/O     USER     CICS
------------------- -------- -------- -------- -------- -------- -------- -------- -------- ------
RANGE:00.000-01.000   6981     80.4    0.207    0.999    0.170    0.052    0.053    0.000    0.000
RANGE:01.001-02.000    315      3.6    1.469    1.998    0.726    0.269    0.213    0.000    0.000
RANGE:02.001-03.000    140      1.6    2.502    2.993    1.006    0.356    0.200    0.000    0.000
RANGE:03.001-04.000     92      1.1    3.486    3.989    1.134    0.397    0.199    0.000    0.000
RANGE:04.001-05.000     55      0.6    4.417    4.928    1.380    0.499    0.367    0.000    0.000
RANGE:05.001-06.000     41      0.5    5.499    5.975    1.082    0.434    0.294    0.000    0.000
RANGE:06.001-07.000     40      0.5    6.401    6.847    1.295    0.377    0.092    0.000    0.000
RANGE:07.001-08.000     41      0.5    7.496    7.990    0.741    0.278    0.472    0.000    0.000
RANGE:08.001-09.000     12      0.1    8.545    8.950    0.700    0.419    0.074    0.000    0.000
RANGE:09.001-10.000     18      0.2    9.462    9.924    0.687    0.254    0.273    0.000    0.000
RANGE:10.001-20.000    217      2.5    15.80    19.95    0.445    0.232    0.055    0.000    0.000
RANGE:20.001-50.000     99      1.1    31.62    49.13    0.611    0.545    0.374    0.000    0.000
RANGE:50.001+          633      7.3     1182    46487    0.259    7.542    0.243    0.000    0.000
------------------- -------- -------- -------- -------- -------- -------- -------- -------- ------
SUMMARY               8684    100.0    87.43    46487    0.275    0.633    0.086    0.000    0.000
------------------- -------- -------- -------- -------- -------- -------- -------- -------- ------