Using the NetBackup Database Administration utility on UNIX
The NetBackup Database Administration utility is a standalone application (dbadm) and is installed in the following location:
/usr/openv/db/bin
To use the NetBackup Database Administration utility, you must be an administrator with root user privileges.
When you start the NetBackup Database Administration utility, enter the DBA password. The password is set to a randomly generated password upon installation. Use the nbdb_admin command to change it to a known password if you have not done so already.
Enter y to change the password or n to proceed without changing the password.
After you log on, the NetBackup Database Administration utility displays the following information about the current database:
Table: NetBackup Database Administration utility properties
Property | Description |
|---|---|
Selected database | The selected database: NBDB or BMRDB |
Status | The status of the selected database: UP or DOWN |
Consistency | The validation state of the selected database: OK, NOT_OK, or DOWN This information can also be obtained running the following command: nbdb_admin -validate Note: To perform a full database validation, shut down NetBackup and start only the database service. |
Space Utilization | Space Utilization is a measure of the amount of used space as a percentage of the file system space allocated for the database. When the NBDB or the BMRDB databases are initially created, extra space is allocated so that contiguous space is available as needed. As a result, a low Space Utilization is a positive indication unless the database is very large and disk space is in short supply. |
The initial screen also displays the following Database Administration main menu:
Table: Database Administration main menu options
Option | Description |
|---|---|
Select/Restart Database and Change Password | This option displays the menu where you can select a database to start or stop, and to change database passwords. |
Database Space and Memory Management | This option displays the menu where you can perform the following actions:
|
Transaction Log Management | This option displays the menu where you can truncate the transaction log of the database. You can also change the database's transaction log mode. |
Database Validation Check and Rebuild | This option displays the menu where you can validate and rebuild the selected database. |
Move Database | This option displays the menu where you can change the location of the database files. You can also split the files into multiple directories. |
Unload Database | This option displays the menu where you can unload either the schema or the schema and data from the database. |
Backup and Restore Database | This option displays the menu where you can choose the backup and restore options for the database. |
Refresh Database Status | This option refreshes the Status, Consistency, and Space Utilization in the main menu. |
Online Help is available from all screens by selecting the h option from the main menu.
More Information
Changing the NetBackup database password
About the Select/Restart Database and Change Password menu options
About the Database Space and Memory Management menu options
About the Database Validation Check and Rebuild menu options
About the Move Database menu options