Using Database Operational Commands

Use the Operation menu in the Jade Database Utility window to perform operational activities on your database. The Operation menu is displayed only in the Database View.

The JADE Database utility Operation menu commands are listed in the following table.

Command	For details, see…	Description
Certify Files	Using the Certify Files Command	Checks physical integrity of database files
Compact Files	Using the Compact Files Command	Compacts the database files based on indexes
Evaluate Free Space	Using the Evaluate Free Space Command	Evaluates the amount of free-space in a file
Delete Files	Using the Delete Files Command	Deletes database files
Reindex Files	Using the Reindex Files Command	Reindexes database files to repair damaged file indexes or to perform free-space garbage collection serially
Reset Timestamps	Using the Reset Timestamps Command	Resets database timestamps
Verify Checksums	Using the Verify Checksums Command	Performs a checksum analysis of your backed-up database files or your restored system to verify that the files have not been corrupted by a hardware or environmental problem during the backup or restore process
Set File Attributes	Using the Set File Attributes Command	Sets the initial file size and the extent of file growth for selected files
Backup Locations	Using the Backup Locations Command	Enables you to add or change logical backup destinations
Backup Database	Using the Backup Database Command	Backs up all or selected database files offline
Restore Database	Using the Restore Database Command	Provides a submenu that enables you to restore your database files from a JADE online or offline backup and performs roll-forward recovery or restore your database files from a JADE online or offline backup with no recovery
Initiate Recovery	Using the Initiate Recovery Command	Initiates the recovery of your database
Backup Journals	Using the Backup Journals Command	Backs up a selected journal offline
Restore Journals	Using the Restore Journals Command	Restores a journal from backup
Verify Journals	Using the Verify Journals Command	Checks the integrity of your database journal files
Dump Journals	Using the Dump Journals Command	Produces a formatted database journal files
Journaling Rates	Producing Journaling Rates Reports	Produces journaling rates text file and CSV file reports
Production Mode	Using the Production Mode Command	Sets or unsets production mode

If the SuppressDialogs parameter in the [PersistentDb] section of your JADE initialization file is set to false (the default) and the database encounters a resource exception during a database operation (for example, out of disk, missing files, or allow file replace message), a message is displayed advising you of this. For example, if the backup process has insufficient disk space to complete the operation, the name of the file and the required amount of disk space are displayed, to enable you to free up disk space before continuing with the backup of that file, if required. If this parameter is set to true, no message is displayed and an error is returned which is output to your message log file.