Previous Topic: Distribution Section FieldsNext Topic: Comparative Area Report


Histogram Section Fields

The Histogram Section of the Area Report is shown in the following display. This section of the report is a graphic representation and a quick reference version of the Distribution Section. Distribution Section percentages are shown for each range in the form of a bar chart.

CA-TOOLS RELEASE CA IDMS/DB ANALYZER DATE TIME PAGE Rnn.nn AREA REPORT dd/mm/yy hh:mm:ss nnnn HISTOGRAM SECTION AREA NAME: STUDENT-REGION FILE CREATION DATA: mm/dd/yy - hh:mm:ss PERCENT RANGE PERCENT OF PAGE FULL - PERCENTAGE BY DISTRIBUTION RANGE 0----+----10----+----20----+----30----+----40----+----50----+----60----+----70----+----80----+----90----+----100 0 - 10 .NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN . . . . . 11 - 20 .NNNNNNNNNNNNNNNN . . . . . . . . . 21 - 30 .NNNNN . . . . . . . . . . 31 - 40 . . . . . . . . . . . 41 - 50 .NNNNNNNNNN . . . . . . . . . 51 - 60 . . . . . . . . . . . 61 - 70 . . . . . . . . . . . 71 - 80 .N . . . . . . . . . . 81 - 90 . . . . . . . . . . . 91 - 100 .N . . . . . . . . . . 0----+----10----+----20----+----30----+----40----+----50----+----60----+----70----+----80----+----90----+----100 PAGES RECORD OCCURRENCES - PERCENTAGE BY DISTRIBUTION RANGE 0----+----10----+----20----+----30----+----40----+----50----+----60----+----70----+----80----+----90----+----100 91001 - 91008 .NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN . . . . . . . 91009 - 91016 .NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN . . . . . . . 91017 - 91024 .NNNNNNNNNNN . . . . . . . . . 91025 - 91032 . . . . . . . . . . . 91033 - 91040 . . . . . . . . . . . 91041 - 91048 . . . . . . . . . . . 91049 - 91056 . . . . . . . . . . . 91057 - 91064 . . . . . . . . . . . 91065 - 91072 . . . . . . . . . . . 91073 - 91080 . . . . . . . . . . . 0----+----10----+----20----+----30----+----40----+----50----+----60----+----70----+----80----+----90----+----100 PAGES FRAGMENTS - PERCENTAGE BY DISTRIBUTION RANGE 0----+----10----+----20----+----30----+----40----+----50----+----60----+----70----+----80----+----90----+----100 91001 - 91008 . . . . . . . . . . . 91009 - 91016 . . . . . . . . . . . 91017 - 91024 . . . . . . . . . . . 91025 - 91032 . . . . . . . . . . . 91033 - 91040 . . . . . . . . . . . 91041 - 91048 . . . . . . . . . . . 91049 - 91056 . . . . . . . . . . . 91057 - 91064 . . . . . . . . . . . 91065 - 91072 . . . . . . . . . . . 91073 - 91080 . . . . . . . . . . . 0----+----10----+----20----+----30----+----40----+----50----+----60----+----70----+----80----+----90----+----100 PAGES FREE SPACE - PERCENTAGE BY DISTRIBUTION RANGE 0----+----10----+----20----+----30----+----40----+----50----+----60----+----70----+----80----+----90----+----100 91001 - 91008 .NNNNNNNNN . . . . . . . . . . 91009 - 91016 .NNNNNNNNNNN . . . . . . . . . 91017 - 91024 .NNNNNNNNNNN . . . . . . . . . 91025 - 91032 .NNNNNNNNNNN . . . . . . . . . 91033 - 91040 .NNNNNNNNNNN . . . . . . . . . 91041 - 91048 .NNNNNNNNNNN . . . . . . . . . 91049 - 91056 .NNNNNNNNNNN . . . . . . . . . 91057 - 91064 .NNNNNNNNNNN . . . . . . . . . 91065 - 91072 .NNNNNNNNNNN . . . . . . . . . 91073 - 91080 .NNNNNNNNNNN . . . . . . . . . 0----+----10----+----20----+----30----+----40----+----50----+----60----+----70----+----80----+----90----+----100 BYTES SAVED SAVINGS DUE TO COMPRESSION - PERCENTAGE BY DISTRIBUTION RANGE 0----+----10----+----20----+----30----+----40----+----50----+----60----+----70----+----80----+----90----+----100 0 - 0 . . . . . . . . . . . 1 - 50 .NN . . . . . . . . . . 51 - 100 . . . . . . . . . . . 101 - 150 . . . . . . . . . . . 151 - 200 .NNNNNNNNN. . . . . . . . . . 201 - 250 . . . . . . . . . . . 251 - 300 . . . . . . . . . . . 301 - 350 . . . . . . . . . . . 351 - 400 .NNNNNNNNNNNNNN . . . . . . . . . 401 - 450 .NNNNNNNNNN . . . . . . . . . 0----+----10----+----20----+----30----+----40----+----50----+----60----+----70----+----80----+----90----+----100

Analysis by Record Section Fields

The Analysis by Record Section of the Area Report is shown in the following display. This section of the report provides summary statistics by record type for both active and logically deleted (LDEL) records. A description of each field is given below.

CA-TOOLS RELEASE CA IDMS/DB ANALYZER DATE TIME PAGE Rnn.nn AREA REPORT dd/mm/yy hh:mm:ss nnnn ANALYSIS BY RECORD SECTION AREA NAME: STUDENT-REGION FILE CREATION DATA: mm/dd/yy - hh:mm:ss RECORD NAME LOC ***********************************ACTIVE RECORDS******************************** *******LDEL RECORDS*** MODE *-OCCURRENCES-* *-SPACED USED-* *---LENGTH--* *-FRAGMENTS-* COMPRESSION *-SPACED USED-* COUNT PCT BYTES PCT AVG MAX MIN COUNT PCT BYTES SAVED COUNT BYTES PCT ---------- ----- ----- --- ----- --- --- --- --- ----- --- ----------- ----- ----- --- DREPORTV V 2 1 88 1 44 44 44 0 0 72 0 0 0 GREPORT V 3 1 148 2 49 52 48 0 0 212 0 0 0 SCHEDULE V 98 47 4,312 46 44 44 44 0 0 0 0 0 0 SPORTS C 3 1 180 2 60 60 60 0 0 0 0 0 0 STUDENT C 51 25 4,600 49 90 96 84 0 0 20,492 0 0 0

Note: In a case where only a portion of an area has been swept for statistical accumulation, the field values described pertain only to the portion of the area swept.

1 RECORD NAME--Listed under this heading is the record name for each record type in the area swept.

2 LOCATION MODE--The location mode under which the record is stored. The value will be either V(VIA), C(CALC), or D(DIRECT).

3 OCCURRENCES--The values listed under this heading are the total number of active record occurrences and the percentage of active record occurrences for each record type.

 PCT=100    *        OCCURRENCES PER RECORD TYPE
                     REC OCCURRENCES (Area Stats 26)

4 SPACE USED--The values listed under this heading are the total number of bytes used by active record occurrences and the percentage of bytes used by active record occurrences for each record type.

 PCT=100    *        SPACE USED PER RECORD TYPE
                     BYTES,PNTRS (12) + BYTES,DATA (13)

5 LENGTH--The values listed under this heading are the average, maximum, and minimum lengths (number of bytes used) of active record occurrences for each record type. Fixed length record types show identical average, maximum, and minimum values.

6 FRAGMENTED RECORDS--The values listed under this heading are the total number of active fragmented record occurrences and the percentage of active fragmented record occurrences for each record type.

 PCT=100    *        FRAGMENTS PER RECORD TYPE
                     FRAGMENTED REC (Area Stats 33)

7 COMPRESSION BYTES SAVED--The values listed under this heading are the total number of bytes saved by active compressed record occurrences for each record type.

8 COUNT--The values listed under this heading are the total number of logically deleted record occurrences for each record type.

9 SPACE USED--The values listed under this heading are the total number of bytes used by logically deleted records and the percentage of space used by logically deleted records for each record type.

 PCT=100    *        SPACE USED PER RECORD TYPE
                     BYTES USED,TOTAL (Area Stats 19)