Several examples of errors detected in integrated index sets are shown in Figures 4.19a, 4.19b, and 4.19c. These are errors other than orphan or pointer errors. CA IDMS/DB Audit searches for these types of errors if you specify INDEX in the AUDIT statement. The specific type of error on each report is indicated by the error message.
Here is a description of the fields that make up the Before Image Reports.
Lines 1 thru 5 - Before Image Report header.
Line 6 - Informative message--indicates the set found to contain errors.
RECORD NAME - Name of the record.
ID - Record identifier.
Record not found error:
DBKEY - SR8 table entry db-key of a record not found.
UPPER DBKEY - Db-key of the SR8 record.
Record type incorrect error:
DBKEY - SR8 table entry db-key of a record of an incorrect type.
UPPER DBKEY - Db-key of SR8 record whose table entry points to the record that is an incorrect type for the set.
SR8 upper level pointer not HIGH-VALUES error:
DBKEY - Db-key of the record whose upper level pointer is incorrect.
UPPER DBKEY - Db-key of the owner of the SR8 record.
CA-TOOLS RELEASE CA IDMS/DB AUDIT DATE TIME PAGE Rnn.nn INTEGRITY ANALYSIS REPORT mm/dd/yy hh:mm:ss 0005 ********************************************************************************************************************* ************************************************ B E F O R E I M A G E ****************************************** ********************************************************************************************************************* xxxx061I INDEX ENTRY DBKEY ERRORS DETECTED IN INTEGRATED INDEX RECORDS CONTAINED IN SET IX-DEPT-NAME --RECORD NAME-- -ID- ----DBKEY--- --UPPER DBKEY-- DEPT 1000 88,008-0023 92,223-0002 **xxxx088E RECORD NOT FOUND - RECORD NAME IS DEPT
Figure 4.19a: Additional Integrated Index Errors
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 ******************************************* ********************************************************************************************************************* xxxx061I INDEX ENTRY DBKEY ERRORS DETECTED IN INTEGRATED INDEX RECORDS CONTAINED IN SET IX-STUD-LNAME --RECORD NAME-- -ID- -----DBKEY--- --UPPER DBKEY-- CLASS 8106 89,003-0001 92,129-0025 **xxxx089E RECORD TYPE INCORRECT - RECORD NAME IS CLASS
Figure 4.19b: Additional Integrated Index Errors
CA-TOOLS RELEASE CA IDMS/DB AUDIT DATE TIME PAGE Rnn.nn INTEGRITY ANALYSIS REPORT mm/dd/yy hh:mm:ss 0008 ********************************************************************************************************************* ************************************************ B E F O R E I M A G E ****************************************** ********************************************************************************************************************* xxxx061I INDEX ENTRY DBKEY ERRORS DETECTED IN INTEGRATED INDEX RECORDS CONTAINED IN SET STUDENT-SCHEDULE --RECORD NAME-- -ID- -----DBKEY--- --UPPER DBKEY--- SR8 0008 91,004-0008 91,003-0042 **xxxx102E SR8 UPPER LEVEL POINTER IS NOT HIGH VALUES...
Figure 4.19c: Additional Integrated Index Errors
Here is a description of the fields that make up the Before Image Reports shown in Figures 4.20a and 4.20b.
Symbolic key errors:
DBKEY - Db-key of the record named.
SYMBOLIC KEY - Symbolic key of the record named.
UPPER DBKEY - Db-key of the SR8 record whose table entries were examined.
UPPER SYMB KEY - Symbolic key in the SR8 table entry. This symbolic key does not match the symbolic key in the SYMBOLIC KEY field.
Sort key sequence errors:
DBKEY - Db-key of SR8 record.
SORT KEY - Sort key entry in the SR8 record
UPPER DBKEY - Db-key of the upper level SR8 record whose db-key table entry points to the SR8 record identified in DBKEY field.
PREV SORT KEY - Sort key in the table entry in the upper level record identified in the UPPER DBKEY field. The sequence error means that this sort key does not match the sort key in the SORT KEY field.
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 ****************************************** ********************************************************************************************************************* xxxx062I SYMBOLIC KEY ERRORS DETECTED IN INTEGRATED INDEX RECORDS CONTAINED --RECORD NAME-- -ID- -----DBKEY-- --SYMBOLIC KEY- --UPPER DBKEY--- --UPPER SYMB KEY--- TEACHER 1001 88,003-0002 JONES 88,013-0017 WHITE TEACHER 1001 88,014-0002 GAVIC 88,013-0003 GOBEL TEACHER 1001 88,015-0004 GOBEL 88,013-0003 GAVIC
Figure 4.20a: Additional Integrated Index Errors
CA-TOOLS RELEASE CA IDMS/DB AUDIT DATE TIME PAGE Rnn.nn INTEGRITY ANALYSIS REPORT mm/dd/yy hh:mm:ss 0010 ********************************************************************************************************************* ************************************************ B E F O R E I M A G E ****************************************** ********************************************************************************************************************* xxxx063I SORT KEY SEQUENCE ERRORS DETECTED IN INTEGRATED INDEX RECORDS CONTAINED IN SET IX-STUD-LNAME xxxx064I SORT SEQUENCE ORDER IS DESCENDING ---RECORD NAME-- -ID- -----DBKEY---- ----SORT KEY--- -UPPER DBKEY- ---PREV SORT KEY- SR8 0008 92,129-0025 91,010-0036 92,129-0030 89,003-0048
Figure 4.20b: Additional Integrated Index Errors
Here is a description of the fields that make up the Before Image Reports shown in Figures 4.20c and 4.20d.
Sort key sequence error--set sorted by symbolic key:
DBKEY - Db-key of the SR8 record.
SORT KEY - Sort key entry in the SR8 record.
UPPER DBKEY - Db-key of the upper level SR8 record whose db-key table entry points to the SR8 record identified in item 9.
PREV SORT KEY - Sort key in the table entry in the upper level record identified in the UPPER DBKEY field. The sequence error means that this sort key does not match the sort key in SORT KEY field.
Disconnected records:
List of records disconnected from the indicated integrated index set.
CA-TOOLS RELEASE CA IDMS/DB AUDIT DATE TIME PAGE Rnn.nn INTEGRITY ANALYSIS REPORT mm/dd/yy hh:mm:ss 0011 ******************************************************************************************************************** **************************************************************** B E F O R E I M A G E ************************** ******************************************************************************************************************** xxxx063I SORT KEY SEQUENCE ERRORS DETECTED IN INTEGRATED INDEX RECORDS CONTAINED IN SET IX-TCHR-LNAME xxxx064I SORT SEQUENCE ORDER IS ASCENDING ---RECORD NAME-- -ID- ----DBKEY----- ---SORT KEY--- ---UPPER DBKEY-- -----PREV SORT KEY--- SR8 0008 88,008-0082 CLIFF 88,008-0083 JONES SR8 0008 88,013-0003 HARDI 88,013-0010 GOBEL
Figure 4.20c: Additional Integrated Index Errors
CA-TOOLS RELEASE CA IDMS/DB AUDIT DATE TIME PAGE Rnn.nn INTEGRITY ANALYSIS REPORT mm/dd/yy hh:mm:ss 0014 ********************************************************************************************************************* ************************************************* B E F O R E I M A G E ***************************************** ********************************************************************************************************************* xxxx060I INTEGRATED INDEX RECORDS DISCONNECTED FROM SET IX-SUBJ-NAME ---RECORD NAME-- -ID- -----DBKEY--- SUBJECT 1002 88,009-0016 SUBJECT 1002 88,009-0017 SUBJECT 1002 88,010-0010 SUBJECT 1002 88,012-0015 SUBJECT 1002 88,012-0016 SUBJECT 1002 88,015-0022
Figure 4.20d: Additional Integrated Index Errors
|
Copyright © 2013 CA.
All rights reserved.
|
|