Verifying Databases
The Verify Database operation lets you verify the integrity of a database and repair certain table-related problems.
You can verify one or more databases by specifying an operation, and then choosing an appropriate scope and mode for that operation. Operations include:
• Checking specified tables for inconsistencies and recommending ways to repair them
• Checking database system catalogs for inconsistencies and recommending ways to repair them
• Purging temporary tables, which can be left on the disk inadvertently when the system does not have time to shut down in an orderly fashion (for example, if the machine is rebooted or stops due to power loss)
• Purging expired tables
• Dropping tables that cannot be dropped in the normal manner (for example, if the underlying disk file for the table was deleted at the operating system level) by removing all references to them from the database system catalogs
• Checking the specified databases to determine if they can be and indicates whether the user can connect to the database accessed
In Director and VDBA, use the Verify Database dialog. For details, see online help.
You can also accomplish these tasks using the verifydb system command. For more information, see the Command Reference Guide.
To use the verify database operation, you must be the DBA for all the databases you want to verify, or a user with the security or the operator privilege.