To
diagnose and repair a database :
Select Diagnose Database from the main console or the Wizards menu. The Welcome to the Database Repair Wizard window appears.

Click the Next button. The Choose a Database window appears.

Select a database from the Name menu.
Enter the system administrator's name in the User name field.
Enter the system administrator's password in the Password field.
To enable automatic database repair check the Repair automatically check box.
Click the Next button. The Check Basic System Table window appears.

A check mark will appear in the Status field for each system table that is functioning normally. An X will appear in the Status field if there is a problem. A message will also appear in the corresponding Message field.
Note:If any check operation fails in this step, the wizard will not be able to continue.
Click the Next button. The Select Tables to Diagnose window appears.

Select a table to diagnose by checking the include box in the appropriate row. To select all tables click the All button.
Click the Next button.
The Checking Selected Tables' Storage window will appear, displaying the tablespaces containing the selected table. If errors are found, the Repair Option dialog box will appear.

Select Yes to repair the tablespace in question. Select Yes To All to repair all tablespaces with errors. Select No to skip repairing the tablespace in question. Select No To All to skip repairing all tablespaces with errors. Select Detail to see the error message. After all tablespaces have been repaired or skipped the Checking Selected Tables' Storage window will appear.

Click Next or wait 10 seconds, the wizard will automatically go to the next step.
DBMaker will check the remaining system tables and selected user tables. If any errors are found, the Repair Option dialog box will appear.

Select Yes to repair the table in question. Select Yes To All to repair all tables with errors. Select No to skip repairing the table in question. Select No To All to skip repairing all tables with errors. Select Detail to see the error message. Selecting Detail opens the Error dialog box.

Click OK to continue checking tables. After all tables have been checked the Checking Selected Tables window will open

The Checking Selected Tables window displays the status of the tables checked. Click Next to continue. The View Status window will open.
Note: If errors were found and not repaired in a tablespace, then any tables belonging to the broken tablespace cannot be repaired.

The View Status window displays a report of the error check. If any repairs have been performed, the Next button will appear, otherwise the Done button will be displayed. Click Next to continue, or Done to complete the wizard
The Confirm window will open.

The Confirm window allows the database to be rechecked to ensure that repairs were effective. Select Check all to recheck the entire database. Select Check the selected tables to recheck those tables selected initially. Select Check the repaired tables to recheck those tables that errors were found in.
The Diagnose Database Wizard will return to the Checking Selected Tables' Storage window and will check tablespaces according to the choice made in the Confirm window.

Click Next or wait 10 seconds, the wizard will automatically go to the next step. DBMaker will recheck the selected tables.

Click Next. The View Status window will appear a final time.

Related Topics: