Use Database consistency check to enable consistency checking for all record and index blocks in the entire database. When enabled, this option applies consistency checks to all index blocks and record blocks for record and index write operations.
Database consistency check validates a block is still physically correct after an operation has been performed. For example, after an index key is inserted into an index block, the consistency check validates that the block still laid out correctly.
You can limit the scope of consistency checking by specifying one area with
Areaconsistency check (-AreaCheck), one table with
Table consistency check (-TableCheck), or one index with
Index consistency check (-IndexCheck).
Database consistency checking can be enabled or disabled while your database is online with PROMON. See
Enable/disable block level consistency check for more information.
Database consistency check can be enabled for a single user client or for any offline utility. If the utility is read-only, such as DBANALYS, the -DbCheck parameter is ignored. Online utilities determine whether or not to perform database consistency checking during execution based on the use of -DbCheck at broker startup or by the enablement/disablement of the database consistency checking in PROMON.