About the General tab of the NetBackup Database Administration utility
The General tab contains information about database space utilization. The tab contains tools to let the administrator reorganize fragmented database objects, add free space to the database files, and validate and rebuild the database.
Figure: General tab of the NetBackup Database Administration utility shows the General tab of the Database Administration utility after a user logs on.
Table: General tab options
Option | Description |
|---|
Space Utilization list | Displays the information about used space and free space in pie chart format for the following database system, data, and index files: Free DBspace The amount of free space available. Total DBspace The total amount of space that is allocated for the dbspace. DB Utilization The utilization percentage is the percentage of the Total DBSpace used for data.
When the NBDB or the BMRDB databases are created, extra space is allocated so that contiguous space is available as needed. As a result, a low space utilization percentage is a positive indication unless the database is very large and disk space is in short supply.
|
Details | Use to display information about the selected database table or index file and elect to defragment (reorganize) fragmented files.
Select a database table or an index file in the list and click . Database tables Select one or more tables in the Data (Table) Details dialog box and click . The database table is evaluated for fragmentation and if any fragmentation is detected, it is reorganized. Select one or more database tables to reorganize and then click . Each selected database table is evaluated for fragmentation and if any fragmentation is detected, it is reorganized. Index files Select one or more indexes in the Index Details dialog box and click . Each selected index is evaluated for fragmentation and if any fragmentation is detected, it is reorganized.
Click after defragmenting the files.
|
Add Space | Use to add additional free space to individual dbspaces. Additional free space helps to reduce future fragmentation of the database objects that are stored in the database.
When the relational database is initially created or rebuilt, 25MB of free space is automatically added to the data and the index dbspaces.
Click , then select one of the following amounts to add: A small amount of space to add is 25MB. A medium amount of space to add is 50MB. A large amount of space to add is 100MB.
Click to add the space or Cancel to close the dialog box.
|
Transaction log information | The location and the file size of the transaction log. |
Mirrored log information | The location and the file size of the mirrored log, if one exists. |
Refresh | Displays the most current information. |
| This option automatically determines the database tables and indexes that are fragmented. The option then uses the SQL Anywhere REORGANIZE command to defragment the tables and compress the indexes. To click is equivalent to running the following command:
nbdb_admin.exe -reorganize |
Validation status | This option informs you whether or not the selected database has passed the utility's validation check. |
| This option performs a database validation on all of the database tables and indexes in the selected database.
Choose one of the following validation checks in the Validate Database dialog box: Standard The Standard validation option lets you validate the indexes and keys on all of the tables in the database. Each table is scanned, and 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. The equivalent command is nbdb_admin.exe -validate Full In addition to the Standard validation checks, a 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. The equivalent command is nbdb_admin.exe -validate -full To perform a full database validation, shut down NetBackup and start only the database service.
After a validation check runs, the Results screen lists each database object. Each error is listed next to the database object where it was found. The total number of errors are listed at the end of the list of database objects. If no errors were found, that is indicated.
If any validation errors are reported, perform the following tasks: Shut down NetBackup (all daemons and services). Start only the SQL Anywhere database server (SQLANYs_VERITAS_DB, the NetBackup Relational Database Manager). Click to repeat the validation check or use the nbdb_admin.exe command line utility.
If validation errors persist, contact Veritas customer support. The administrator may be asked to rebuild the database using the option or the nbdb_unload.exe command line utility. |
Rebuild | This option unloads and reloads the database. A new database with all of the same options is built in its place.
A Database Rebuild may be required if validation errors are reported using the Standard or Full validation options using the option.
Before you rebuild the database, Veritas suggests that you create a copy of the database files by performing a backup from the Tools tab. To rebuild the database temporarily suspends NetBackup operations and can take a long time depending on the database size.
The equivalent command is nbdb_unload -rebuild |