The Area Statistic Section of the Area Report is shown in following two screen displays. Descriptions of the Identification and Statistic Section fields are provided following the exhibits.
CA-TOOLS RELEASE CA IDMS/DB ANALYZER DATE TIME PAGE Rnn.nn AREA REPORT dd/mm/yy hh:mm:ss nnnn AREA STATISTICS SECTION 1 ► AREA NAME: STUDENT-REGION 2. ► FILE CREATION DATA: mm/dd/yy - hh:mm:ss ITEM TOTAL PCT --------------------------------------------------------- ------------------------- ------ 3 ► PAGE SIZE - IN BYTES 3,156 4 ► AREA - LOW PAGE 91,001 5 ► AREA - HIGH PAGE 91,080 6 ► AREA - TOTAL PAGES 80 7 ► AREA - TOTAL SPACE 252,480 8 ► SWEEP - LOW PAGE 91,001 9 ► SWEEP - HIGH PAGE 91,080 10► SWEEP - TOTAL PAGES 80 11► SWEEP - TOTAL SPACE 252,480 100 12► BYTES USED - POINTERS 3,908 2 13► BYTES USED - DATA 5,420 2 14► BYTES USED - LINE INDICES 1,664 1 15► BYTES USED - HEADERS/FOOTERS 2,560 1 16► BYTES USED - SR7 RECORDS 0 0 17► BYTES USED - SR8 RECORDS 2,228 1 18► BYTES USED - SMPS 3,124 1 19► BYTES USED - TOTAL 18,904 7 FREE SPACE 233,576 93 AVG/PAGE 2,956.66 MAX/PAGE 3,056 MIN/PAGE 800 20-21► FREE SPACE LESS PAGE RESERVE 233,576 93 AVG/PAGE 2,956.66 MAX/PAGE 3,056 MIN/PAGE 800 22► PAGES PHYSICALLY FULL 0 0 23► PAGES LOGICALLY FULL 0 0 24► PAGES EMPTY 61 77 25► SPACE MANAGEMENT PAGES 1 1
CA-TOOLS RELEASE CA IDMS/DB ANALYZER DATE TIME PAGE Rnn.nn AREA REPORT dd/mm/yy hh:mm:ss nnnn AREA STATISTICS SECTION AREA NAME: STUDENT-REGION FILE CREATION DATA: mm/dd/yy - hh:mm:ss ITEM TOTAL PCT --------------------------------------------------------- ------------------------- ------ 26► NUMBER OF RECORD OCCURRENCES 208 27► RECS OUT OF PHYSICAL SEQUENCE 0 0 28► LDEL RECORDS................. 0 0 29► BYTES TO STORE 0 0 30► RELOCATED RECORDS............ 0 0 31► BYTES TO STORE 0 0 32► BYTES THAT COULD BE RETURNED 0 0 33► FRAGMENTED RECORDS 0 0 34► BYTES TO STORE 0 0 35► BYTES THAT COULD BE RETURNED 0 0 36► FRAGMENTS PER OCCURRENCE AVG 0.00 MAX 0 MIN 0 37► TOTAL FRAGMENTS IN AREA 0 38► COMPRESSED DATA RECORDS........ 56 27 39► SAVINGS DUE TO COMPRESSION 20,776 8 AVG 371.00 MAX 408 MIN 0 40► SR8 RECORDS................... 51 25 41► DECOMPRESSED BYTES TO STORE 2,228 42► COMPRESSED BYTES TO STORE 2,228 43► SAVINGS DUE TO COMPRESSION 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. Exceptions are items 3, 4, 5, 6, and 7,which pertain to the entire area regardless of whether it was actually swept.
1 AREA NAME--The name of the area for the reported statistics.
2 FILE CREATION DATA--The date and time that the statistical file used for this report was created. This information is important for identifying which statistical file is being used since there can be more than one file in storage.
3 PAGE SIZE - IN BYTES--The number of bytes allocated to each page in the area.
4 AREA - LOW PAGE--The page number of the beginning page for the entire area.
5 AREA - HIGH PAGE--The page number of the ending page for the entire area.
6 AREA - TOTAL PAGES--The number of pages in the entire area.
7 AREA - TOTAL SPACE--The total number of bytes allocated to the entire area. It is equivalent to the number of pages in the area (item 6) multiplied by the page size (item 3).
8 SWEEP - LOW PAGE--The lowest page number when a portion of an area was swept. If the entire area was swept, this page number is identical to the AREA - LOW PAGE number (item 4).
9 SWEEP - HIGH PAGE--The highest page number when a portion of an area was swept. If the entire area was swept, this page number is identical to the AREA - HIGH PAGE number (item 5).
10 SWEEP - TOTAL PAGES--The total number of pages swept in the area.
11 SWEEP - TOTAL SPACE--The total number of bytes allocated to the swept portion of the area and the percentage of space allocated to the swept portion of the area. The total equals the sum of BYTES USED - TOTAL (item 19) and BYTES OF FREE SPACE (item 20).
PCT=100 * SWEEP,TOTAL SPACE (11)
AREA,TOTAL SPACE (7)
If the entire area was swept, the first value is identical to that shown for AREA - TOTAL SPACE (item 7) and the percentage is 100.
12 BYTES USED - POINTERS--The number of bytes used by pointers in the swept area and the percentage of space used by pointers.
PCT=100 * BYTES USED,POINTERS (12)
SWEEP,TOTAL SPACE (11)
13 BYTES USED - DATA--The compressed number of bytes used by data (record occurrences) and the percentage of space used by data.
PCT=100 * BYTES USED,DATA (13)
SWEEP,TOTAL SPACE (11)
14 BYTES USED - LINE INDICES--The number of bytes used by line indexes and the percentage of space used by line indexes.
PCT=100 * BYTES USED,LINE INDICES (14)
SWEEP,TOTAL SPACE (11)
15 BYTES USED - HEADERS/FOOTERS--The number of bytes used by page headers plus the number of bytes used by page footers and the percentage of space used by both page headers and footers. Since each header uses 16 bytes and each footer uses 16 bytes, and there is one header and one footer per page, the first value is equivalent to 32 multiplied by the total number of pages swept in the area (item 10).
PCT=100 * BYTES USED,HEADERS/FOOTERS(15)
SWEEP,TOTAL SPACE (11)
16 BYTES USED - SR7 RECORDS--The number of bytes used by SR7 records and the percentage of space used by SR7 records.
17 BYTES USED - SR8 RECORDS--The number of bytes used by SR8 records and the percentage of space used by SR8 records.
18 BYTES USED - SMPS--The number of bytes used by space management pages minus the number of bytes used for headers and footers for those pages and the percentage of space used by space management pages.
PCT=100 * BYTES USED,SMPS (18)
SWEEP,TOTAL SPACE (11)
19 BYTES USED - TOTAL--The total number of bytes used in the area and the percentage of space used for this storage. The total number of bytes used is the sum of items 12, 13, 14, 15, 16, 17, and 18.
PCT=100 * BYTES USED,TOTAL (19)
SWEEP,TOTAL SPACE (11)
20 BYTES OF FREE SPACE--The actual free space found in the area and the percentage of actual free space found in the area. Bytes of free space is the sum of the space available values located in the header record of each page swept in the area.
PCT=100 * FREE SPACE (20)
SWEEP,TOTAL SPACE (11)
Also exhibited are the average number of bytes of free space on a page (AVG/PAGE), the maximum number of bytes of free space on a page that is not empty (MAX/PAGE), and the minimum number of bytes of free space on a page that is not full (MIN/PAGE).
AVG/PAGE = BYTES FREE SPACE (20)
TOTAL PAGES(10) - SMPS (23)
Note: The AVG/PAGE may exceed the MAX/PAGE if the area has a sufficient number of empty pages.
Bytes of free space values indicate area density. Poor performance for some database update functions may occur when area density is 80% or greater.
21 BYTES OF FREE SPACE LESS PAGE RESERVE --The number of bytes available for data storage and the percentage of bytes available for data storage. The values represent the actual free space found in the area minus the page reserve.
PCT=100 * FREE SPACE-PAGE RESERVE (21)
SWEEP,TOTAL SPACE (11)
22 PAGES PHYSICALLY FULL--The number of pages whose header record space available values are zero and the percentage of pages whose space available values are zero.
PCT=100 * PAGES PHYSICALLY FULL(22)
TOTAL PAGES (10) - SMPS (23)
When pages become physically full, records will overflow to pages with available space. Performance degradation due to overflow records is likely to become significant as the percentage of physically full pages increases beyond 50%.
23 PAGES LOGICALLY FULL--The number of pages containing the maximum data record occurrences and the percentage of pages containing the schema defined maximum record occurrences.
PCT=100 * PAGES LOGICALLY FULL (23)
TOTAL PAGES (10) - SMPS (25)
A large number of logically full pages indicates that the page size is too large for the record types being stored in the area.
24 PAGES EMPTY--The number of pages that contain no record occurrences and the percentage of pages that contain no record occurrences.
PCT=100 * PAGES EMPTY (24)
TOTAL PAGES (10) - SMPS (25)
25 SPACE MANAGEMENT PAGES--The number of space management pages and the percentage of space management pages.
PCT=100 * SPACE MANAGEMENT PAGES (25)
TOTAL PAGES (10)
A space management page is a CA IDMS generated administrative page that contains records showing the number of bytes available for each page in a series of pages in an area.
26 NUMBER OF RECORD OCCURRENCES--The total number of record occurrences in the area swept, including logically deleted (LDEL) records.
27 RECORDS OUT OF PHYSICAL SEQUENCE--As of Release 12.0, this value is always zero.
28 LDEL RECORDS IN AREA--The number of logically deleted record occurrences in the area swept and the percentage of logically deleted record occurrences in the area swept.
PCT=100 * LDEL RECORDS IN AREA (28)
RECORD OCCURRENCES (26)
LDEL records cause unnecessary update and retrieval overhead. This overhead increases with the number of LDEL records.
29 BYTES TO STORE (LDEL RECORDS)--The number of bytes used to store all logically deleted record occurrences and the percentage of bytes used for LDEL records.
PCT=100 * BYTES TO STORE (29)
SWEEP,TOTAL SPACE (11)
30 RELOCATED RECORDS IN AREA--The number of relocated record occurrences in the area swept and the percentage of relocated records.
PCT=100 * RELOCATED RECORDS (30)
RECORD OCCURRENCES (26)
Relocated records cause performance overhead. If the percentage of relocated records is greater than 20% and the percentage of bytes that could be returned (see item 32) exceeds 50%, consider reorganizing the database. If the percentage of relocated records is greater than 20% but the percentage of bytes that could be returned is less than 50%, consider expanding the database.
31 BYTES TO STORE (RELOCATED RECORDS)--The number of bytes used to store all relocated record occurrences (and associated pointers) and the percentage of bytes used for relocated records (SR2 and SR3 records).
PCT=100 * BYTES TO STORE REL RECS (31)
SWEEP,TOTAL SPACE (11)
32 BYTES THAT COULD BE RETURNED (RELOCATED RECORDS)--The number of bytes of relocated record storage 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 RETURNED (32)
BYTES TO STORE REL RECS (31)
33 FRAGMENTED RECORDS--The number of fragmented record occurrences and the percentage of fragmented record occurrences.
PCT=100 * FRAGMENTED RECORDS (33)
RECORD OCCURRENCES (26)
Record fragments cause performance overhead. If the percentage of fragments is greater than 20% and the percentage of bytes that could be returned (see item 35) exceeds 50%, consider reorganizing the database. If the percentage of record fragments is greater than 20% but the percentage of bytes that could be returned is less than 50%, consider expanding the database.
34 BYTES TO STORE (FRAGMENTED RECORDS)--The number of bytes used to store all record fragments and the percentage of bytes used to store all record fragments.
PCT=100 * BYTES TO STORE (FRAG RECS)(34)
BYTES USED,TOTAL (19)
35 BYTES THAT COULD BE RETURNED (FRAGMENTED RECORDS)--The 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 RETURNED(35)
BYTES TO STORE (FRAG RECS) (34)
36 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 = TOTAL FRAGMENTS (37)
FRAGMENTED RECORDS (33)
37 TOTAL FRAGMENTS IN AREA--The total number of record fragments in the area swept.
38 NUMBER OF RECORDS COMPRESSED--The number of compressed record occurrences and the percentage of compressed record occurrences. This does not include SR8 record compression.
PCT=100 * RECORDS COMPRESSED (38)
RECORD OCCURRENCES (26)
This statistic is valid only if IDMSCOMP was used as the compression routine.
39 SAVINGS DUE TO COMPRESSION--The number of bytes saved due to the compression of record occurrences (decompressed bytes minus compressed bytes) and the percentage of savings due to compression. The compression of SR8 records is not included in this statistic.
PCT=100 * SAVINGS DUE COMPRESSION (39)
AREA,TOTAL SPACE (7)
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 (MIN).
AVG = SAVINGS DUE COMPRESSION (39)
RECORDS COMPRESSED (38)
This statistic is valid only if IDMSCOMP was used as the compression routine.
40 SR8 RECORDS--The total number of SR8 records located in this area, and the percentage of the records in the area that are SR8 records.
PCT=100 * SR8 RECORDS (40)
RECORD OCCURRENCES (26)
41 DECOMPRESSED BYTES TO STORE--The maximum number of bytes required to store the SR8 records for this area when the automatic CA IDMS compression feature and the user-specified compression option are not used. You can expect to gain storage savings through compression when you specify SYMBOLIC KEY for the sort type.
42 COMPRESSED BYTES TO STORE--The number of bytes actually required to store the SR8 records for this area.
43 SAVINGS DUE TO COMPRESSION--The number of bytes saved through use of the CA IDMS automatic compression feature and/or the user-specified compression option.
PCT=100 * SAVINGS DUE TO COMPRESSION(43) COMPRESSED BYTES TO STORE(41)
|
Copyright © 2013 CA.
All rights reserved.
|
|