Previous Topic: Set Report Field DescriptionsNext Topic: Histogram Section Fields


Distribution Section Fields

The Distribution Section of the Set Report is shown in the following display. This section of the report displays the distribution of the following set features.

CA-TOOLS RELEASE CA IDMS/DB ANALYZER DATE TIME PAGE Rnn.nn SET REPORT dd/mm/yy hh:mm:ss nnnn DISTRIBUTION SECTION SET NAME: IX - STUD - LNAME FILE CREATION DATA: mm/dd/yy - hh:mm:ss ITEM RANGE TOTAL PCT ---------------------------- ------- ------- ----- 1 ► CLUSTER PAGE SPREAD PAGES # SET OCCURRENCES 1 - 1 0 0 2 - 2 0 0 3 - 3 0 0 4 - 4 0 0 5 - 5 0 0 6 - 7 0 0 8 - 10 0 0 11 - 15 0 0 16 - 20 1 100 21 - 99999999 0 0 2 ► LENGTH OF SET OCCURRENCES MBR OCCURRENCES # SET OCCURRENCES 0 - 0 0 0 1 - 10 0 0 11 - 20 0 0 21 - 30 0 0 31 - 40 0 0 41 - 50 0 0 51 - 60 1 100 61 - 70 0 0 71 - 80 0 0 81 - 99999999 0 0

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 type indicated in the SET NAME field of the report. See Set Report Identification Fields, item 1.

1 CLUSTER PAGE SPREAD--The distribution of set occurrences by number of different overflow pages on which member record occurrences reside is shown here. The number of different overflow pages are listed under the column headed RANGE. The number of set occurrences with all members on the corresponding number of overflow pages is listed in the column headed TOTAL. The percentage of set occurrences found in each page range is listed in the column headed PCT.

 PCT=100    *        SET OCS PER PAGE RANGE
                     SET OCS WITH MEMBERS (Set Statistics 6)

Note: Set occurrences with all members on the target page are not included in this statistic.

2 LENGTH OF SET OCCURRENCES--Thedistribution by number of member record occurrences per set occurrence is shown here. Ranges of member occurrences are listed under the column headed RANGE. The number of set occurrences whose member record count falls within each range is listed in the column headed TOTAL.

The percentage of set occurrences falling within each range is listed in the column headed PCT.

 PCT=100    *        SET OCS PER LENGTH RANGE
                     SET OCS (Set Statistics 5)