The Set Linkage Recap for Area is produced for each area in the old subschema during the Analysis Step. This subreport lists whether or not records have set linkage to records in the area being reorganized. This subreport also lists the method CA IDMS/DB Reorg uses, such as AREA SWEEP or SET WALKING, to access the old database to create pointer extracts, and displays the number of extracts created for each record. These numbers can be used to calculate sizes of the intermediate files. See the Operations chapter for instructions on how to calculate file sizes.
The following figure illustrates a Set Linkage Recap for Area with the following information:
|
Report Field |
Description |
|---|---|
|
Subreport Heading |
The title of the subreport. |
|
area-name |
The name of the area for which set linkage is reported. |
|
record-type |
The name of a record in the area. Each record is separated by a line of dashes. |
|
nn EXTRACTS/RECORD (AVG) |
The number of extracts created for each occurrence of the record type. The number of extracts is needed to compute the size of the intermediate work file. If the text NO SET LINKAGE/NO EXTRACTS appears in this field, the record does not have set linkage with any records in the COPY area and there is no information in the rest of the fields for that record. |
|
location mode |
The location mode of the record in the old database and in the new database. |
|
page range |
The page range for the record in the old database and in the new database. |
|
OWN/MEM |
Indicates whether the record is an owner or a member of the set in the SET NAME field. |
|
SET-NAME |
The name of the set. |
|
SET-POINTERS |
Indicates types of pointers in the set: NEXT, PRIOR, or OWNER. |
|
POINTER-EXTRACTS- CREATED-BY |
Indicates one of three methods CA IDMS/DB Reorg uses to create extracts: AREA SWEEP, SET WALKING, or USING NEXT AND PRIOR. |
|
NEW VIA-OWNER NAME |
The name of the VIA owner record type, if the record is stored VIA. If this field is blank, the record type is not stored VIA the set to which it belongs (set name shown in the SET NAME field). |
|
LOC-MODE |
The location mode of the record type listed under NEW VIA-OWNER. |
|
HI-VIA-OWNER |
CA IDMS/DB Reorg walks VIA sets to determine how to allocate them in logical set order. Because a VIA set owner can be stored VIA another set, CA IDMS/DB Reorg will not walk the set until it accesses the high VIA owner. The high VIA owner is stored in a noncopy area or has a location mode which is not VIA. |
Audit Subreport--Set Linkage Recap for Area:
ID RELEASE CA-IDMS/DB REORG DATE TIME PAGE Rnn.nn AUDIT REPORT mm/dd/yy hh:mm:ss nnnn SET LINKAGE RECAP FOR AREA CLASS-REGION - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 08106 CLASS...... RECORD 14 EXTRACTS / RECORD (AVG) OLD LOCATION MODE OF VIA PAGE RANGE OF 89,001 89,030 NEW LOCATION MODE OF VIA PAGE RANGE OF 89,001 89,030 OWN/MEM ---SET-NAME---- --SET-POINTERS-- POINTER-EXTRACTS-CREATED-BY NEW VIA-OWNER NAME LOC-MODE OWNER CLASS-SCHEDULE NEXT,PRIOR AREA SWEEP MEMBER TEACHER-CLASS NEXT,PRIOR,OWNER AREA SWEEP MEMBER PERIOD-CLASS NEXT,PRIOR,OWNER AREA SWEEP MEMBER ROOM-CLASS NEXT,PRIOR,OWNER AREA SWEEP MEMBER SUBJECT-CLASS NEXT,PRIOR,OWNER AREA SWEEP SUBJECT......... CALC HI-VIA-OWNER - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 08107 SCHEDULE... RECORD 7 EXTRACTS / RECORD (AVG) OLD LOCATION MODE OF VIA PAGE RANGE OF 89,001 89,030 NEW LOCATION MODE OF VIA PAGE RANGE OF 89,001 89,030 OWN/MEM ---SET-NAME---- --SET-POINTERS-- POINTER-EXTRACTS-CREATED-BY NEW VIA-OWNER NAME LOC-MODE OWNER SCHEDULE-BOGUS NEXT,PRIOR AREA SWEEP MEMBER CLASS-SCHEDULE NEXT,PRIOR,OWNER AREA SWEEP CLASS........... VIA MEMBER STUDENT-SCHEDULE NEXT,PRIOR AREA SWEEP - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 08115 CON-TROL.... RECORD NO SET LINKAGE / NO EXTRACTS - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 08116 BOGUS-1...... RECORD 5 EXTRACTS / RECORD (AVG) OLD LOCATION MODE OF VIA PAGE RANGE OF 89,001 89,030 NEW LOCATION MODE OF VIA PAGE RANGE OF 89,001 89,030 OWN/MEM ----SET-NAME---- --SET-POINTERS-- POINTER-EXTRACTS-CREATED-BY NEW VIA-OWNER NAME LOC-MODE OWNER BOGUS-ARTS NEXT,PRIOR AREA SWEEP MEMBER SCHEDULE-BOGUS NEXT,PRIOR AREA SWEEP SCHEDULE........ VIA MEMBER ACTIVITY-BOGUS NEXT AREA SWEEP NLYZ006I MAXIMUM RECORD SIZE FOR NEW SUBSCHEMA.....492 NLYZ007I MAXIMUM CALC KEY SIZE FOR OLD SUBSCHEMA......20 NLYZ008I MAXIMUM IX-DETAIL SIZE FOR OLD SUBSCHEMA.....108 NLYZ009I MAXIMUM IX-DETAIL SIZE FOR NEW SUBSCHEMA.....108 NLYZ012I MAXIMUM SYMBOLIC KEY SIZE FOR INDEXED SET......0 NLYZ013I MAXIMUM RECORD SIZE FOR AN SR8 RECORD.........0 NLYZ010I new/old SUBSCHEMA subschema-name WAS COMPILED compile-date compile-time DMCL dmcl-name, DBNAME dbname NLYZ005I END OF ANALYSIS REPORTS AUDT002I STEP: ANALYSIS, ENDED, CC=0000 DATE: mm/dd/yy TIME: hh:mm:ss
|
Copyright © 2014 CA.
All rights reserved.
|
|