Comparative Index Report Fields are shown in the following screen displays. Identification and SR8 Index Statistic Section fields of the Comparative SR8 Index Report are described below. See SR8 Index Report for descriptions of fields identical to those found in the Comparative SR8 Index Report.
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 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 NEW OLD VARIANCE -------------------------------- ---------------- --------------- ---------- OWNER RECORD NAME SR7 SR7 MEMBER RECORD NAME STUDENT STUDENT MEMBERSHIP OPTION MANDATORY AUTO MANDATORY AUTO DUPLICATES OPTION DUPS LAST DUPS NO SEQUENCE OPTION DESCENDING SEQ DESCENDING SEQ COMPRESSION OPTION NO NO SET ORDER OPTION SORTED SORTED SORT TYPE SORTED DBKEY SORTED DBKEY MAX NUMBER OF TABLE ENTRIES 3 3 0 MAX LENGTH OF TABLE ENTRY 8 8 0 SYMBOLIC KEY LENGTH 4 4 0 MAX SR8 RECORD SIZE 72 72 0 TOTAL BYTES TO STORE INDEX 588 2,060 -1,472 PAGE NUMBER - 1ST SR8 92,129 92,129 0 NUMBER OF BOTTOM SR8 IN TOP 0 0 0 SR8 DISPLACEMENT 0 0 0 NUMBER OF LEVELS 3 5 -2 NUMBER OF ORPHANS 24 124 0 UPPER LEVEL STATISTICS ---------------------- SR8 RECORDS 4 16 -12 PAGE SPREAD 1 1 0 USED TABLE ENTRIES 10 37 -27 AVG 2.50 2.31 +0.19 MAX 3 3 0 MIN 2 2 0 ORPHAN COUNT 8 26 0 AVG 2.00 1.63 +0.38 MAX 3 3 0 MIN 1 1 0 BOTTOM LEVEL STATISTICS ----------------------- SR8 RECORDS 7 22 -15 PAGE SPREAD 1 1 0 USED TABLE ENTRIES 16 51 -35 AVG 2.29 2.32 -0.03 MAX 3 3 0 MIN 2 2 0 ORPHAN COUNT 16 98 0 AVG 2.29 4.45 -2.17 MAX 6 10 0 MIN 1 1 0
1 INDEX NAME--The name of the SR8 index set for the reported statistics.
2 NEW FILE CREATION DATA--The date and time of creation of the statistical file which is listed in the z/OS and OS/390 JCL as STAT1, and in the VSE/ESA JCL as SYS010.
3 OLD FILE CREATION DATA--The date and time of creation of the statistical file which is listed in the z/OS and OS/390 JCL as STAT2, and in the VSE/ESA JCL as SYS011.
4 NEW--The values listed under this heading are taken from the new statistics file (item 2). See SR8 Index Report for a description of each field listed.
5 OLD--The values listed under this heading are taken from the old statistical file (item 3). See SR8 Index Report for a description of each field listed.
6 VARIANCE--Listed under this heading are the differences between new and old raw counts. 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.
|
Copyright © 2013 CA.
All rights reserved.
|
|