company logo

CheckDB - Check Database Consistency

Requirements: section in ini-file of executing process

The DBCheck process works similar as the CheckDB utility. It allows checking database consistency and returns a list with database problems. DBCheck requires exclusive access to the database.

The process requires a database definition in a section (section) of the application or of the ini-file passed to the process. In order to check a specific extent, a source might be passed (srce).

The following is a short summary of DBCheck parameters and options.

  • -C - check inverse references (I), indexes (X), key values (K) and/or GUIDs (G) - multiple settings allowed
  • -T- check collections (C), reference collection in instances (I) or both (A - default) - select one option, only
  • -R- repair option (check without repair otherwise). Restore deleted instances (-R:U)
  • -W - show warnimgs

Check options are passed via the Parameter key word.

More details are described in CheckDB in Database Utilities.

DBCheck DB|Database=section;

        [ E|Extent=srce; ]

        P|Parameter=[-C:IXGK] [-T:type] [-R] [-W];

Definition: 

section - symbolic name referring to a section name in the ini-file.

srce - source collection to be checked (when not being defined, the complete database will be checked)