[SET NAME IS
{ALL[ EXCEPT setname-1,...] | setname-2,...}
[{WITH | WITHOUT} INDEX CHECK]
]
setname
Name of a set of the specified schema;
setname must be located within the specified realm or realms.
ALL
BCHECK checks all sets of the named schema and their owner record type or member record type, or tables contained in the realms to be checked.
ALL EXCEPT setname-1,...
Same meaning as for ALL;
however, BCHECK excludes the listed sets from the check.
setname-2,...
Names of the sets - listed individually - which BCHECK is to check.
WITH INDEX CHECK
Check index values (key value and/or record sequence number or either one of the two, depending on the type of table).
WITH INDEX CHECK refers only to the consistency criteria 5, 6, 7 and 11, and not to the key value check of consistency criteria 8 and 9.
Table checks:
BCHECK checks the index values for correctness of inequality relationships which must exist within the chains of table pages of the same level and between the individual table levels in sort key tables, indexed pointer arrays and indexed lists.
This means that BCHECK performs the following checks:
- For chains of table pages of the same level: whether, in forward chaining (forward pointer), the lowest index value of the successor page is greater than the highest index value of the page in question, and vice-versa for backward chaining (with indexed lists, only for levels > 0)
- For table pages of various levels: whether the index value of a table entry at a level > 0 is always greater than or equal to the greatest index value in the next lowest level of the table to which it points and is less than the smallest index value of the table which follows it (with indexed lists, only for levels > 1)
WITHOUT INDEX CHECK
BCHECK does not check index values
With the SET statement the sets to be checked are specified to BCHECK. For sets, BCHECK checks
the owner/member relationship via the set connection data (SCD)
the chaining of member records in the case of MODE IS CHAIN,
in the case of non-indexed and indexed lists, sort key tables, and non-indexed and indexed pointer arrays:
the table header,
the address chaining of table pages of the same level,
in the case of indexed tables: the pointers between the table pages of various levels and
the references in the lowest level table entries to the records.
For each set that BCHECK checks, it also automatically checks the associated owner record type and member record type without LOCATION CHECK. It is thus only necessary to name these record types in the RECORD statement if it is desired to extend the check depth to the extent of WITH LOCATION CHECK.
The SET statement may be specified as often as desired in any position after the control statements. BCHECK ignores duplicate entries.
Implicit sets, i.e. search keys at record type level and search keys belonging to a set are only checked by BCHECK if this is explicitly requested by the KEY statement.
For index checking (WITH INDEX CHECK), BCHECK sorts the check records even for a summing check.
Index values are only checked by BCHECK in an overall check.
Index checking does not include checking of sort sequences in chains and checking of non-indexed lists.
When a distributable list is checked, all realms in which the records of the associated member record type can reside must be specified.