The JADE Database Utility
The JADE Database utility is a single user offline interface for initiating database maintenance functions. You can:
-
Backup your database and journal files offline
-
Restore a database and journal files from backup
-
Check the integrity and efficiency of your JADE database files, including the compact operation of selected database files
-
Compact your database files to reclaim deleted object space
-
Verify checksums
-
Allocate the initial file size and the extent of file growth
-
Initiate roll-forward recovery
To run the offline JADE Database utility, you must have exclusive (that is, single user) access to the database files. For details about online single user or multiuser database administration, see Chapter 2.
The JADE Database utility always has two distinct views: a Database View that is used to display the progress of database operations and a Log File View that is used to display the output of a selected activity message log. Each of these views has a different top-level menu, which is determined by the selected view.
You can use the Interrupt User command in the JADE Monitor Users view to interrupt a database operation. This action cancels (that is, performs a user abort action of) an in-progress file certify, file compact, file reindex, file freespace evaluate, file usage analysis, make file partitioned, and move instances database operations, as well as in-progress reorganizations.
For details about the parameters that provide advanced diagnostic capabilities when performing certify and freespace evaluation operations, see "
