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

Sample Report: REFGROUP Summary

Date: mm/dd/ccyy    ********************************************************************************         Page:     1
                    *                                 CA Datacom/DB                                *
Time: hh.mm.ss      *                                General Utility                               *      Release: 12
                    *                   Copyright © 2009 CA. All rights reserved.                  *               SPnn
                    ******************************************************************************** Directory: PRODCXX
 
                     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
        Ž

Œ

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.

Date: mm/dd/ccyy    ********************************************************************************         Page:     2
                    *                                 CA Datacom/DB                                *
Time: hh.mm.ss      *                                General Utility                               *      Release: 12
                    *                   Copyright © 2009 CA. All rights reserved.                  *               SPnn
Base:     2         ******************************************************************************** Directory: PRODCXX
 
                    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
 
    “

Œ

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



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

Ž

Rows/Blk (8 in this example) is the average rows within a REFGROUP per block.



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



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

‘

3 Rows (71,764 in this example) is the total number of data blocks with 3 rows for a REFGROUP, and so on through 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) is the total number of data blocks with 10 through 14 rows for a REFGROUP.

15+ Rows

(31,738 in this example) is 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) is the total number of data block with 30 through 39 rows for a REFGROUP.

40+ Rows

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

50+ Rows

(blank in this example) is 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.