Record Report fields are shown in the following screen displays. Following are descriptions of two report identification fields plus fields used in the Record Statistics and Distribution Sections of the Record Report.
CA-TOOLS RELEASE CA IDMS/DB ANALYZER DATE TIME PAGE Rnn.nn RECORD REPORT dd/mm/yy hh:mm:ss nnnn RECORD STATISTICS SECTION 1 ► RECORD ID/NAME: 1002 - SUBJECT 2 ► FILE CREATION DATA: mm/dd/yy - hh:mm:ss ITEM TOTAL PCT ----------------------------- ------- ----- 3 ► RECORD LOCATION MODE CALC 4 ► NUMBER OF OCCURRENCES 37 5 ► BYTES TO STORE ALL OCCURRENCES 2,912 6 ► RECS OUT OF PHYSICAL SEQUENCE 0 0 7 ► NUMBER OF LDEL OCCURRENCES 25 68 8 ► BYTES TO STORE LDEL RECORDS 1,400 48 9 ► OCCURRENCE LENGTH COMPRESSED AVG 79 MAX 188 MIN 56 DECOMPRESSED AVG 79 MAX 188 MIN 56 10► RELOCATED OCCURRENCES 0 0 11► BYTES TO STORE RELOCATED RECS 0 0 12► BYTES THAT COULD BE RETURNED 0 0 13► OCCURRENCES WITH FRAGMENTS 0 0 14► FRAGMENTS PER OCCURRENCE AVG 0.00 MAX 0 MIN 0 15► NUMBER OF FRAGMENTS 0 16► BYTES TO STORE ALL FRAGMENTS 0 0 17► BYTES THAT COULD BE RETURNED 0 0 18► NUMBER OF RECORDS COMPRESSED 0 0 19► SAVINGS DUE TO COMPRESSION 0 AVG 0.00 MAX 0 MIN 0
Note: In a case where only a portion of an area has been swept forstatistical accumulation, the field values described pertain only to the portion of the area swept. Remember that statistics shown on the Record Report apply only to the record type indicated in the RECORD ID/NAME field of the report (item 1).
1 RECORD ID/NAME--The identification number and name of the record type for the reported statistics.
2 FILE CREATION DATA--The date and time that the statistical file used for this report was created. This information helps identify which statistical file is being used since there can be more than one file in storage.
3 RECORD LOCATION MODE--The location mode for the record type as defined in the schema is shown here.
4 NUMBER OF OCCURRENCES--The total number of record occurrences. This value includes logically deleted (LDEL) records.
5 BYTES TO STORE ALL OCCURRENCES--The total number of bytes used to store all record occurrences.
6 RECORDS OUT OF PHYSICAL SEQUENCE--As of Release 12.0, this value is always zero.
PCT=100 * RECS OUT OF PHYS SEQUENCE(6)
NUMBER OF OCCURRENCES (4)
7 NUMBER OF LDEL OCCURRENCES--The number of logically deleted record occurrences in the area swept for this record type and the percentage of total records of this type that are logically deleted.
PCT=100 * NUMBER OF LDEL OCCURRENCES(7)
NUMBER OF OCCURRENCES (4)
8 BYTES TO STORE LDEL RECORDS--The number of bytes used to store all logically deleted record occurrences and the percentage of total bytes used for this record type that are for logically deleted occurrences.
PCT=100 * BYTES TO STORE LDEL RECS(8)
BYTES TO STORE ALL OCS (5)
9 OCCURRENCE LENGTH (if fixed)--If occurrences for the record type are of fixed length and are not compressed, the number of bytes used for occurrence length is shown here.
If the record type is of variable length or is compressed, the fixed occurrence length is not shown on the report. For variable length, see next item.
9 OCCURRENCE LENGTH (if variable)--If occurrences for the record type are of variable length or are compressed, the average, maximum, and minimum number of bytes used for both compressed and decompressed occurrence lengths is shown here. The decompressed occurrence length is only valid if IDMSCOMP was used as the compression routine.
If the record type is of fixed length and is not compressed, these fields are not shown on the report.
10 RELOCATED OCCURRENCES--The total number of relocated record occurrences and the percentage of relocated record occurrences.
PCT=100 * RELOCATED OCCURRENCES (10)
NUMBER OF OCCURRENCES (4)
11 BYTES TO STORE ALL RELOCATED RECS--The total number of bytes used to store all relocated record occurrences (and associated pointers) and the percentage of bytes used for relocated record occurrences.
PCT=100 * BYTES,STORE ALL RELOC RECS(11)
BYTES TO STORE ALL OCS (5)
12 BYTES THAT COULD BE RETURNED(RELOCATED RECORDS)--The total number of bytes of relocated records that could be returned to the target page, were a reorganization to take place, and the percentage of bytes that could be returned.
PCT=100 * BYTES COULD BE RET,RELOC RECS(12)
BYTES TO STORE ALL RELOC RECS (11)
13 OCCURRENCES WITH FRAGMENTS--The total number of fragmented record occurrences and the percentage of fragmented record occurrences.
PCT=100 * OCCURRENCES WITH FRAGMTS(13)
NUMBER OF OCCURRENCES (4)
If the record is a fixed length record, this field is not shown on the report since fixed length records cannot be fragmented.
14 FRAGMENTS PER OCCURRENCE--The number of fragments for each fragmented record occurrence expressed as the average number of fragments per occurrence (AVG), the greatest number of fragments into which a record occurrence is divided (MAX), and the least number of fragments into which a record occurrence is divided (MIN).
AVG = NUMBER OF FRAGMENTS (15)
NUMBER OF OCCURRENCES (4)
If the record is a fixed length record, this field is not shown on the report since fixed length records cannot be fragmented.
15 NUMBER OF FRAGMENTS--The total number of record fragments. If the record is a fixed length record, this field is not shown on the report since fixed length records cannot be fragmented.
16 BYTES TO STORE ALL FRAGMENTS--The number of bytes used to store all fragments and the percentage of bytes used to store all fragments.
PCT=100 * BYTES TO STORE ALL FRAGMTS(16)
BYTES TO STORE ALL OCS (5)
If the record is a fixed length record, this field is not shown on the report since fixed length records cannot be fragmented.
17 BYTES THAT COULD BE RETURNED (FRAGMENTED RECORDS)--The total number of bytes of fragmented records that could be returned to the target page were a reorganization to take place and the percentage of bytes that could be returned.
PCT=100 * BYTES COULD BE RET,FRAGRECS(17)
BYTES TO STORE ALL FRAGMTS(16)
If the record is a fixed length record, this field is not shown on the report since fixed length records cannot be fragmented.
18 NUMBER OF RECORDS COMPRESSED--The number of compressed records and the percentage of compressed records.
PCT=100 * NUMBER RECS COMPRESSED (18)
NUMBER OF OCCURRENCES (4)
This statistic is valid only if IDMSCOMP was used as the compression routine.
19 SAVINGS DUE TO COMPRESSION--The total number of bytes saved due to the compression of certain record occurrences.
Also included are the average number of bytes of savings per compressed record (AVG), the greatest number of bytes of savings in a compressed record (MAX), and the least number of bytes of savings in a compressed record that has compression savings (MIN).
AVG = SAVINGS DUE TO COMPRESSION (19)
NUMBER RECORDS COMPRESSED (18)
If the record is a fixed length record, this field is not shown on the report because compressed records are defined internally as variable length.
This statistic is valid only if IDMSCOMP was used as the compression routine.
|
Copyright © 2013 CA.
All rights reserved.
|
|