Checking the Integrity of the Database Control File

JADE provides the dbcontrolcheck.exe program, which you can use to check for duplicate and invalid entries in the database control file (_control.dat) and inconsistencies between the DbFile instances in the system and the database control file entries.

To check for errors, run the following program (for example, from a command script).

dbControlCheck path=database‑path ini=initialization‑file‑name [server=singleuser|multiuser]

The default value for the server argument is singleuser.

Error 3035 (DB_CERTIFY_ERROR) is returned if errors are found, and these errors are reported to standard output and the jommsg.log file.

The program provides a command that enables you to fix the control file entries and the DbFile instances, where possible. To correct any errors that can be corrected, run the following program.

dbControlCheck path=database-path ini=initialization‑file‑name [server=singleuser|multiuser] applyFixes=true

Zero (0) is returned if the value of the applyFixes arguments is true and no unfixable errors have been found.

If any errors that cannot be corrected are found and your licenses include support, contact your local JADE support center or JADE Support with the log information for additional help.