Global consistency errors (index check)

Errors in the index value relationships between two chained table pages of an indexed table or between the pages of the overflow chain of a duplicate table are reported by BCHECK with the header:

THE FOLLOWING CHANGE OF DATABASE IS NOT CONSISTENT DUE TO WRONG KEY VALUE RELATIONS IN MATCHING CHECK-RECORDS

If, however, BCHECK reports the following in the header:

THE FOLLOWING CHANGE OF DATABASE IS NOT CONSISTENT DUE TO DIFFERENT KEY LENGTHS IN MATCHING CHECK-RECORDS

then the index values to be compared were of different lengths. In such a case, BCHECK does not perform the actual index check.

The index check messages are listed below.

***THE FOLLOWING DATABASE CHANGES MAY BE CONNECTED WITH THE CONSISTENCY ERROR:

G0500	FOR OWNER-DBKEY dbkey DBTT-COL col-no A TABLE-OCCURRENCE AT TABLE LEVEL levno WAS ADDED TO PAGE act-key-1 POINTING TO NEXT HIGHER TABLE IN PAGE act-key-2. CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue-2 rsq-2 Meaning In the indexed table which is uniquely identified by owner record dbkey and DBTT column number col-no, in table page act-key-2 of level levno+1 the index value keyvalue-1 rsq-1 of an entry is smaller than the highest index value keyvalue-2 rsq-2 in the table page act-key-1 of the next lower level levno to which it refers.
G0501	FOR OWNER-DBKEY dbkey DBTT-COL col-no AN ENTRY REFERRING TO A TABLE-OCCURRENCE AT LEVEL levno WAS ADDED TO THE TABLE AT NEXT HIGHER LEVEL POINTING TO A PAGE act-key-1 WITH THE REFERENCE COMING FROM PAGE act-key-2 WITH NO CORRESPONDING CHANGE OF LOCATION OF THE TABLE-OCCURRENCE POINTED AT. CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue-1 rsq-1
G0600	IN AN INDEXED TABLE FOR OWNER-DBKEY dbkey DBTT-COL col-no AN ENTRY AT TABLE LEVEL levno+1 WAS ADDED TO PAGE act-key-3 POINTING TO A TABLE AT NEXT-LOWER LEVEL act-key-2 WITH NO CORRESPONDING CHANGE OF THE SUCCESSOR OF THE REFERENCED TABLE CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue-2 rsq-2 Meaning In the indexed table which is uniquely identified by owner record dbkey and DBTT column number col-no, in table page act-key-3 of level levno+1 the index value keyvalue-2 rsq-2 of an entry is not smaller than the lowest index value keyvalue-1 rsq-1 of successor page act-key-1 of that table page act-key-2 to which the entry refers.
G0601	IN AN INDEXED TABLE FOR OWNER-DBKEY dbkey DBTT-COL col-no AN ENTRY AT TABLE LEVEL levno WAS ADDED TO PAGE act-key-1 POINTING TO ITS PREDECESSOR IN THE TABLE CHAIN act-key-2 WITH NO CORRESPONDING CHANGE OF THE TABLE AT NEXT HIGHER LEVEL. CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue-1 rsq-1
G0700	FOR OWNER-DBKEY dbkey DBTT-COL col-no A TABLE-OCCURRENCE AT TABLE LEVEL levno WAS ADDED TO PAGE act-key-2 POINTING TO PRIOR TABLE IN PAGE act-key-1 CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue-2 rsq-2 Meaning In the table chain which is uniquely identified by owner record dbkey and DBTT column number col-no, the highest index value keyvalue-1 rsq-1 in table page act-key-1 is not smaller than the lowest index value keyvalue-2 rsq-2 in successor page act-key-2 of the table chain at the same level levno.
G0701	FOR OWNER-DBKEY dbkey DBTT-COL col-no A TABLE-OCCURRENCE AT TABLE LEVEL levno WAS ADDED TO PAGE act-key-1 POINTING TO NEXT-TABLE IN PAGE act-key-2 WITH NO CORRESPONDING CHANGE OF A BACKWARD POINTER IN THE TABLE CHAIN. CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue-1 rsq-1
G1100	IN THE OVERFLOW CHAIN OF A DUPLICATE-TABLE WITH MAIN LEVEL act-key-1 DBTT-COL col-no A BACKWARD POINTER TO PAGE act-key-2 WAS ADDED TO PAGE act-key-3 WITH NO CORRESPONDING CHANGE IN THE PREDECESSOR. CONTENT OF RSQ: rsq-1
G1101	IN THE OVERFLOW CHAIN OF A DUPLICATE-TABLE WITH MAIN LEVEL act-key-1 DBTT-COL col-no A FORWARD POINTER TO PAGE act-key-3 WAS ADDED TO PAGE act-key-2. CONTENT OF RSQ: rsq-2 Meaning In the overflow chain of the duplicates table with the main level in page act-key-1 and DBTT column number col-no, the highest RSQ value rsq-2 of the duplicates table in page act-key-2 is not smaller than the lowest RSQ value rsq-1 of successor page act-key-3 of the duplicates table.