REPORT (Generate Reports) › REFGROUP Report › Sample Report: REFGROUP Summary

Sample Report: REFGROUP Summary

                     CONTROL CARD(S)
 
 .........1.........2.........3.........4.........5.........6.........7.........8
                      REPORT   REFGROUP=2,DBID=2,TABLE=ALS,TYPE=S
                      FUNCTION=REPORT
                         DBID=00002
                         REFGROUP=00002
                         TABLE=ALS
                         TYPE=S
          

This page of the report shows the following:

• The command exactly as entered.
• An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.
• Any messages related to syntax processing.

                    Table Block Usage Report by Reference Group
             Rows   Ref      1     2     3     4     5     6     7     8     9   10+   15+   20+   25+   30+   40+   50+
Groups  Rows /Blk  Blks    Row  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows  Rows
698181                 609,196      71,784      27,918      17,238      11,804      31,738      27,235       7,293
  12,499,845    8            224,261      41,954      21,943      13,965      43,569      27,540     218,924

This page of the report shows the following:

Groups

(698181 in this example) Displays the total number of REFGROUPs for this table, based on the value coded for REFGROUP.

Rows

(12,499,845 in this example) Displays the total rows in the table.

Rows/Blk

(8 in this example) Displays the average rows within a REFGROUP per block.

1 Row

(609,196 in this example) Displays the total number of data blocks with only 1 row for a REFGROUP.

2 Rows

(224,261 in this example) Displays the total number of data blocks with 2 rows for a REFGROUP.

3 Rows

(71,764 in this example) Displays the total number of data blocks with 3 rows for a REFGROUP, and so on through 9 Rows (11,804 in this example), the total number of data blocks with 9 rows for a REFGROUP.

The remainder of the Rows descriptions are as follows:

10+ Rows

(43,569 in this example) Displays the total number of data blocks with 10 through 14 rows for a REFGROUP.

15+ Rows

(331,738 in this example) Displays the total number of data blocks with 15 through 19 rows for a REFGROUP, and so on through 25+ Rows (27,235 in this example), the total number of data blocks with 25 through 29 rows for a REFGROUP.

30+ Rows

(218,924 in this example) Displays the total number of data block with 30 through 39 rows for a REFGROUP.

40+ Rows

(7,293 in this example) Displays the total number of data block with 40 through 49 rows for a REFGROUP.

50+ Rows

(blank in this example) Displays the total number of data block with 50 or more rows for a REFGROUP.

If a table is not defined with compression there is also a line below those shown in the example report. That line, "Maximum Possible Rows per Block," includes a number that can be used to help analyze the values printed for rows and to know how well ordered your data is by REFGROUP.