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