System Output › Integrity Analysis Report › Diagramming Errors

Diagramming Errors

The next several pages of this section contain step-by-step instructions that show how to draw a diagram of a set in error by using the information shown on a Before Image Report.

Following the discussion of diagramming errors, there are sample reports showing how various types of errors are reported. The types of errors listed in Figure 4.8 are illustrated in the exhibits indicated.

 Type of Error        To find this error specify:    Report Illustrated in Figure:
                                                     Before Image       After Image

 Pointer               USERSETS                       4.11
                       CALCSETS

 Set Integrity         USERSETS                       4.12               4.13
   Miscellaneous       CALCSETS

 Set Disconnections    DISCONNECT = ALL               4.14
                       DISCONNECT = EXPLICIT

 IIX Pointers          INDEX                          4.15               4.16

 IIX Orphans           INDEX                          4.17               4.18

 IIX Integrity         INDEX                          4.19, 4.20
   Miscellaneous

 From/Thru Page Range  USERSETS                       4.21
                       CALCSETS

 Orphans of sets       USERSETS, WALKNEXT             4.22
   that are not IIX    CALCSETS, WALKNEXT
                       AUDITTYPE = QUICKCHECK

 Fragmented Records    USERSETS                       4.23
                       CALCSETS

 Compressed Records    USERSETS                     Not Illustrated    Not Illustrated
                       CALCSETS

 LDEL                  USERSETS                                           4.24

 Header                PAGES                          4.25                4.26
 Footer

Figure 4.8: Integrity Analysis Report Illustrations

In order to understand better how CA IDMS/DB Audit detected certain errors, you can draw a picture of the set in error by using the information contained in the Before Image Report. For the following example, see the Before Image Report in Figure 4.9, and follow the step-by-step procedure for drawing the set in error.

• Step 1. Message xxxx034I indicates integrity errors in the DEPT-TEACHER set occurrence.
• Step 2. Starting with the OWNER record (88,008-001) the NEXT (first) member is listed as 88,010-001 and the PRIOR (last) member is 88,009-003.

  

• Step 3. Message xxxx036I indicates that CA IDMS/DB Audit will walk next from the OWNER record.
• Step 4. The NEXT record (88,010-001) points to 88,002-001 as the NEXT member in the set and points back to the OWNER record (88,008-001).

  

 CA-TOOLS                  RELEASE                    CA IDMS/DB AUDIT        DATE               TIME            PAGE
                           Rnn.nn                 INTEGRITY ANALYSIS REPORT   mm/dd/yy           hh:mm:ss        0007
 *********************************************************************************************************************
 ************************************************  B E F O R E   I M A G E  ******************************************
 *********************************************************************************************************************

 xxxx034I INTEGRITY ERRORS DETECTED IN SET...DEPT-TEACHER

     --OWNER RECORD-- -ID-  --DBKEY---  -NEXT DBKEY- -PRIOR DBKEY--  --------------------------RECORD DATA--------------------------
     DEPT             1000  88,008-001   88,010-001      88,009-003  MATH DEPARTMENT             DANNY      DUDE      000000209

 xxxx036I RECORDS DETECTED WALKING NEXT FROM OWNER . . .

     --RECORD NAME--  -ID-  --DBKEY---  -NEXT DBKEY-  -PRIOR DBKEY-  -OWNER DBKEY---- --------------RECORD DATA---------------------
     TEACHER          1001  88,010-001   88,002-001      88,008-001        88,008-001  00002JOHN SMITH      MATH       MA/MATH

     TEACHER          1001  88,002-001   88,005-002      88,008-003        88,008-001  00004JACK WORD       MATH       BS/MATH
 **xxxx068E PRIOR DBKEY DOES NOT POINT BACK TO PRIOR RECORD IN SET

     TEACHER          1001  88,005-002   88,009-003      88,002-001        88,008-001  00007DANNY DUDE      MATH       BS/MATH

     TEACHER          1001  88,009-003   88,008-001      88,005-002        88,008-001  00029CLARE CLIFFORD  MATH       BS,MS,P
 xxxx038I RECORDS DETECTED WALKING PRIOR FROM     88,002-001 ...

     TEACHER          1001  88,008-003   88,002-001      88,010-001        88,008-001  00003THOMAS WHITE    MATH       BS/MATH
 xxxx039I NEXT  DBKEY POINTS TO PREVIOUSLY AUDITED RECORD IN SET

Figure 4.9:: Before Image Report

Diagramming Errors--Before Image Report

• Step 5. Member 88,002-001 points to 88,005-002 as the NEXT member in the set and points back to record 88,008-003.

  

• Step 6. Error message xxxx068E indicates that the previous step is in error. The error is that record 88,002-001's PRIOR pointer does not point back to record 88,010-001. At this point, CA IDMS/DB Audit saves db-key 88,002-001 for later processing. See Concepts.
• Step 7. Continuing with the next member in the set (88,005-002), it points to 88,009-003 as the NEXT member in the set and points back to record 88,002-001.

  

• Step 8. Member 88,009-003 points to the OWNER record (88,008-001) as the NEXT record in the set, and points back to record 88,005-002. At this point, CA IDMS/DB Audit stops walking the set in the next direction.

  

• Step 9. Message xxxx038I indicates that CA IDMS/DB Audit has retrieved db-key 88,002-001 and will start walking the set in the prior direction. The first record found is 88,008-003. This record points to record 88,002-001 as the NEXT record in the set, and points to record 88,010-001 as the PRIOR record in the set.

  

• Step 10. Message xxxx039I indicates that this is as far as CA IDMS/DB Audit can process this set occurrence because record 88,008-003 points to a record that was already processed.

  This step completes the diagramming of the indicated error.

  In Figure 4.10 is a Simulated After Image Report that shows how CA IDMS/DB Audit would fix the error that was diagramed.

  The following diagram shows how the fixed set occurrence will look. The physical integrity error is fixed. The logical integrity should now be examined. See Logical Integrity for an example of a logical integrity error.

  

 CA-TOOLS                  RELEASE                    CA IDMS/DB AUDIT        DATE               TIME            PAGE
                           Rnn.nn                 INTEGRITY ANALYSIS REPORT   mm/dd/yy           hh:mm:ss        0019
 *********************************************************************************************************************
 *******************************************  S I M U L A T E D   A F T E R   I M A G E  *****************************
 *********************************************************************************************************************

 xxxx035I FIXING PERFORMED ON SET...DEPT-TEACHER

     --OWNER RECORD-- -ID-  -DBKEY---- -NEXT DBKEY-   -PRIOR DBKEY-    --------------------------------RECORD DATA--------------

     DEPT             1000  88,008-001   88,010-001      88,009-003    MATH DEPARTMENT        DANNY         DUDE    0000000208

     ---RECORD NAME-- -ID-  --DBKEY--- -NEXT DBKEY-  -PRIOR DBKEY-     -OWNER DBKEY--  ------------RECORD DATA------------------

     TEACHER          1001  88,010-001   88,008-003      88,008-001        88,008-001  00002JOHN   SMITH     MATH   MA/MATH
     TEACHER          1001  88,008-003   88,002-001      88,010-001        88,008-001  00003THOMAS  WHITE    MATH   BS/MATH
     TEACHER          1001  88,002-001   88,005-002      88,008-003        88,008-001  00004JACK    WORD     MATH   BS/MATH
     TEACHER          1001  88,005-002   88,009-003      88,002-001        88,008-001  00007DANNY   DUDE     MATH   BS/MATH
     TEACHER          1001  88,009-003   88,008-001      88,005-002        88,008-00100029CLARE     CLIFFORD MATH   BS,MS,P

Figure 4.10: Simulated After Image Report