System Output › Comparative SR8 Index Report › Table Entry Distribution Section Fields

Table Entry Distribution Section Fields

The Distribution Section of the Comparative SR8 Index Report is shown in the following display. See the SR8 Index Report for descriptions of fields not discussed here.

 CA-TOOLS        RELEASE                CA IDMS/DB ANALYZER                                 DATE          TIME     PAGE
                 Rnn.nn                   SR8 INDEX REPORT                                dd/mm/yy      hh:mm:ss   nnnn
                                   TABLE ENTRY DISTRIBUTION SECTION
                                             COMPARATIVE

 INDEX NAME:  IX-STUD-LNAME
 NEW FILE CREATION DATA:  mm/dd/yy  -  hh:mm:ss
 OLD FILE CREATION DATA:  mm/dd/yy  -  hh:mm:ss
 ITEM                             RANGE          NEW     PCT          OLD     PCT        VARIANCE    PCT
 -----------------------------  ----------       ---    ----         -----    ---        --------    ---
 UPPER LVL TBL ENTRIES USED     TABLE ENTRIES    # OF OCCURRENCES
                                 0 -    0         0       0            0       0             0        0
                                 1 -    1         0       0            0       0             0        0
                                 2 -    2         2      50           11      69            -9       19
                                 3 -    3         2      50            5      31            -3       19
 BOTTOM LVL TBL ENTRIES USED     TABLE ENTRIES    # OF OCCURRENCES
                                 0 -    0         0       0            0       0             0        0
                                 1 -    1         0       0            0       0             0        0
                                 2 -    2         5      71           15      68           -10        3
                                 3 -    3         2      29            7      32            -5        3 

1 NEW PCT--The values listed under this heading are raw counts and percentages for each range. These values are taken from the new statistics file. See Comparative SR8 Index Report Identification Fields, item 2.

2 OLD PCT--The values listed under this heading are raw counts and percentages for each range. These values are taken from the old statistics file. See Comparative SR8 Index Report Identification Fields, item 3.

3 VARIANCE PCT--Listed under this heading are the differences between new and old raw counts and the percent variance between the old and new values. Positive values indicate the amount by which new statistical file values are greater than old. Negative values indicate the amount by which new file values are less than old file values.

For variance to be meaningful, both the old and new statistical files must contain identical ranges. If they do not, no values are listed under this heading.