System Output › Integrity Analysis Report › Pointer Errors

Pointer Errors

An example of a record that contains an invalid prior db-key is shown in Figure 4.11. Records displayed on this section of the report are grouped by set name.

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 the set found to contain pointer errors.

RECORD NAME - Name of the record.

ID - Record identifier.

DBKEY - Db-key of the database record.

NEXT DBKEY - Next pointer.

PRIOR DBKEY - Prior pointer (if present).

OWNER DBKEY - Owner pointer (if present).

RECORD DATA - First 45 characters of data.

Error messages - Indicate the types of errors detected.

 CA-TOOLS                  RELEASE                      CA IDMS/DB AUDIT      DATE               TIME            PAGE
                           Rnn.nn                 INTEGRITY ANALYSIS REPORT   mm/dd/yy           hh:mm:ss        0009
 *********************************************************************************************************************
 **************************************************  B E F O R E   I M A G E  ****************************************
 *********************************************************************************************************************
 xxxx034I INTEGRITY ERRORS DETECTED IN SET...ACTIVITY-TYPES
     --OWNER RECORD-- -ID-- --DBKEY---  -NEXT DBKEY-  -PRIOR DBKEY-       --------------------RECORD DATA-------------
     ACTIVITY         8111  89,010-001   91,003-014      91,048-001       ACTIVITY03TRACK AND FIELD
 xxxx036I RECORDS DETECTED WALKING NEXT FROM OWNER . . .

     ---RECORD NAME-- -ID-- --DBKEY---  -NEXT DBKEY-  -PRIOR DBKEY-     -OWNER DBKEY-    -----------------RECORD DATA----------
     SPORTS           8112  91,003-014   91,019-001      89,010-001        89,010-001    BROADJUMP1WOMENS BROAD JUMP
     SPORTS           8112  91,019-001   91,048-001   *,***,***-***        89,010-001    BROADJUMP2MENS BROAD JUMP
 **xxxx060E PRIOR DBKEY IS NULL
     SPORTS           8112  91,048-001   89,010-001      91,019-001        89,010-001    TRACK  101HURDLES
 xxxx037I RECORDS DETECTED WALKING PRIOR FROM OWNER . . .
     SPORTS           8112  91,048-001   89,010-001      91,019-001        89,010-001    TRACK  101HURDLES
     SPORTS           8112  91,019-001   91,048-001   *,***,***-***        89,010-001    BROADJUMP2MENS BROAD JUMP
 **xxxx060E PRIOR DBKEY IS NULL

Figure 4.11: Pointer Errors