About the Database Validation Check and Rebuild menu options

The Database Validation Check and Rebuild option lets you validate and rebuild the currently selected database.

The Database Validation Check and Rebuild menu contains the following options.

Table: Database Validation Check and Rebuild menu options

Option	Description
Standard Validation	This option lets you validate the indexes and keys on all of the tables in the database. Each table is scanned. For each row, a check is made that it exists in the appropriate indexes. The number of rows in the table must match the number of entries in the index. This option is equivalent to the command nbdb_admin -validate.
Full Validation	This option performs the same checks as the Standard Validation option. In addition, Full validation ensures that every row that is referenced in each index exists in the corresponding table. For foreign key indexes, it also ensures that the corresponding row exists in the primary table. This option is equivalent to the command nbdb_admin -validate -full. Note: To perform a full database validation, shut down NetBackup and start only the database service. If any validation errors are reported, perform the following tasks: Shut down NetBackup (all daemons and services). Start only the SQL Anywhere database server (NB_dbsrv, the NetBackup Relational Database Manager). Repeat the validation check using this tool or the nbdb_admin command line utility. If validation errors persist, contact Veritas customer support. The administrator may be asked to rebuild the database using the Database Rebuild option or the nbdb_unload command line utility.
Database Rebuild	This option lets you rebuild the database. This menu option is equivalent to the command nbdb_unload -rebuild. A Database Rebuild results in a complete unload and reload of the database. A new database with all of the same options is built in place. A Database Rebuild may be required if Database Validation errors are reported using the Standard or Full Validation options. During a Database Rebuild, all NetBackup operations are suspended. When you select this option, a message appears which recommends that you exit and create a backup using the Backup Database option before you rebuild the database. You then have the choice of whether to continue or not.

Option

Description

Standard Validation

This option lets you validate the indexes and keys on all of the tables in the database. Each table is scanned. For each row, a check is made that it exists in the appropriate indexes. The number of rows in the table must match the number of entries in the index.

This option is equivalent to the command nbdb_admin -validate.

Full Validation

This option performs the same checks as the Standard Validation option. In addition, Full validation ensures that every row that is referenced in each index exists in the corresponding table. For foreign key indexes, it also ensures that the corresponding row exists in the primary table. This option is equivalent to the command nbdb_admin -validate -full.

Note:

To perform a full database validation, shut down NetBackup and start only the database service.

If any validation errors are reported, perform the following tasks:

Shut down NetBackup (all daemons and services).
Start only the SQL Anywhere database server (NB_dbsrv, the NetBackup Relational Database Manager).
Repeat the validation check using this tool or the nbdb_admin command line utility.

If validation errors persist, contact Veritas customer support. The administrator may be asked to rebuild the database using the Database Rebuild option or the nbdb_unload command line utility.

Database Rebuild

This option lets you rebuild the database. This menu option is equivalent to the command nbdb_unload -rebuild. A Database Rebuild results in a complete unload and reload of the database. A new database with all of the same options is built in place. A Database Rebuild may be required if Database Validation errors are reported using the Standard or Full Validation options.

During a Database Rebuild, all NetBackup operations are suspended.

When you select this option, a message appears which recommends that you exit and create a backup using the Backup Database option before you rebuild the database. You then have the choice of whether to continue or not.

More Information

About the Backup and Restore Database menu options

Using the NetBackup Database Administration utility on UNIX

About the Database Validation Check and Rebuild menu options

Feedback

Feedback