Previous Topic: Integrated Index OrphansNext Topic: Additional Integrated Index Errors


Integrated Index Orphans Fixed

Here is a description of the fields that make up the After Image Report. See Figure 4.18.

Lines 1 thru 5 - After Image Report header--this example shows a Simulated After Image report banner. This report shows what the database will look like if the fixes are performed by CA IDMS/DB Audit.

Note: The fixes shown on this report have not been performed.In order for the fixes to be performed, submit another job that specifies FIX=UPDATE,INDEXORPHANS.

Line 6 - Informative message--indicates the set that had a simulated fix performed.

SET NAME - Integrated index set name.

RECORD NAME - Name of the record.

ID - Record identifier.

DBKEY - Db-key of the database 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 record (member or lower level SR8)--the pointer that was fixed.

CA-TOOLS                  RELEASE                     CA IDMS/DB AUDIT       DATE               TIME            PAGE                            Rnn.nn                 INTEGRITY ANALYSIS REPORT   mm/dd/yy           hh:mm:ss        0020  *********************************************************************************************************************  **********************************************  S I M U L A T E D   A F T E R   I M A G E  **************************  *********************************************************************************************************************  xxxx067I INTEGRATED INDEX ORPHANS FIXED.....      ----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,018-0013      IIX-STUD-ACT-1    SCHEDULE         8107     91,010-0027        91,018-0001          91,018-0013         91,018-0013      IIX-STUD-LNAME    SR8              0008     92,129-0005        92,129-0001          92,129-0029         92,129-0029      IIX-STUD-LNAME    SR8              0008     92,129-0011        92,129-0001          92,129-0027         92,129-0027      IIX-STUD-LNAME    SR8              0008     92,129-0012        92,129-0001          92,129-0024         92,129-0024      IIX-STUD-LNAME    SR8              0008     92,129-0013        92,129-0001          92,129-0022         92,129-0022      IIX-STUD-LNAME    SR8              0008     92,129-0017        92,129-0001          92,129-0032         92,129-0032      IIX-STUD-LNAME    SR8              0008     92,129-0018        92,129-0001          92,129-0029         92,129-0029      IIX-STUD-LNAME    SR8              0008     92,129-0019        92,129-0001          92,129-0024         92,129-0024      IIX-STUD-LNAME    SR8              0008     92,129-0024        92,129-0001          92,129-0030         92,129-0030      IIX-STUD-LNAME    SR8              0008     92,129-0025        92,129-0001          92,129-0036         92,129-0036      IIX-STUD-LNAME    SR8              0008     92,129-0034        92,129-0001          92,129-0036         92,129-0036      IIX-STUD-LNAME    STUDENT          8108     91,002-0001        92,129-0001          92,129-0012         92,129-0012      IIX-STUD-LNAME    STUDENT          8108     91,002-0002        92,129-0001          92,129-0012         92,129-0012      IIX-STUD-LNAME    STUDENT          8108     91,002-0003        92,129-0001          92,129-0019         92,129-0019      IIX-STUD-LNAME    STUDENT          8108     91,002-0004        92,129-0001          92,129-0019         92,129-0019      IIX-STUD-LNAME    STUDENT          8108     91,002-0005        92,129-0001          92,129-0038         92,129-0038      IIX-STUD-LNAME    STUDENT          8108     91,002-0006        92,129-0001          92,129-0038         92,129-0038      IIX-STUD-LNAME    STUDENT          8108     91,004-0001        92,129-0001          92,129-0014         92,129-0014      IIX-STUD-LNAME    STUDENT          8108     91,007-0001        92,129-0001          92,129-0018         92,129-0018      IIX-STUD-LNAME    STUDENT          8108     91,007-0002        92,129-0001          92,129-0018         92,129-0018      IIX-STUD-LNAME    STUDENT          8108     91,007-0003        92,129-0001          92,129-0028         92,129-0028      IIX-STUD-LNAME    STUDENT          8108     91,010-0001        92,129-0001          92,129-0025         92,129-0025

Figure 4.18: Integrated Index Orphans Fixed