SR8 Index Report fields are shown in the following screen displays. Following are descriptions of two report identification fields plus fields used in the Index Statistics, Distribution, and Histogram Sections of the Index Report. The item numbers preceding each field name and description correspond with those in the referenced exhibits.
CA-TOOLS RELEASE CA IDMS/DB ANALYZER DATE TIME PAGE Rnn.nn SR8 INDEX REPORT dd/mm/yy hh:mm:ss nnnn SR8 INDEX STATISTICS SECTION 1 ► INDEX NAME: IX-STUD-LNAME 2 ► FILE CREATION DATA: mm/dd/yy - hh:mm:ss ITEM TOTAL --------------------------------- ------- 3 ► OWNER RECORD NAME SR7 4 ► MEMBER RECORD NAME STUDENT 5 ► MEMBERSHIP OPTION MANDATORY AUTO 6 ► DUPLICATES OPTION DUPS NOT 7 ► SEQUENCE OPTION DESCENDING SEQ 8 ► COMPRESSION OPTION NO 9 ► SET ORDER OPTION SORTED 10► SORT TYPE SORTED DBKEY 11► MAX NUMBER OF TABLE ENTRIES 3 12► MAX LENGTH OF TABLE ENTRY 8 13► SYMBOLIC KEY LENGTH 4 14► MAX SR8 RECORD SIZE 72 15► TOTAL BYTES TO STORE INDEX 2,060 16► PAGE NUMBER - 1ST SR8 92,129 17► NUMBER OF BOTTOM SR8 IN TOP 0 18► SR8 DISPLACEMENT 0 19► NUMBER OF LEVELS 5 20► TOTAL ORPHAN COUNT 124 UPPER LEVEL STATISTICS 21► SR8 RECORDS 16 22► PAGE SPREAD 1 23► USED TABLE ENTRIES 37 AVG 2.31 MAX 3 MIN 2 24► ORPHAN COUNT 26 AVG 1.63 MAX 3 MIN 1 BOTTOM LEVEL STATISTICS 25► SR8 RECORDS 22 26► PAGE SPREAD 1 27► USED TABLE ENTRIES 51 AVG 2.32 MAX 3 MIN 2 28► ORPHAN COUNT 98 AVG 4.45 MAX 10
1 INDEX NAME--The name of the SR8 index set 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 OWNER RECORD NAME--The name of the index owned by the system or specified by the user.
4 MEMBER RECORD NAME--The name of the record type that is being indexed.
5 MEMBERSHIP OPTION--The name of the actual membership option for the index set. One of the following four options appears on the report:
MANDATORY-AUTO OPTIONAL-AUTO OPTIONAL-MAN MANDATORY-MAN
6 DUPLICATES OPTION--The name of the duplicates option specified in the source code for the set section of the schema. One of four options appears on the report:
N/A DUPS FIRST DUPS LAST DUPS NOT
7 SEQUENCE OPTION--Either ASCENDING or DESCENDING depending on the order in which member record occurrences are to be stored in the index set.
8 COMPRESSION OPTION--Either YES or NO, depending on whether front-end db-key compression was specified.
9 SET ORDER OPTION--The name of the sort option specified for the SR8 index set. One of three options appears on the report:
SORTED NEXT/FIRST PRIOR/LAST
10 SORT TYPE--The name of the sort type specified for the SR8 index set. One of three options appears on the report:
SORTED DBKEY SORTED SYMBOLIC KEY UNSORTED
11 MAX NUMBER OF TABLE ENTRIES--The maximum number of table entries that can be made in an SR8 index record.
12 MAX LENGTH OF TABLE ENTRY--The maximum length of each entry that can be entered into an SR8 index record. The length depends upon which sort type is specified.
13 SYMBOLIC KEY LENGTH--The maximum number of bytes defined for the sort key specified.
14 MAX SR8 RECORD SIZE--The size of the largest SR8 index record encountered in this SR8 index set.
15 TOTAL BYTES TO STORE INDEX--The total storage space requirements for all SR8 and SR7 or user-specified owner records of the index set.
16 PAGE NUMBER - 1ST SR8--The page number of the first SR8 record encountered that is pointed to by an owner record.
17 NUMBER OF BOTTOM SR8 IN TOP--The number of bottom level SR8 records stored in the top level of the index set.
18 SR8 DISPLACEMENT--The number of pages the bottom level SR8 index records are stored from their owners.
19 NUMBER OF LEVELS--The maximum number of levels in the hierarchy for any owner occurrence within this SR8 index set.
20 TOTAL ORPHAN COUNT--The total number of orphan counts within this SR8 index set. This number is the sum of the upper level (item 24) and bottom level (item 28) orphan counts.
21 SR8 RECORDS--The number of SR8 index record occurrences in the upper level of the index set.
22 PAGE SPREAD--The number of pages on which upper level SR8 index record occurrences occur.
23 USED TABLE ENTRIES--The number of filled table entries for all upper level SR8 record occurrences in the SR8 index set.
Also included are the average (AVG) number of filled table entries, the greatest number of filled table entries (MAX), and the fewest number of filled table entries (MIN) in an upper level SR8 index record occurrence that had at least one filled table entry.
AVG = USED TABLE ENTRIES (23
Upper SR8 INDEX RECORDS (21)
24 ORPHAN COUNT--The total number of orphan counts for all SR8 records within the upper level of this set.
Also included are the average (AVG) number of orphans per upper level SR8 index record occurrence, the greatest number of orphans (MAX), and the fewest number of orphans (MIN) per upper level SR8 index record occurrence.
AVG = Upper ORPHAN COUNT (24)
Upper SR8 INDEX RECORDS (21)
25 SR8 RECORDS--The number of SR8 index record occurrences in the bottom level of the index set.
26 PAGE SPREAD--The number of pages on which bottom level SR8 record occurrences occur.
27 USED TABLE ENTRIES--The number of filled table entries for all bottom level SR8 index record occurrences in the index set.
Also included are the average (AVG) number of filled table entries, the greatest number of filled table entries (MAX), and the fewest number of filled table entries (MIN) in a bottom level SR8 index record occurrence that had at least one filled table entry.
AVG = USED TABLE ENTRIES (27)
Bottom SR8 Index RECORDS (25)
28 ORPHAN COUNT--The total number of orphan counts for all SR8 records within the bottom level of this set.
Also included are the average (AVG) number of orphans per bottom level SR8 index record occurrence, the greatest number of orphans (MAX), and the fewest number of orphans (MIN) per bottom level SR8 index record occurrence.
AVG = Bottom ORPHAN COUNT (28)
Bottom SR8 INDEX RECORDS (25)
|
Copyright © 2013 CA.
All rights reserved.
|
|