A statistics accumulation file that includes several areas contains the complete records for each area before beginning the next area. For example, the AREA-1 area record is followed by all the record records for AREA-1. Then the AREA-2 area record is followed by all the record records for AREA-2.
THE CA-IDMS/DB ANALYZER STATISTICS ACCUMULATION FILE IS OF THE FOLLOWING FORMAT
RECORD STATISTIC NUMBER OF RECORD
TYPE VALUE TYPE VALUE OCCURRENCES LENGTH
_____________ _____________ _____________________________ ____
HEADER 00 HEADER 00 1 152
AREA 01 AREA 01 1 PER AREA 392
RECORD 02 1 PER RECORD TYPE PER AREA 448
RECORD 02 RECORD 02 1 PER RECORD TYPE 448
SET 03 SET 03 1 PER SET 372
MEMBER 04 1 PER MEMBER TYPE PER SET 136
SR8 INDEX 05 SR8 INDEX 05 1 PER SR8 INDEX 388
FOOTER 08 FOOTER 08 1 113
Exhibit A.1: Record Lengths of Statistics Records
HEADER RECORD
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 1 4 RDW (2 BYTES LRECL, 2 BYTES RECFM)
****************************** SORT KEY ******************************
BINARY 1 5 5 RECORD TYPE; VALUE = 00 *
CHARACTER 18 6 23 VALUE = 'HEADER ' *
CHARACTER 18 24 41 VALUE = SPACES *
**********************************************************************
BINARY 1 42 42 STATISTIC TYPE; VALUE = 00
CHARACTER 8 43 50 NAME OF SUBSCHEMA FOR WHICH DATA WAS
COLLECTED
CHARACTER 16 51 66 FILE ID; VALUE = 'DB/ANALYZER '
CHARACTER 16 67 82 DATE/TIME STATISTICS WERE ACCUMULATED
CHARACTER 5 83 87 RELEASE NUMBER
CHARACTER 1 88 88 NOT USED (ALIGNMENT)
BINARY 4 89 92 TOTAL NUMBER OF STATISTICS FILE RECORDS
WRITTEN
CHARACTER 60 93 152 FILLER
Exhibit A.2: Header Statistics Record
AREA RECORD
AREA STATISTIC-TYPE
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 1 4 RDW (2 BYTES LRECL, 2 BYTES RECFM)
****************************** SORT KEY ******************************
BINARY 1 5 5 RECORD TYPE; VALUE = 01 *
CHARACTER 18 6 23 AREA NAME *
CHARACTER 18 24 41 VALUE = SPACES *
**********************************************************************
BINARY 1 42 42 STATISTIC TYPE; VALUE = 01
CHARACTER 2 43 44 NOT USED (FOR ALIGNMENT)
BINARY 4 45 48 PAGE NUMBER OF AREA LOW PAGE
BINARY 4 49 52 PAGE NUMBER OF AREA HIGH PAGE
BINARY 4 53 56 PAGE NUMBER FOR START OF AREA SWEEP
BINARY 4 57 60 PAGE NUMBER FOR END OF AREA SWEEP
BINARY 4 61 64 LENGTH OF PAGE IN BYTES
BINARY 4 65 68 NUMBER OF RECORD OCCURRENCES
BINARY 4 69 72 NUMBER OF LDEL RECORD OCCURRENCES
(CONTINUED)
Exhibit A.3a: Area Statistics Record, Area Record-Type
AREA RECORD
AREA STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
FLOAT PT 8 73 80 TOTAL NUMBER OF BYTES USED
BINARY 4 81 84 NUMBER OF FRAGMENTS
BINARY 4 85 88 GREATEST NUMBER OF BYTES OF ACTUAL FREE
SPACE FOUND ON A SINGLE, NON-EMPTY PAGE
BINARY 4 89 92 FEWEST NUMBER OF BYTES OF ACTUAL FREE
SPACE FOUND ON A SINGLE, NON-FULL PAGE
CHARACTER 4 93 96 NOT USED (FOR ALIGNMENT)
FLOAT PT 8 97 104 TOTAL BYTES OF FREE SPACE MINUS PAGE
RESERVE
BINARY 4 105 108 GREATEST NUMBER OF BYTES OF FREE SPACE
FOUND ON A SINGLE, NON-EMPTY PAGE AFTER
SUBTRACTING THE PAGE RESERVE
BINARY 4 109 112 FEWEST NUMBER OF BYTES OF FREE SPACE
FOUND ON A SINGLE, NON-FULL PAGE AFTER
SUBTRACTING THE PAGE RESERVE
FLOAT PT 8 113 120 NUMBER OF BYTES USED FOR POINTERS
FLOAT PT 8 121 128 NUMBER OF BYTES USED FOR LINE INDEXES
BINARY 4 129 132 NUMBER OF BYTES USED FOR PAGE HEADERS
(CONTINUED)
Exhibit A.3b: Area Statistics Record, Area Record-Type
AREA RECORD
AREA STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 133 136 NUMBER OF BYTES USED FOR PAGE FOOTERS
FLOAT PT 8 137 144 NUMBER OF BYTES USED FOR DATA STORAGE
BINARY 4 145 148 NUMBER OF PAGES WITH A HEADER SPACE
AVAILABLE COUNT OF ZERO
BINARY 4 149 152 NUMBER OF PAGES WITH SCHEMA DEFINED
MAXIMUM NUMBER OF RECORDS
BINARY 4 153 156 NUMBER OF PAGES WITH 0 DATA RECORDS
BINARY 4 157 160 NUMBER OF SR7 RECORD OCCURRENCES
FLOAT PT 8 161 168 NUMBER OF BYTES USED TO STORE SR7 RECORDS
BINARY 4 169 172 NUMBER OF SR8 RECORD OCCURRENCES
CHARACTER 4 173 176 NOT USED (FOR ALIGNMENT)
FLOAT PT 8 177 184 NUMBER OF BYTES USED TO STORE SR8 RECORDS
(COMPRESSED)
FLOAT PT 8 185 192 NUMBER OF BYTES USED TO STORE SR8 RECORDS
(DECOMPRESSED)
CHARACTER 34 193 226 FILLER
(CONTINUED)
Exhibit A.3c: Area Statistics Record, Area Record-Type
AREA RECORD
AREA STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
CHARACTER 2 227 228 NOT USED (FOR ALIGNMENT)
BINARY 4 229 232 NUMBER OF SPACE MANAGEMENT PAGES
BINARY 40 233 272 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS A PAGE NUMBER THAT DELIMITS
A RANGE OF PAGE NUMBERS USED TO GATHER
DISTRIBUTION STATISTICS
BINARY 40 273 312 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS A RANGE BOUND OF NUMBER OF
BYTES SAVED DUE TO COMPRESSION
BINARY 40 313 352 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS THE NUMBER OF PAGES OCCURRING
WITHIN EACH PERCENTAGE RANGE. RANGES
OCCUR IN 10% INCREMENTS
BINARY 40 353 392 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS A NUMBER OF BYTES OF FREE
SPACE FOR THAT SPECIFIC PAGE RANGE
Exhibit A.3d: Area Statistics Record, Area Record-Type
AREA RECORD
RECORD STATISTIC-TYPE
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 1 4 RDW (2 BYTES LRECL, 2 BYTES RECFM)
****************************** SORT KEY ******************************
BINARY 1 5 5 RECORD TYPE; VALUE = 01 *
CHARACTER 18 6 23 AREA NAME *
CHARACTER 18 24 41 RECORD NAME *
**********************************************************************
BINARY 1 42 42 STATISTIC-TYPE; VALUE = 02
CHARACTER 2 43 44 NOT USED (ALIGNMENT)
BINARY 4 45 48 RECORD ID
BINARY 1 49 49 LOCATION MODE;
00 = VIA
01 = CALC
02 = DIRECT
CHARACTER 3 50 52 NOT USED (ALIGNMENT)
BINARY 4 53 56 PAGE NUMBER FOR START OF AREA SWEPT
BINARY 4 57 60 PAGE NUMBER FOR END OF AREA SWEPT
BINARY 4 61 64 LENGTH OF PAGE IN BYTES
BINARY 1 65 65 FIXED LENGTH RECORD INDICATOR;
00 =VARIABLE
01 = FIXED
CHARACTER 3 66 68 NOT USED (ALIGNMENT)
(CONTINUED)
Exhibit A.4a: Area Statistics Record, Record Record-Type
AREA RECORD
RECORD STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 69 72 LENGTH OF RECORD, IF FIXED
FLOAT PT 8 73 80 TOTAL NUMBER OF BYTES USED TO STORE THIS RECORD
TYPE (COMPRESSED BYTES DATA ONLY)
FLOAT PT 8 81 88 TOTAL NUMBER OF BYTES NEEDED TO STORE THIS RECORD
TYPE IF COMPRESSED RECORDS WERE DECOMPRESSED ZERO
FOR FIXED LENGTH (DECOMPRESSED BYTES)
BINARY 4 89 92 LARGEST COMPRESSED LENGTH OF ONE
OCCURRENCE OF THIS RECORD TYPE
BINARY 4 93 96 SMALLEST COMPRESSED LENGTH OF ONE
OCCURRENCE OF THIS RECORD TYPE
BINARY 4 97 100 LARGEST DECOMPRESSED LENGTH OF ONE
OCCURRENCE OF THIS RECORD TYPE
BINARY 4 101 104 SMALLEST DECOMPRESSED LENGTH OF ONE
OCCURRENCE OF THIS RECORD TYPE
BINARY 4 105 108 NUMBER OF OCCURRENCES WITH FRAGMENTS
BINARY 4 109 112 GREATEST NUMBER OF FRAGMENTS FOR ONE
RECORD OCCURRENCE
BINARY 4 113 116 FEWEST NUMBER OF FRAGMENTS FOR ONE
RECORD OCCURRENCE WITH FRAGMENTS
CHARACTER 4 117 120 NOT USED (ALIGNMENT)
(CONTINUED)
Exhibit A.4b: Area Statistics Record, Record Record-Type
AREA RECORD
RECORD STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
FLOAT PT 8 121 128 NUMBER OF BYTES TO STORE FRAGMENTS DATA ONLY
FLOAT PT 8 129 136 NUMBER OF BYTES THAT COULD BE RETURNED
TO HOME PAGE IF A REORG WAS PERFORMED
(FRAGMENT BYTES)
BINARY 4 137 140 NUMBER OF RECORDS THAT WERE COMPRESSED
CHARACTER 4 141 144 NOT USED (ALIGNMENT)
FLOAT PT 8 145 152 NUMBER OF BYTES SAVE BY COMPRESSION
BINARY 4 153 156 GREATEST NUMBER OF BYTES SAVED BY
COMPRESSION FOR A SINGLE RECORD OCCURRENCE
BINARY 4 157 160 FEWEST NUMBER OF BYTES SAVED BY
COMPRESSION FOR A SINGLE RECORD OCCURRENCE
BINARY 4 161 164 NUMBER OF OCCURRENCES THAT WERE RELOCATED
CHARACTER 4 165 168 NOT USED (ALIGNMENT)
FLOAT PT 8 169 176 NUMBER OF BYTES USED TO STORE RELOCATED
OCCURRENCES DATA ONLY
FLOAT PT 8 177 184 NUMBER OF BYTES THAT COULD BE RETURNED
TO HOME PAGE IF A REORG WAS PERFORMED
(RELOCATED BYTES)
BINARY 4 185 188 NUMBER OF OCCURRENCES THAT WERE LOGICALLY
DELETED
CHARACTER 4 189 192 FILLER
(CONTINUED)
Exhibit A.4c: Area Statistics Record, Record Record-Type
AREA RECORD
RECORD STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
FLOAT PT 8 193 200 NUMBER OF BYTES USED TO STORE LDEL
OCCURRENCES
BINARY 4 201 204 NUMBER OF OCCURRENCES STORE OUT OF
PHYSICAL SEQUENTIAL
CHARACTER 44 205 248 FILLER
BINARY 40 249 288 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS A PAGE NUMBER THAT DELIMITS
A RANGE OF PAGE NUMBERS USED TO GATHER
DISTRIBUTION STATISTICS
BINARY 40 289 328 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
DELIMITS A RANGE BOUND OF NUMBER OF
BYTES SAVED DUE TO COMPRESSION
BINARY 40 329 368 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS THE NUMBER OF RECORDS
OCCURRING WITHIN EACH PAGE RANGE
BINARY 40 369 408 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS THE NUMBER OF FRAGMENTS
OCCURRING WITHIN EACH PAGE RANGE
BINARY 40 409 448 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS THE NUMBER OF RECORDS WITH
COMPRESSION SAVINGS FOR EACH OF TEN RANGES
Exhibit A.4d: Area Statistics Record, Record Record-Type
RECORD RECORD
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 1 4 RDW (2 BYTES LRECL, 2 BYTES RECFM)
****************************** SORT KEY ******************************
BINARY 1 5 5 RECORD TYPE; VALUE = 02 *
CHARACTER 18 6 23 RECORD NAME *
CHARACTER 18 24 41 VALUE = SPACES *
**********************************************************************
THE RECORD RECORD IS IDENTICAL TO THE AREA RECORD RECORD STATISTIC-TYPE
FROM BYTE 42 TO 448.
Exhibit A.5: Record Statistics Record
SET RECORD
SET STATISTIC-TYPE
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 1 4 RDW (2 BYTES LRECL, 2 BYTES RECFM)
****************************** SORT KEY ******************************
BINARY 1 5 5 RECORD TYPE; VALUE = 03 *
CHARACTER 18 6 23 SET NAME OR AREA NAME IF THE CALC SET *
CHARACTER 18 24 41 VALUE = SPACES *
**********************************************************************
BINARY 1 42 42 STATISTIC TYPE; VALUE = 03
BINARY 1 43 43 VIA SET INDICATOR;
00 = OWNS NO VIA RECORDS
01 = OWNS A VIA RECORD
BINARY 1 44 44 MULTI-MEMBER SET INDICATOR;
00 = NOT A MULTIMEMBER SET
01 = A MULTIMEMBER SET
BINARY 1 45 45 CALC SET INDICATOR;
00 = NOT THE CALC
01 = CALC SET
BINARY 1 46 46 SR8 INDEX SET INDICATOR;
00 = NOT IIX SET
01 = IIX SET
CHARACTER 18 47 64 OWNER RECORD NAME
CHARACTER 18 65 82 MEMBER RECORD NAME
CHARACTER 2 83 84 NOT USED (ALIGNMENT)
BINARY 4 85 88 NUMBER OF OWNER RECORD OCCURRENCES
FLOAT PT 8 89 96 NUMBER OF BYTES TO STORE ALL OWNER RECORDS
(CONTINUED)
Exhibit A.6a: Set Statistics Record, Set Record-Type
SET RECORD
SET STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 97 100 NUMBER OF MEMBER RECORD OCCURRENCES
CHARACTER 4 101 104 NOT USED (ALIGNMENT)
FLOAT PT 8 105 112 NUMBER OF BYTES TO STORE ALL MEMBER
RECORDS
FLOAT PT 8 113 120 NUMBER OF BYTES TO STORE ALL SR8
RECORDS
BINARY 4 121 124 NUMBER OF LDEL RECORD OCCURRENCES
CHARACTER 4 125 128 NOT USED (ALIGNMENT)
FLOAT PT 8 129 136 NUMBER OF BYTES TO STORE ALL LDEL RECORDS
BINARY 4 137 140 GREATEST NUMBER OF MEMBER RECORDS
ENCOUNTERED WHILE WALKING A SINGLE SET
OCCURRENCE
BINARY 4 141 144 FEWEST NUMBER OF MEMBER RECORDS
ENCOUNTERED WHILE WALKING A SINGLE SET
OCCURRENCE
BINARY 4 145 148 THE SUM OF THE CLUSTER SPREADS FOR ALL
SET OCCURRENCES (CLUSTER SPREAD = THE
NUMBER OF DIFFERENT PAGES ON WHICH
MEMBER RECORDS OCCUR WHILE WALKING A SET)
BINARY 4 149 152 GREATEST NUMBER OF DIFFERENT PAGES
ENCOUNTERED WHILE WALKING A SINGLE SET
OCCURRENCE
(CONTINUED)
Exhibit A.6b: Set Statistics Record, Set Record-Type
SET RECORD
SET STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 153 156 FEWEST NUMBER OF DIFFERENT PAGES
ENCOUNTERED WHILE WALKING A SINGLE SET
OCCURRENCE
BINARY 4 157 160 TOTAL NUMBER OF VIA RECORDS
BINARY 4 161 164 TOTAL NUMBER OF VIA RECORDS ON TARGET PAGE
BINARY 4 165 168 GREATEST NUMBER OF VIA RECORDS ON TARGET
PAGE FOR A SINGLE SET OCCURRENCE
BINARY 4 169 172 FEWEST NUMBER OF VIA RECORDS ON TARGET
PAGE FOR A SINGLE SET OCCURRENCE
BINARY 4 173 176 TOTAL NUMBER OF VIA RECORDS ON OVERFLOW
BINARY 4 177 180 GREATEST NUMBER OF VIA RECORDS ON OVERFLOW
FOR A SINGLE SET OCCURRENCE
BINARY 4 181 184 FEWEST NUMBER OF VIA RECORDS ON OVERFLOW
FOR A SINGLE SET OCCURRENCE
BINARY 4 185 188 TOTAL NUMBER OF TIMES THE PAGE NUMBER
CHANGED WHILE WALKING ALL SET OCCURRENCES
BINARY 4 189 192 GREATEST NUMBER OF TIMES THE PAGE NUMBER
CHANGED WHILE WALKING A SINGLE SET
OCCURRENCE
BINARY 4 193 196 FEWEST NUMBER OF TIMES THE PAGE NUMBER
CHANGED WHILE WALKING A SINGLE SET
OCCURRENCE
(CONTINUED)
Exhibit A.6c: Set Statistics Record, Set Record-Type
SET RECORD
SET STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 197 200 NUMBER OF SET OCCURRENCES WITHOUT ANY
PAGE CHANGES WHILE WALKING THE MEMBERS
OF THE SET
BINARY 4 201 204 NUMBER OF MEMBER OCCURRENCES IN A NON-
CALC MULTI-MEMBER SET NOT STORED VIA
THE MULTI-MEMBER SET OWNER
BINARY 4 205 208 GREATEST NUMBER OF MEMBER OCCURRENCES
IN A NON-CALC MULTI-MEMBER SET NOT
STORED VIA THE MULTI-MEMBER SET OWNER
ENCOUNTERED WHILE WALKING A SINGLE
SET OCCURRENCE
BINARY 4 209 212 FEWEST NUMBER OF MEMBER OCCURRENCES
IN A NON-CALC MULTI-MEMBER SET NOT
STORED VIA THE MULTI-MEMBER SET OWNER
ENCOUNTERED WHILE WALKING A SINGLE
SET OCCURRENCE
BINARY 80 213 292 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS:
- THE NUMBER OF MEMBER OCCURRENCES
HI-BOUND (4 BYTES)
- THE NUMBER OF OWNER OCCURRENCES WHICH
FALL WITHIN THE RANGE (4 BYTES)
BINARY 80 293 374 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS:
- THE CLUSTER SPREAD HI-BOUND (4 BYTES)
- THE NUMBER OF SET OCCURRENCES WHICH
FALL WITHIN THE RANGE (4 BYTES)
Exhibit A.6d: Set Statistics Record, Set Record-Type
SET RECORD
MEMBER STATISTIC-TYPE
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 1 4 RDW (2 BYTES LRECL, 2 BYTES RECFM)
****************************** SORT KEY ******************************
BINARY 1 5 5 RECORD TYPE; VALUE = 03 *
CHARACTER 18 6 23 SET NAME OR AREA NAME IF THE CALC SET *
CHARACTER 18 24 41 MEMBER RECORD NAME *
**********************************************************************
BINARY 1 42 42 STATISTIC TYPE; VALUE = 04
CHARACTER 2 43 44 NOT USED (ALIGNMENT)
BINARY 4 45 48 RECORD ID
BINARY 4 49 52 NUMBER OF MEMBER RECORD OCCURRENCES
CHARACTER 4 53 56 NOT USED (ALIGNMENT)
FLOAT PT 8 57 64 NUMBER OF BYTES TO STORE MEMBER RECORDS
BINARY 4 65 68 GREATEST NUMBER OF MEMBER OCCURRENCES OF
OF THIS RECORD TYPE ENCOUNTERED WHILE
WALKING A SINGLE SET OCCURRENCE
BINARY 4 69 72 FEWEST NUMBER OF MEMBER OCCURRENCES OF
OF THIS RECORD TYPE ENCOUNTERED WHILE
WALKING A SINGLE SET OCCURRENCE
BINARY 4 73 76 NUMBER OF LOGICALLY DELETED RECORDS
CHARACTER 4 77 80 NOT USED (ALIGNMENT)
FLOAT PT 8 81 88 NUMBER OF BYTES TO STORE LDEL RECORDS
CHARACTER 48 89 136 FILLER
Exhibit A.7: Set Statistics Record, Member Record-Type
SR8 INDEX RECORD
SR8 INDEX STATISTIC-TYPE
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 1 4 RDW (2 BYTES LRECL, 2 BYTES RECFM)
****************************** SORT KEY ******************************
BINARY 1 5 5 RECORD TYPE; VALUE = 05 *
CHARACTER 18 6 23 SR8 INDEX NAME *
CHARACTER 18 24 41 VALUE = SPACES *
**********************************************************************
BINARY 1 42 42 STATISTIC TYPE; VALUE = 05
CHARACTER 18 43 60 RECORD NAME OF SR8 INDEX SET OWNER
CHARACTER 18 61 78 SR8 INDEXED RECORD NAME
CHARACTER 2 79 80 NOT USED (ALIGNMENT)
FLOAT PT 8 81 88 TOTAL SIZE OF SR8 INDEX SET IN BYTES
BINARY 4 89 92 MAXIMUM NUMBER OF BYTES FOR AN SR8 IN
THIS INDEX SET
BINARY 4 93 96 MAXIMUM LENGTH OF ONE TABLE ENTRY
NOT INCLUDING SYMBOLIC KEY LENGTH
BINARY 4 97 100 MAXIMUM LENGTH OF SYMBOLIC KEY
BINARY 4 101 104 HOME PAGE NUMBER FOR THIS INDEX SET
(CONTINUED)
Exhibit A.8a: SR8 Index Statistics Record, SR8 Index Record-Type
SR8 INDEX RECORD
SR8 INDEX STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 105 108 DISPLACEMENT OF SR8 FOR HOME PAGE
DEFINED IN SCHEMA
BINARY 2 109 110 MAXIMUM NUMBER OF ENTRIES IN AN SR8 AS
DEFINED BY SUBSCHEMA
BINARY 2 111 112 MAXIMUM NUMBER OF LEVELS FOR A SINGLE
OCCURRENCE OF AN INDEX SET
BINARY 4 113 116 NUMBER OF UPPER LEVEL SR8 RECORDS
BINARY 4 117 120 MAXIMUM NUMBER OF PAGES UPPER LEVEL IS
SPREAD ACROSS
BINARY 4 121 124 NUMBER OF BOTTOM LEVEL SR8 RECORDS
BINARY 4 125 128 MAXIMUM NUMBER OF PAGES BOTTOM LEVEL IS
SPREAD ACROSS
BINARY 1 129 129 SET MEMBERSHIP TYPE;
0 MA
1 MM
2 OA
3 OM
BINARY 1 130 130 DUPLICATE CONTROL OPTION;
0 DN
1 DF
2 DL
BINARY 1 131 131 SEQUENCE OPTION;
0 ASC
2 DES
2 MATCH
3 NOT SORTED
BINARY 1 132 132 COMPRESSED SYMBOLIC KEY OPTION;
O COMPRESSED
1 NOT COMPRESSED
BINARY 1 133 133 SET ORDER OPTION;
0 PRIOR/LAST
1 SORTED
2 NEXT FIRST
BINARY 1 134 134 SORTED SET TYPE;
0 UNSORTED
1 SORTED DBK
2 SORTED SYMK
(CONTINUED)
Exhibit A.8b: SR8 Index Statistics Record, SR8 Index Record-Type
SR8 INDEX RECORD
SR8 INDEX STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
CHARACTER 2 135 136 NOT USED (ALIGNMENT)
BINARY 4 137 140 NUMBER OF UPPER LEVEL TABLE ENTRIES USED
IN ALL SR8 RECORDS
BINARY 4 141 144 MAXIMUM NUMBER OF UPPER LEVEL TABLE
ENTRIES USED IN A SINGLE SR8 RECORD
BINARY 4 145 148 MINIMUM NUMBER OF UPPER LEVEL TABLE
ENTRIES USED IN A SINGLE SR8 RECORD
BINARY 4 149 152 NUMBER OF BOTTOM LEVEL TABLE ENTRIES USED
IN ALL SR8 RECORDS
BINARY 4 153 156 MAXIMUM NUMBER OF BOTTOM LEVEL TABLE
ENTRIES USED IN A SINGLE SR8 RECORD
BINARY 4 157 160 MINIMUM NUMBER OF BOTTOM LEVEL TABLE
ENTRIES USED IN A SINGLE SR8 RECORD
BINARY 4 161 164 MAXIMUM UPPER LEVEL SYMBOLIC KEY
COMPRESSED LENGTH
BINARY 4 165 168 MAXIMUM BOTTOM LEVEL SYMBOLIC KEY
COMPRESSED LENGTH
FLOAT PT 8 169 176 TOTAL NUMBER OF UPPER LEVEL ORPHAN COUNTS
FLOAT PT 8 177 184 TOTAL NUMBER OF BOTTOM LEVEL ORPHAN
COUNTS
BINARY 4 185 188 NUMBER OF BOTTOM LEVEL SR8 RECORDS
THAT ARE ALSO TOP LEVEL SR8 RECORDS
(CONTINUED)
Exhibit A.8c: SR8 Index Statistics Record, SR8 Index Record-Type
SR8 INDEX RECORD
SR8 INDEX STATISTIC-TYPE (CONTINUED)
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
CHARACTER 4 189 192 NOT USED (ALIGNMENT)
FLOAT PT 8 193 200 MAXIMUM NUMBER OF UPPER LEVEL ORPHANS
FOR A SINGLE OWNER OCCURRENCE
FLOAT PT 8 201 208 MINIMUM NUMBER OF UPPER LEVEL ORPHANS
FOR A SINGLE OWNER OCCURRENCE
FLOAT PT 8 209 216 MAXIMUM NUMBER OF BOTTOM LEVEL ORPHANS
FOR A SINGLE OWNER OCCURRENCE
FLOAT PT 8 217 224 MINIMUM NUMBER OF BOTTOM LEVEL ORPHANS
FOR A SINGLE OWNER OCCURRENCE
CHARACTER 4 225 228 NOT USED (ALIGNMENT)
BINARY 40 229 268 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS THE HI-BOUND VALUES FOR
BOTTOM LEVEL TABLE ENTRIES
BINARY 40 269 308 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS THE HI-BOUND VALUES FOR
UPPER LEVEL TABLE ENTRIES
BINARY 40 309 348 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS THE NUMBER OF TABLE ENTRIES
USED IN THE UPPER LEVEL SR8 RECORDS
FOR A PARTICULAR RANGE
BINARY 40 349 388 TEN ELEMENT ARRAY IN WHICH EACH ELEMENT
REPRESENTS THE NUMBER OF TABLE ENTRIES
USED IN THE BOTTOM LEVEL SR8 RECORDS
FOR A PARTICULAR RANGE
Exhibit A.8c: SR8 Index Statistics Record, SR8 Index Record-Type
FOOTER RECORD
DATA TYPE SIZE START STOP FIELD DESCRIPTION
_________ ____ _____ ____ _________________
BINARY 4 1 4 RDW (2 BYTES LRECL, 2 BYTES RECFM)
****************************** SORT KEY ******************************
BINARY 1 5 5 RECORD TYPE; VALUE = 08 *
CHARACTER 18 6 23 VALUE = 'FOOTER ' *
CHARACTER 18 24 41 VALUE = SPACES *
**********************************************************************
BINARY 1 42 42 STATISTIC TYPE; VALUE = 08
CHARACTER 5 43 47 RELEASE NUMBER
CHARACTER 6 48 53 INSTALLATION TAPE ID
CHARACTER 60 54 113 FILLER
Exhibit A.9: Footer Statistics Record
|
Copyright © 2013 CA.
All rights reserved.
|
|