An example of an integrated index set that contains pointer errors is shown in Figure 4.15.
CA IDMS/DB Audit searches for this type of error 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 the set found to contain pointer errors.
RECORD NAME - Name of the record.
ID - Record identifier.
DBKEY - Db-key of database record.
NEXT DBKEY - Next pointer.
PRIOR DBKEY - Prior pointer (if present).
OWNER DBKEY - Owner pointer (if present).
RECORD DATA - First portion of data.
Error message - Indicates the type of error detected.
CA-TOOLS RELEASE CA IDMS/DB AUDIT DATE TIME PAGE Rnn.nn INTEGRITY ANALYSIS REPORT mm/dd/yy hh:mm:ss 0006 ********************************************************************************************************************* *********************************************** B E F O R E I M A G E ******************************************* ********************************************************************************************************************* xxxx034I INTEGRITY ERRORS DETECTED IN SET...IIX-STUD-SCHED-1 --OWNER RECORD-- -ID-- ----DBKEY--- -----NEXT DBKEY-- ---PRIOR DBKEY--- --------------RECORD DATA-------------------- STUDENT 8108 91,017-0001 **,***,***,-**** 91,017-0004 00017GARY LAWSON 10029 MAIN S xxxx036I RECORDS DETECTED WALKING NEXT FROM OWNER . . . **xxxx060E NEXT DBKEY IS NULL xxxx037I RECORDS DETECTED WALKING PRIOR FROM OWNER . . . ---RECORD NAME-- -ID-- ----DBKEY--- -----NEXT DBKEY-- ---PRIOR DBKEY--- ---OWNER DBKEY---- ----RECORD DATA---- SR8 0008 91,017-0004 91,017-0001 91,017-0001 91,017-0001
Figure 4.15: Integrated Index Pointer Errors
An example of a report that illustrates a set whose pointer errors have been fixed is shown in exhibit 4.16. CA IDMS/DB Audit fixes this type of error if USERSETS is specified in the FIX statement. (Integrated index pointer errors were detected when INDEX was specified in the AUDIT statement.)
Here is a description of fields that make up the After Image Report.
Lines 1 thru 5 - After image header--this example shows a Simulated After Image report banner. This report shows what the database looks 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,USERSETS.
Line 6 - Informative message--indicates the set that had a simulated fix performed.
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 several characters of data.
CA-TOOLS RELEASE CA IDMS/DB AUDIT DATE TIME PAGE Rnn.nn INTEGRITY ANALYSIS REPORT mm/dd/yy hh:mm:ss 0008 ********************************************************************************************************************* ********************************************** S I M U L A T E D A F T E R I M A G E ************************** ********************************************************************************************************************* xxxx035I FIXING PERFORMED ON SET...IIX-STUD-SCHED-1 --OWNER RECORD-- -ID-- ----DBKEY---- ----NEXT DBKEY- ----PRIOR DBKEY- -------------------RECORD DATA------------ STUDENT 8108 91,006-0001 91,006-0004 91,006-0004 00018DAVID LAWSON 10029 MAIN S ---RECORD NAME-- -ID-- ----DBKEY---- ----NEXT DBKEY- ----PRIOR DBKEY-- --OWNER DBKEY--- --RECORD DATA-- SR8 0008 91,006-0004 91,006-0001 91,006-0001 81,006-0001
Figure 4.16: Integrated Index Pointer Errors
|
Copyright © 2013 CA.
All rights reserved.
|
|