Global consistency errors (without index check)

Structure of the message key:

Messages concerning global consistency errors begin with a five-character number, starting with “G” for “Global” and followed by two two-digit numbers:

The first number defines the consistency criterion of the TYPE statement. In the display of consistency criterion 1 a distinction is still made between DBTT column 0 (value 00) and DBTT column > 0 (value 01).

The second number has the following meaning:

00	Existence record from the original database (or of the newer shadow database in the case of an incremental check)
01	Reference record from the original database (or of the newer shadow database in the case of an incremental check)
02	Existence record from the (older) shadow database in the case of an incremental check
03	Reference record from the (older) shadow database in the case of an incremental check

Error messages for global consistency errors which are not related to index checking, start with the header line
THE FOLLOWING CHANGE OF DATABASE IS NOT CONSISTENT

If BCHECK discovers additional entries relevant to an actually consistent global relationship (e.g. two record entries with the same DB key, with the DBTT entry referring to one of the two), BCHECK lists the consistent relationship after the consistency error message. The header line:
THE FOLLOWING DATABASE CHANGES MAY BE CONNECTED WITH THE CONSISTENCY ERROR
is followed in this case by the relevant messages without the additional information:
WITH NO CORRESPONDING CHANGE .....

In the following, all messages for global consistency errors - except for those related to index checking - are explained. Note that messages containing the text
..... DELETED FROM .....
are only output during incremental checking. These messages always relate to the older shadow database; however, the explanations given for them refer to the original (or the newer shadow database) and are only relevant if the older shadow database is consistent. Should the older shadow database not be consistent, the explanation for the corresponding message with ADDED TO applies to the consistency errors in this shadow database.

G0000	FOR DBKEY dbkey THE RECORD-OCCURRENCE WAS ADDED TO PAGE act-key WITH NO CORRESPONDING CHANGE OF A REFERENCE FROM DBTT-COL-0. Meaning The DBTT entry for record dbkey in page act-key is incorrect.
G0001	FOR DBKEY dbkey AN ENTRY WAS ADDED TO DBTT-COL-0 POINTING TO PAGE act-key WITH NO CORRESPONDING CHANGE OF LOCATION OF THE RECORD-OCCURRENCE. Meaning For record dbkey there exists a DBTT entry which refers to page act-key. The record is not contained in this page.
G0002	FOR DBKEY dbkey THE RECORD-OCCURRENCE WAS DELETED FROM PAGE act-key WITH NO CORRESPONDING CHANGE OF A REFERENCE FROM THE DBTT-COL-0. Meaning For record dbkey there exists a DBTT entry which refers to page act-key. The record is not contained in this page.
G0003	FOR DBKEY dbkey AN ENTRY WAS DELETED FROM DBTT-COL-0 POINTING TO PAGE act-key WITH NO CORRESPONDING CHANGE OF LOCATION OF THE RECORD-OCCURRENCE. Meaning The DBTT entry for record dbkey in page act-key is incorrect.
G0100	FOR OWNER-DBKEY dbkey DBTT-COL col-no A TABLE-OCCURRENCE AT TABLE LEVEL {levno | MAX} WAS ADDED TO PAGE act-key-1 (POINTING TO NEXT HIGHER TABLE IN PAGE act-key-2) WITH NO CORRESPONDING CHANGE OF THE REFERENCE IN THE {DBTT | SYSTEM-RECORD}. Meaning In a table which is uniquely identified by owner record dbkey and DBTT column number col-no, the reference from the DBTT or from the anchor record to the table page with level levno in page act-key-1 is missing. For table pages of the highest level, MAX replaces levno.
G0101	FOR OWNER-DBKEY dbkey DBTT-COL col-no AN ENTRY REFERRING TO A TABLE-OCCURRENCE AT LEVEL levno WAS ADDED TO THE {DBTT | SYSTEM-RECORD} POINTING TO A PAGE actkey- 1 (WITH THE REFERENCE COMING FROM PAGE act-key-2) WITH NO CORRESPONDING CHANGEOF LOCATION OF THE TABLE-OCCURRENCE POINTED AT. Meaning In the table which is uniquely identified by owner record dbkey and DBTT column number col-no, a table page of level levno , which is referenced from the DBTT or from the anchor record, is missing from page act-key-1.
G0102	FOR OWNER-DBKEY dbkey DBTT-COL col-no A TABLE-OCCURRENCE AT TABLE LEVEL {levno | MAX} WAS DELETED FROM PAGE act-key-1 (POINTING TO NEXT HIGHER TABLE IN PAGE act-key-2) WITH NO CORRESPONDING CHANGE OF THE  REFERENCE IN THE {DBTT | SYSTEM-RECORD}. Meaning In a table which is uniquely identified by owner record dbkey and DBTT column number col-no, a table page of level levno in page act-key-1, which is referenced from the DBTT or from the anchor record, is missing. For table pages of the highest level, MAX replaces levno.
G0103	FOR OWNER-DBKEY dbkey DBTT-COL col-no AN ENTRY REFERRING TO A TABLE-OCCURRENCE AT LEVEL levno WAS DELETED FROM 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. Meaning In the indexed table which is uniquely identified by owner record dbkey and DBTT column number col-no, the reference from the next higher level (table entry in page act-key-2) to a table page with level levno in page act-key-1 is missing.
G0200
G0300	FOR OWNER-DBKEY dbkey-1 SET-REF setref A RECORD-OCCURRENCE WAS ADDED TO THE OWNER'S SET CHAIN WITH MEMBER-DBKEY dbkey-2 (POINTING TO PRIOR DBKEY dbkey-3) WITH NO CORRESPONDING CHANGE OF A FORWARD POINTER  IN THE SET CHAIN. Meaning In set setref, no reference to record dbkey-2 exists in the set occurrence of owner. For backward chaining, member record dbkey-3 which should have contained the reference is also given.
G0201
G0301	FOR OWNER-DBKEY dbkey-1 SET-REF setref A FORWARD POINTER WAS ADDED TO THE OWNER'S SET CHAIN POINTING TO MEMBER-DBKEY dbkey-2 (FROM DBKEY dbkey-3) WITH NO CORRESPONDING CHANGE OF THE MEMBER-RECORD POINTED AT. Meaning In set setref, there exists in the set occurrence of owner dbkey-1 a reference to record dbkey-2 which is not, however, a member of the chain. For backward chaining, member record dbkey-3 which contains the reference is also given.
G0202
G0302	FOR OWNER-DBKEY dbkey-1 SET-REF setref A RECORD-OCCURRENCE WAS DELETED FROM THE OWNER'S SET CHAIN WITH MEMBER-DBKEY dbkey-2 (POINTING TO PRIOR DBKEY dbkey-3) WITH NO CORRESPONDING CHANGE OF A FORWARD POINTER IN THE SET CHAIN. Meaning In set setref, there exists in the set occurrence of owner dbkey-1 a reference to record dbkey-2 is not, however, a member of the chain. For backward chaining, member record dbkey-3 which contains the reference is also given.
G0203
G0303	FOR OWNER-DBKEY dbkey-1 SET-REF setref A FORWARD POINTER WAS DELETED FROM THE OWNER'S SET CHAIN POINTING TO MEMBER-DBKEY dbkey-2 (FROM DBKEY dbkey-3) WITH NO CORRESPONDING CHANGE OF THE MEMBER-RECORD POINTED AT. Meaning In set setref, no reference to record dbkey-2 exists in the set occurrence of the owner. For backward chaining, member record dbkey-3 which should have contained the reference is also given.
G0400	FOR OWNER-DBKEY dbkey DBTT-COL col-no A LAST TABLE-OCCURRENCE WAS ADDED TO PAGE act-key WITH NO CORRESPONDING CHANGE OF THE REFERENCE IN THE TOP-TABLE. Meaning In the indexed table which is uniquely identified by owner record dbkey and DBTT column number col-no, the reference from the table page of the highest level corresponding to the last table page of the lowest level in page act-key is missing. Or: In the flat table which is uniquely identified by owner record dbkey and DBTT column number col-no, the reference from the first table page corresponding to the last table page (act-key) is missing.
G0401	FOR OWNER-DBKEY dbkey DBTT-COL col-no THE REFERENCE TO THE LAST TABLE WAS ADDED TO THE TOP-TABLE POINTING TO PAGE act-key WITH NO CORRESPONDING CHANGE OF LOCATION OF THE LAST TABLE-OCCURRENCE. Meaning In the indexed table which is uniquely identified by owner record dbkey and DBTT column number col-no, page act-key which is referenced in the table header of the highest level table does not contain the last table page of the lowest level. Or: In the flat table which is uniquely identified by owner record dbkey and DBTT column number col-no, page act-key, which is referenced in the table header of the first page, does not contain the last table page.
G0402	FOR OWNER-DBKEY dbkey DBTT-COL col-no A LAST TABLE-OCCURRENCE WAS DELETED FROM   PAGE act-key WITH NO CORRESPONDING CHANGE OF THE REFERENCE IN THE TOP-TABLE. Meaning In the indexed table which is uniquely identified by owner record dbkey and DBTT column number col-no, page act-key, which is referenced in the table header of the highest level, does not contain the last table page of the lowest level. Or: In the flat table which is uniquely identified by owner record dbkey and DBTT column number col-no, page act-key, which is referenced in the table header of the first page, does not contain the last table page.
G0403	FOR OWNER-DBKEY dbkey DBTT-COL col-no THE REFERENCE TO THE LAST TABLE WAS DELETED FROM THE TOP-TABLE POINTING TO PAGE act-key WITH NO CORRESPONDING CHANGE OF LOCATION OF THE LAST TABLE-OCCURRENCE. Meaning In the indexed table which is uniquely identified by owner record dbkey and DBTT column number col-no, the reference from the table page of the highest level corresponding to the last table page of the lowest level in page act-key is missing. Or: In the flat table which is uniquely identified by owner record dbkey and DBTT column number col-no, the reference from the first table page corresponding to the last table page (act-key) is missing.
G0500	FOR OWNER-DBKEY dbkey DBTT-COL col-no A TABLE-OCCURRENCE AT TABLE LEVEL {levno | MAX} WAS ADDED TO PAGE act-key-1 (POINTING TO NEXT HIGHER TABLE IN PAGE act-key-2) WITH NO CORRESPONDING CHANGE OF THE REFERENCE IN THE TABLE AT NEXT HIGHER LEVEL. Meaning In an indexed table which is uniquely identified by owner record dbkey and DBTT column number col-no, the reference from the next higher level (table entry in page act-key-2) to the table page with level levno in page act-key-1 is missing.  For table pages of the highest level, MAX replaces levno.
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 actkey-1 (WITH THE REFERENCE COMING  FROM PAGE act-key-2) WITH NO CORRESPONDING CHANGE OF LOCATION OF THE TABLE-OCCURRENCE POINTED AT. Meaning In the indexed table which is uniquely identified by owner record dbkey and DBTT column number col-no, a table page of level levno , which is referenced from the next higher level (table entry in page act-key-2), is missing from page actkey-1.
G0502	FOR OWNER-DBKEY dbkey DBTT-COL col-no A TABLE-OCCURRENCE AT TABLE LEVEL {levno | MAX} WAS DELETED FROM PAGE act-key-1 (POINTING TO NEXT HIGHER TABLE IN PAGE act-key-2) WITH NO CORRESPONDING  CHANGE OF THE REFERENCE IN THE TABLE AT NEXT HIGHER LEVEL. Meaning In an indexed table which is uniquely identified by owner record dbkey and DBTT column number col-no, a table page of level levno in page act-key-1, which is referenced from the next higher level (table entry in page act-key-2), is missing. For table pages of the highest level, MAX replaces levno.
G0503	FOR OWNER-DBKEY dbkey DBTT-COL col-no AN ENTRY REFERRING TO A TABLE-OCCURRENCE AT LEVEL levno WAS DELETED FROM THE {DBTT | SYSTEM-RECORD} 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. Meaning In the table which is uniquely identified by owner record dbkey and DBTT column number col-no, the reference from the DBTT or from the anchor record to a table page with level levno in page act-key-1 is missing.
G0700	FOR OWNER-DBKEY dbkey DBTT-COL col-no A TABLE-OCCURRENCE AT TABLE LEVEL levno WAS ADDED TO PAGE act-key-1 POINTING TO PRIOR TABLE IN PAGE act-key-2 WITH NO CORRESPONDING CHANGE OF A FORWARD POINTER  IN THE TABLE CHAIN. Meaning In the table which is uniquely identified by owner record dbkey and DBTT column number col-no, the forward pointer from page act-key-2 corresponding to the backward pointer in page act-key-1 on the same level levno is missing.
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. Meaning In the table which is uniquely identified by owner record dbkey and DBTT column number col-no, the backward pointer from page act-key-2 corresponding to the forward pointer in page act-key-1 on the same level levno is missing.
G0702	FOR OWNER-DBKEY dbkey DBTT-COL col-no A TABLE-OCCURRENCE AT TABLE LEVEL levno WAS DELETED FROM PAGE act-key-1 POINTING TO PRIOR TABLE IN PAGE act-key-2 WITH NO CORRESPONDING CHANGE OF A FORWARD POINTER  IN THE TABLE CHAIN. Meaning In the table which is uniquely identified by owner record dbkey and DBTT column number col-no, the backward pointer in page act-key-1 corresponding to the forward pointer in page act-key-2 on the same level levno is missing.
G0703	FOR OWNER-DBKEY dbkey DBTT-COL col-no A TABLE-OCCURRENCE AT TABLE LEVEL levno WAS DELETED FROM 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. Meaning In the table which is uniquely identified by owner record dbkey and DBTT column number col-no, the forward pointer from page act-key-1 corresponding to the backward pointer in page act-key-2 on the same level levno is missing.
G0800	FOR OWNER-DBKEY dbkey-1 DBTT-COL col-no THE MEMBERSHIP-INDICATOR WAS ADDED TO THE RECORD WITH MEMBER-DBKEY dbkey-2 (LOCATED IN PAGE act-key) WITH NO CORRESPONDING CHANGE OF A POINTER IN SOME BOTTOM TABLE. CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue. Meaning In the SEARCH key or sort key table which is determined unambiguously by owner record dbkey-1 and the DBTT column number col-no a table entry at level 0 exists for record dbkey-2 although this record is not a member of the associated set.
G0801	FOR OWNER-DBKEY dbkey-1 DBTT-COL col-no AN ENTRY WAS ADDED TO A BOTTOM TABLE POINTING TO MEMBER-RECORD WITH DBKEY dbkey-2 (WITH THE TABLE BEING LOCATED IN PAGE act-key) WITH NO CORRESPONDING CHANGE OF THE RECORD- OCCURRENCE. CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue. Meaning In the search key or sort key table which is uniquely identified by owner record dbkey-1 and DBTT column number col-no, there exists for record dbkey-2 a table entry at level 0 (stored in page act-key), although this record is not a member of the corresponding set.
G0802	FOR OWNER-DBKEY dbkey-1 DBTT-COL col-no THE MEMBERSHIP-INDICATOR WAS DELETED FROM THE RECORD WITH MEMBER-DBKEY dbkey-2 (LOCATED IN PAGE act-key) WITH NO CORRESPONDING CHANGE OF A POINTER IN SOME BOTTOM TABLE. CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue. Meaning In the search key or sort key table which is uniquely identified by owner record dbkey-1 and DBTT column number col-no, the table entry at level 0 corresponding to member record dbkey-2 (stored in page act-key) is missing.
G0803	FOR OWNER-DBKEY dbkey-1 DBTT-COL col-no AN ENTRY WAS DELETED FROM A BOTTOM TABLE POINTING TO A MEMBER-RECORD WITH dbkey-2 (WITH THE TABLE BEING LOCATED IN PAGE act-key) WITH NO CORRESPONDING CHANGE OF THE RECORD- OCCURRENCE.CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue. Meaning In the search key or sort key table which is uniquely identified by owner record dbkey-1 and DBTT column number col-no, the table entry at level 0 (stored in the page act-key) corresponding to member record dbkey-2 is missing.
G0900	A RECORD-OCCURRENCE WITH RSQ rsq WHICH HAS AN (INDIRECT) CALC-(SEARCH-)KEY WITH KEYLENGTH key-length WAS ADDED TO THE PAGE act-key WITH NO CORRESPONDING CHANGE IN THE CALC-TABLE. CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue Meaning In the CALC table of the indirect CALC key or CALC-SEARCH key with key length key-length, the reference to the record with record sequence number rsq stored in page act-key is missing.
G0901	FOR AN (INDIRECT) CALC-(SEARCH-)KEY WITH KEYLENGTH key-length AN ENTRY WITH RSQ rsq WAS ADDED TO A CALC TABLE AT PAGE act-key OF THE DATABASE WITH NO CORRESPONDING CHANGE IN THE RELATED RECORD-OCCURRENCE. CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue Meaning In the CALC table of the indirect CALC key or CALC-SEARCH key with key length key-length, the entry in page act-key with record sequence number rsq refers to a non-existent record.
G0902	A RECORD-OCCURRENCE WITH RSQ rsq WHICH HAS AN (INDIRECT) CALC-(SEARCH-)KEY WITH KEYLENGTH key-length WAS DELETED FROM THE PAGE act-key WITH NO CORRESPONDING CHANGE IN THE CALC TABLE. CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue Meaning In the CALC table of the indirect CALC key or CALC-SEARCH key with key length key-length, the entry with record sequence number rsq refers to a non-existent record.
G0903	FOR AN (INDIRECT) CALC-(SEARCH-)KEY WITH KEYLENGTH key-length AN ENTRY WITH RSQ rsq WAS DELETED FROM A CALC TABLE AT PAGE act-key OF THE DATABASE WITH NO CORRESPONDING CHANGE IN THE RELATED RECORD-OCCURRENCE.  CONTENT OF KEYVALUE OR TABLE ENTRY: keyvalue Meaning In the CALC table of the indirect CALC key or CALC-SEARCH key with key length key-length, the reference to the stored record with record sequence number rsq is missing.
G1000	IN A HASH OVERFLOW CHAIN FOR KEYLENGTH key-length A POINTER TO PRIOR OVERFLOW PAGE act-key-1 WAS ADDED TO PAGE actkey-2 WITH NO CORRESPONDING CHANGE OF THE FORWARD POINTER IN THE OVERFLOW CHAIN. Meaning In a hash overflow chain of the CALC key with key length key-length, there exists in page act-key-2 a backward pointer to page act-key-1 with no corresponding forward pointer in the chain of overflow pages.
G1001	IN A HASH OVERFLOW CHAIN FOR KEYLENGTH key-length A POINTER TO NEXT OVERFLOW PAGE act-key-1 WAS ADDED TO PAGE act-key-2 WITH NO CORRESPONDING CHANGE OF THE BACKWARD POINTER IN THE OVERFLOW CHAIN. Meaning In a hash overflow chain of the CALC key with key length key-length, there exists in page act-key-2 a forward pointer to page act-key-1 with no corresponding backward pointer in the chain of overflow pages.
G1002	IN A HASH OVERFLOW CHAIN FOR KEYLENGTH key-length A POINTER TO PRIOR OVERFLOW PAGE act-key-1 WAS DELETED FROM PAGE act-key-2 WITH NO CORRESPONDING CHANGE OF THE FORWARD POINTER IN THE OVERFLOW CHAIN. Meaning In a hash overflow chain of the CALC key with key length key-length, there exists in page act-key-1 a forward pointer to page act-key-2 with no corresponding backward pointer in the chain of overflow pages.
G1003	IN A HASH OVERFLOW CHAIN FOR KEYLENGTH key-length A POINTER TO NEXT OVERFLOW PAGE act-key-1 WAS DELETED FROM PAGE act-key-2 WITH NO CORRESPONDING CHANGE OF THE BACKWARD POINTER IN THE OVERFLOW CHAIN. Meaning In a hash overflow chain of the CALC key with key length key-length, there exists in page act-key-1 a backward pointer to page act-key-2 with no corresponding forward pointer in the chain of overflow pages.
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. Meaning In the overflow chain of a duplicate table with the main level in page act-key-1 and DBTT column number col-no, there exists in page act-key-3 a backward pointer to page act-key-2 with no corresponding forward pointer in the chain of overflow pages.
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-2 WAS ADDED TO PAGE act-key-3 WITH NO CORRESPONDING CHANGE IN THE SUCCESSOR. Meaning In the overflow chain of a duplicate table with the main level in page act-key-1 and DBTT column number col-no, there exists in page act-key-3 a forward pointer to page act-key-2 with no corresponding backward pointer in the chain of overflow pages.
G1102	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 DELETED FROM act-key-3 WITH NO CORRESPONDING CHANGE IN THE PREDECESSOR. Meaning In the overflow chain of a duplicate table with the main level in page act-key-1 and DBTT column number col-no, there exists in page act-key-2 a forward pointer to page act-key-3 with no corresponding backward pointer in the chain of overflow pages.
G1103	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-2 WAS DELETED FROM PAGE act-key-3 WITH NO CORRESPONDING CHANGE IN THE SUCCESSOR. Meaning In the overflow chain of a duplicate table with the main level in page act-key-1 and DBTT column number col-no, there exists in page act-key-2 a backward pointer to page act-key-3 with no corresponding forward pointer in the chain of overflow pages.