Product Information > JADE Database Administration Guide > Chapter 1 - Using the JADE Database Utility > Using the Certify Files Command

Using the Certify Files Command

Use the Certify Files command from the Operation menu or click the Certify Files toolbar button, to perform a read-only check on the integrity of your database files. For details about certifying files, see "Database Certification", in Chapter 3.

To certify database files

  1. Select the Certify Files command from the Operation menu or click the Certify Files toolbar button. The Select Files to Certify dialog, shown in the following diagram, is then displayed.

  2. Select the required database file or files for certification, by performing one of the following actions.

    The selected file names are moved to the Selected files list box.

  3. To remove database files from the Selected files list box, perform one of the following actions.

    The selected file names are moved back to the Database Files list box.

  4. If you want to look for system database files, check the Show System Files check box. (By default, system files are not displayed for selection; that is, user schema files only are displayed when you first access this dialog.)

  5. If you do not want user schemas displayed for selection, uncheck the Show User Schema Files check box. (By default, user schema files are displayed for selection when you first access this dialog.)

  6. When your list of selected files is complete, click the OK button to start the operation. Alternatively, click the Cancel button to abandon your selections.

While the operation is running, a progress dialog is displayed that enables you to monitor the progress of the operation. You can abort the run, by clicking the Cancel button.

When the operation is finished, the progress dialog is closed and the following message is displayed in the running report.

<<Database file certification complete>>

Detailed results of the operation are written to the certify.log file, which you can view by selecting the certify.log command from the View submenu displayed when you select the View Logs command. (For details, see "Viewing Log Files", later in this chapter.)