Identification and Set Statistic Section fields are described below.
CA-TOOLS RELEASE CA IDMS/DB ANALYZER DATE TIME PAGE Rnn.nn SET REPORT dd/mm/yy hh:mm:ss nnnn SET STATISTICS SECTION 1 ► SET NAME: ACTIVITY - TYPES 2 ► FILE CREATION DATA: mm/dd/yy - hh:mm:ss ITEM TOTAL PCT ----------------------------- ------- ----- 3 ► OWNER RECORD NAME ACTIVITY 4 ► MEMBER RECORD NAME MULTI-MEMBER SET 5 ► SET OCCURRENCES 3 6 ► SET OCCURRENCES WITH MEMBERS 3 100 7 ► MEMBER RECORD OCCURRENCES 9 8 ► LDEL OCCURRENCES 0 0 9 ► LENGTH OF SET OCCURRENCES AVG 3.00 MAX 3 MIN 3 10► BYTES TO STORE OWNERS 180 27 11► BYTES TO STORE MEMBERS 480 73 12► BYTES TO STORE LDELS 0 0 13► TOTAL BYTES TO STORE SET 660 14► CLUSTER PAGE SPREAD AVG 1.67 MAX 3 15► MEMBERS ON TARGET PAGE 6 67 AVG 2.00 MAX 3 MIN 3 16► MEMBERS ON OVERFLOW 0 0 AVG 0.00 MAX 0 MIN 0 17► MEMBERS NOT VIA THIS SET 3 33 AVG 1.00 MAX 3 MIN 3 18► OCCURRENCES W/O PAGE CHANGES 0 0 19► PAGE CHANGES AVG 1.67 MAX 3 MIN 1
CA-TOOLS RELEASE CA IDMS/DB ANALYZER DATE TIME PAGE Rnn.nn SET REPORT dd/mm/yy hh:mm:ss nnnn SET STATISTICS SECTION SET NAME: IX - STUD - LNAME FILE CREATION DATA: mm/dd/yy - hh:mm:ss ITEM TOTAL PCT ----------------------------- ------- ----- OWNER RECORD NAME SR7 MEMBER RECORD NAME STUDENT SET OCCURRENCES 1 SET OCCURRENCES WITH MEMBERS 1 100 MEMBER RECORD OCCURRENCES 51 LDEL OCCURRENCES 0 0 LENGTH OF SET OCCURRENCES AVG 51.00 MAX 51 MIN 51 BYTES TO STORE OWNERS 32 0 BYTES TO STORE MEMBERS 4,600 69 BYTES TO STORE LDELS 0 0 20► BYTES TO STORE SR8 RECORDS 2,060 31 TOTAL BYTES TO STORE SET 6,692 CLUSTER PAGE SPREAD AVG 18.00 MAX 18 OCCURRENCES W/O PAGE CHANGES 0 0 PAGE CHANGES AVG 102.00 MAX 102 MIN 102
1 SET NAME--The name of the set type for the reported statistics. CALC sets are identified as such and reported by area.
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.
Note: In a case where only a portion of an area has been swept forstatistical accumulation, set report field values pertain only to the portion of the area swept. In other words, as long as member records reside in accessible areas, set statistics are accumulated when only a portion of an area is swept. However, statistics for any set occurrences whose owner records reside outside the portion of the area swept are not accumulated and are not reflected in the values whose descriptions follow.
Remember that statistics shown on the Set Report apply only to the set indicated in the SET NAME field of the report. See Set Report Identification Fields, item 1.
3 OWNER RECORD NAME--The name of the owner record in this set. For the CALC set, the owner name will be listed as SR1.
4 MEMBER RECORD NAME--The name of the member record in this set. For multi-member sets, the member name will be listed as Multi-member Set. All of the member names in a multi- member set will be listed in the multi-member set analysis section.
5 SET OCCURRENCES--The total number of owner record occurrences.
6 SET OCCURRENCES WITH MEMBERS--The total number of owner record occurrences that own at least one member record occurrence and the percentage of these non-null occurrences.
PCT=100 * SET OCCURRENCES WITH MBRS(6)
SET OCCURRENCES (5)
7 MEMBER RECORD OCCURRENCES--The total number of member record occurrences.
8 LDEL OCCURRENCES--The number of logically deleted member record occurrences for the set type and the percentage of all member occurrences that are logically deleted.
PCT=100 * LDEL OCCURRENCES (8)
MEMBER RECORD OCCURRENCES(7)
9 LENGTH OF SET OCCURRENCES--The average (AVG), maximum (MAX), and minimum (MIN) number of member record occurrences (set length) for owner record occurrences that own at least one member record.
AVG = MEMBER RECORD OCCURRENCES (7)
SET OCCURRENCES WITH MEMBERS (6)
Set types in sorted order with high average lengths and high average cluster page spread (item 14) are likely to have unwanted performance overhead during update operations. In such a case, consider reorganization or database expansion.
10 BYTES TO STORE OWNERS--The number of bytes used to store owner record occurrences and the percentage of bytes used to store owner record occurrences.
PCT=100 * BYTES TO STORE OWNERS (10)
TOTAL BYTES TO STORE SET (13)
11 BYTES TO STORE MEMBERS--The number of bytes used to store member record occurrences and the percentage of bytes used to store member record occurrences.
PCT=100 * BYTES TO STORE MEMBERS (11)
TOTAL BYTES TO STORE SET (13)
12 BYTES TO STORE LDELS--The number of bytes used to store logically deleted record occurrences and the percentage of bytes used to store logically deleted record occurrences.
PCT=100 * BYTES TO STORE LDELS (12)
TOTAL BYTES TO STORE SET (13)
13 TOTAL BYTES TO STORE SET--The total number of bytes used to store owner, member, and logically deleted record occurrences. It is the sum of items 10, 11, and 12 (and, if the set is an SR8 index set, item 20).
14 CLUSTER PAGE SPREAD--The average (AVG) and maximum (MAX) number of different pages on which member record occurrences reside for all set occurrences.
AVG = PAGES WITH SET MEMBERS
SET OCCURRENCES WITH MEMBERS (6)
where PAGES WITH SET MEMBERS is derived by taking the number of different overflow pages (on which member records reside) for each set occurrence, and then finding the sum of those numbers of pages for all set occurrences in the set type.
Note: Only those set occurrences that have members residing on overflow pages are included in this statistic.
Determine the optimum average cluster page spread by dividing the average set length by the number of record occurrences that can fit on one page. If the actual average cluster page spread value is significantly higher than the optimum, performance when retrieving an entire set occurrence is likely to be poor due to excessive input/output operations. In such a case, consider database reorganization.
15 MEMBERS ON TARGET PAGE--The total number of member record occurrences residing on target page and the percentage of member occurrences residing on target page. (A target page is the page on which the system designated that a record be located if there is space available.)
PCT=100 * MEMBERS ON TARGET PAGE(15)
MEMBER RECORD OCCURRENCES(7)
Also included are the average number of member occurrences on target page (AVG), the maximum number of member occurrences on target page for a single set occurrence (MAX), and the minimum number of member occurrences on target page for a single set occurrence (MIN) that had at least one member on the target page.
AVG = MEMBERS ON TARGET PAGE (15)
SET OCCURRENCES WITH MEMBERS (6)
These fields appear only when at least one set member is stored via this set.
Note: If there are a large number of set occurrences without members, itis possible for the AVG members on target page to be less than the MIN members on target page.
16 MEMBERS ON OVERFLOW--The total number of member record occurrences on overflow and the percentage of member occurrences on overflow. (A record occurrence located on a page other than its target page is said to be on overflow.)
PCT=100 * MEMBERS ON OVERFLOW (16)
MEMBER RECORD OCCURRENCES (7)
Also included are the average number of member records on overflow (AVG), the maximum number of member records on overflow for a single set occurrence (MAX), and the minimum number of member records on overflow for a single set occurrence that had at least one member on overflow (MIN).
AVG = MEMBERS ON OVERFLOW (16)
SET OCCURRENCES WITH MEMBERS (6)
These fields appear only when at least one set member is stored VIA this set.
Note: If there are a large number of set occurrences without members, itis possible for the AVG members on overflow to be less than the MIN members on overflow.
17 MEMBERS NOT VIA THIS SET--The total number of member record occurrences that are members of this set but are not VIA this set and the percentage of the total number of member records that are not VIA this set.
PCT=100 * MEMBERS NOT VIA THIS SET (17)
MEMBER RECORD OCCURRENCES(7)
Also included are the average number of member records not VIA this set (AVG), the maximum number of member records not VIA this set for a single set occurrence (MAX), and the minimum number of member records not VIA this set for a single set occurrence that had at least one member not VIA the set (MIN).
This field appears only on multi-member set reports.
AVG = MEMBERS NOT VIA THIS SET (17)
SET OCCURRENCES WITH MEMBERS (6)
This field will only be printed for non-CALC, VIA sets.
Note: If there are a large number of set occurrences without members, itis possible for the AVG number of members not VIA this set to be less than the MIN number of members not VIA this set.
18 OCCURRENCES W/O PAGE CHANGES--The number of set occurrences whose members are contained on the same page as their owner records (hence no page changes while walking the set) and the percentage of total set occurrences with members that do not have page changes while walking the set occurrence.
PCT=100 * OCCURRENCES W/O PAGE CHNGS(18)
SET OCCURRENCES WITH MBERS(6)
19 PAGE CHANGES--The average number of page changes required to walk set occurrences (AVG), the greatest number of page changes required to walk a single set occurrence (MAX), and the fewest number of page changes required while walking a set occurrence with at least one page change (MIN). If any of the member records are fragmented, the user may encounter more page changes when walking the set in CA IDMS; CA IDMS/DB Analyzer does not recompose fragments during SET-WALK processing.
AVG = PAGE CHANGES,ALL SET OCS
SET OCCURRENCES WITH MEMBERS (6)
If the average number of page changes is significantly higher than the optimum average cluster page spread (see item 14), performance when retrieving an entire set occurrence is likely to be poor. In such a case, consider database reorganization.
Note: If there are a large number of set occurrences with no page changes,it is possible for the AVG page changes to be less than the MIN page changes.
20 BYTES TO STORE SR8 RECORDS--The number of bytes used to store SR8 index record occurrences and the percentage of bytes used to store SR8 record occurrences.
PCT=100 * BYTES TO STORE SR8 RECORDS(20)
TOTAL BYTES TO STORE SET (13)
This field will only be present if the report is for an SR8 (integrated index) set.
|
Copyright © 2013 CA.
All rights reserved.
|
|