Selecting criteria for the global consistency check (TYPE)

---

[TYPE IS {ALL [EXCEPT type-no-1][,type-no-2]...] | 0  | type-no-1][,type-no-2]...}]

---

ALL     

BCHECK checks under all consistency criteria.

type-no

Number of consistency criterion (see below) type-no=1...11

ALL EXCEPT type-no-1[,type-no-2]...

BCHECK checks all consistency criteria other than those listed after EXCEPT.

0            

BCHECK checks only locally, i.e. within one page. Related check objects in other pages are not checked.

type-no-1[,type-no-2]...

BCHECK checks only under the given consistency criteria.

Default value:

ALL

BCHECK recognizes the following consistency criteria:

type-no	Consistency criterion
1	Correct referencing of record or top/first table occurrence by Act-key in DBTT column
2	Correct chaining of records, including owner record, in a MODE IS CHAIN set
3	Correct chaining of records, including owner record, in a MODE IS CHAIN LINKED TO PRIOR set
4	Correct chaining between first and last table occurrences at level 0
5	Correct chaining of table occurrences between levels
6	Correct chaining of table occurrences between levels in terms of index values
7	Correct chaining of table occurrences within one level
8	Correct referencing of records by level 0 table entries and key values in table and record match
9	Correct referencing of records by indirect CALC table entries and key values in table and record match
10	Correct chaining in CALC table overflow chain
11	Correct chaining in duplicates table overflow chain

Table 9: BCHECK consistency criteria

The table below shows which consistency criteria are checked for the various check objects.

BCHECK statement

Type

Consistency criterion

0 1

0 2

0 3

0 4

0 5

0 6

0 7

0 8

0 9

1 0

1 1

RECORD

WITH LOCATION CHECK or WITH KEYVALUE CHECK

Not-CALC

X

Direct-CALC

X

X

Indirect-CALC

X

X

X

WITHOUT LOCATION ..

All

SET

WITH INDEX CHECK

Table

X

X

X

X

X

X

WITHOUT INDEX CHECK

Table

X

X

X

X

X

CHAIN

X

CHAIN PRIOR

X

SYSTEM set CHAIN

X

X

SYSTEM set CH-PR

X

X

KEY

WITH INDEX CHECK

Table

X

X

X

X

X

X

Duplicates table

X

X

X

X

X

X

X

WITHOUT INDEX CHECK

Table

X

X

X

X

X

Duplicates table

X

X

X

X

X

X

Indirect-CALC

X

X

Table 10: Combinations of check objects and consistency criteria

The specification “ALL” is recommended in all cases. Only in this way is it guaranteed that the check will be complete.
BCHECK ignores unavailable DB structures even if the corresponding consistency criteria are specified. Performance is therefore not improved by omitting these criteria.