The report in Figure 4.17 shows a list of records detected as orphans of integrated index sets. A record is an orphan record of an integrated index set if the upper level db-key does not point to the correct record in the level above it.
CA IDMS/DB Audit searches for orphan records of integrated index sets if INDEX is specified in the AUDIT statement.
Here is a description of the fields that make up the Before Image Report.
Lines 1 thru 5 - Before Image Report header.
Line 6 - Informative message--indicates that integrated index orphans were found.
SET NAME - Integrated index set name.
RECORD NAME - Name of the record.
ID - Record identifier.
DBKEY - Db-key of the record.
OWNER DBKEY - Owner pointer.
UPPER DBKEY - Db-key of the correct SR8 record in the level above.
MEM-UPPER-DBKEY - Upper level pointer of orphan record (member or lower level SR8)--the pointer in error.
CA-TOOLS RELEASE CA IDMS/DB AUDIT DATE TIME PAGE Rnn.nn INTEGRITY ANALYSIS REPORT mm/dd/yy hh:mm:ss 0013 ********************************************************************************************************************* ************************************************* B E F O R E I M A G E ***************************************** ********************************************************************************************************************* xxxx059I INTEGRATED INDEX ORPHAN RECORDS DETECTED...... ----SET NAME-- -RECORD NAME-- -ID- ---DBKEY--- ---OWNER DBKEY-- ----UPPER DBKEY-- -MEM-UPPER-DBKEY- IIX-STUD-ACT-1 SCHEDULE 8107 91,010-0007 91,018-0001 91,018-0013 91,010-0001 IIX-STUD-ACT-1 SCHEDULE 8107 91,010-0027 91,018-0001 91,018-0013 91,010-0001 IIX-STUD-LNAME SR8 0008 92,129-0005 92,129-0001 92,129-0029 92,129-0008 IIX-STUD-LNAME SR8 0008 92,129-0011 92,129-0001 92,129-0027 92,129-0007 IIX-STUD-LNAME SR8 0008 92,129-0012 92,129-0001 92,129-0024 92,129-0008 IIX-STUD-LNAME SR8 0008 92,129-0013 92,129-0001 92,129-0022 92,129-0003 IIX-STUD-LNAME SR8 0008 92,129-0017 92,129-0001 92,129-0032 92,129-0016 IIX-STUD-LNAME SR8 0008 92,129-0018 92,129-0001 92,129-0029 92,129-0008 IIX-STUD-LNAME SR8 0008 92,129-0019 92,129-0001 92,129-0024 92,129-0015 IIX-STUD-LNAME SR8 0008 92,129-0024 92,129-0001 92,129-0030 92,129-0017 IIX-STUD-LNAME SR8 0008 92,129-0025 92,129-0001 92,129-0036 92,129-0011 IIX-STUD-LNAME SR8 0008 92,129-0034 92,129-0001 92,129-0036 92,129-0026 IIX-STUD-LNAME STUDENT 8108 91,002-0001 92,129-0001 92,129-0012 92,129-0004 IIX-STUD-LNAME STUDENT 8108 91,002-0002 92,129-0001 92,129-0012 92,129-0005 IIX-STUD-LNAME STUDENT 8108 91,002-0003 92,129-0001 92,129-0019 92,129-0005 IIX-STUD-LNAME STUDENT 8108 91,002-0004 92,129-0001 92,129-0019 92,129-0014 IIX-STUD-LNAME STUDENT 8108 91,002-0005 92,129-0001 92,129-0038 92,129-0014 IIX-STUD-LNAME STUDENT 8108 91,002-0006 92,129-0001 92,129-0038 92,129-0023 IIX-STUD-LNAME STUDENT 8108 91,004-0001 92,129-0001 92,129-0014 92,129-0005 IIX-STUD-LNAME STUDENT 8108 91,007-0001 92,129-0001 92,129-0018 92,129-0004 IIX-STUD-LNAME STUDENT 8108 91,007-0002 92,129-0001 92,129-0018 92,129-0006 IIX-STUD-LNAME STUDENT 8108 91,007-0003 92,129-0001 92,129-0028 92,129-0006 IIX-STUD-LNAME STUDENT 8108 91,010-0001 92,129-0001 92,129-0025 92,129-0002
Figure 4.17: Integrated Index Orphans
|
Copyright © 2013 CA.
All rights reserved.
|
|