Name
nbdb_admin — start or stop individual databases and change default password
SYNOPSIS
-dba new_password [-dbn NBDB | NBAZDB] [-backup directory]
-start | stop [database_name]
[-vxdbms_nb_data directory] [-vxdbms_nb_staging directory] [-vxdbms_nb_server servername | [EMMSERVER]
-enable_request_logging [-duration minutes]
-disable_request_logging
-list
-reorganize [database_name]
-update_user_list
-validate [database_name]
-vacuum [database_name]
On UNIX systems, the directory path to this command is /usr/openv/db/bin/
On Windows systems, the directory path to this command is install_path\NetBackup\bin\
DESCRIPTION
The nbdb_admin command can be used to start or stop the NetBackup database (NBDB), the NetBackup Authorization database (NBAZDB), or the Bare Metal Restore database (BMRDB).
The nbdb_admin command line utility can also be used to enable the customer to change the DBA and application passwords. The DBA and application passwords are encrypted and stored in the vxdbms.conf file. The permissions on the file enable the root user on UNIX or a Windows administrator to read or write it.
During installation, a randomly generated password is created for the NBDB, NBAZDB, and BMRDB databases for all DBA and application accounts. The same password is used for the NBDB and the BMRDB DBA and application accounts such as EMM_MAIN. A different randomly generated password is created for the NBAZDB database.
This command can enable and disable a request logging tool that is used to troubleshoot NetBackup database performance issues at the highest database logging level. Use request logging for a problem that has an active support case.
OPTIONS
- -dba new_password [-dbn NBDB | NBAZDB | BMRDB] [-backup directory]
This option changes the existing password for NetBackup databases. The password must be an ASCII string. Non-ASCII characters are not allowed in the password string. Special characters in the password must be escaped according to the rules of the shell. Failing to do so may result in unintended behavior or errors when the command is run. What database passwords are changed depends on the use of the -dbn option.
If -dbn is not specified or if -dbn NBDB is specified, the command changes the password for the NBDB and the BMRDB databases for all DBA and application accounts.
If the -dbn NBAZDB option is specified, the command changes the existing password for the NBAZDB database. The NBAZDB database password is different than the password for the NBDB and the BMRDB databases and application accounts.
If the NBAZDB password is set to the old default password, it is reset to a randomly generated password at the next NetBackup upgrade. The randomly generated password is different than the randomly generated password for the NBDB and the BMRDB databases. If the NBAZDB password is the same as the NBDB password, the NBAZDB password is reset to a randomly generated password at the next NetBackup upgrade.
If the -backup option is used, the new password is saved in the specified directory with the file name
nbdbinfo.dat. Otherwise, it is saved under the default location with the same file name.Caution:
A reset of any database password requires a restart of the NetBackup Web Management Console service.
- -disable_request_logging
Deactivates request logging and removes any request log settings. This option requires that you restart the NetBackup Scale-Out Relational Database Manager service.
- -duration minutes
Disable request logging after the specified time in minutes. Specify 0 to manually disable later.
- -enable_request_logging
Activates request level logging for NBDB at the maximum level for troubleshooting. The overhead of request logging may affect performance and is not recommended for regular use. Request logging for NBDB may be useful only if the customer is experiencing NBDB performance issues and has an active support case.
- -list
Lists all the database tablespaces and configuration files.
- -reorganize database_name
Reorganizes the given database. If no database is specified, the default is to reorganize all databases.
- -start | -stop [database_name]
Starts or stops the database that is identified in the database_name field. You can specify NetBackup database (NBDB), the NetBackup Authorization database (NBAZDB), or the Bare Metal Restore database (BMRDB). The database_name field is optional. The NBDB database is the default for this command.
Note:
Before you take a database offline with the -stop option, stop all services that are running except the NetBackup Scale-Out Relational Database.
- -update_user_list
Synchronizes all accounts in the file
userlist.txtwith the account and password in the NBDB database. Use this option if the account and password information in the pgbouncer'suserlist.txtfile is out of sync with the NetBackup database. If you continue to see connection issues, restart the NetBackup services.
- - vacuum database_name
Performs a vacuum operation on the specified database. If no database is specified, the default is to perform the vacuum operation on all databases.
The vacuum operation reclaims the space that any dead tuples occupy and makes it available for re-use.
- -validate database_name
Validates the indexes and keys on all of the tables in the specified database. If no database name is specified, the option validates all the databases. It scans each table and checks that each row exists in the appropriate indexes. The number of rows in the table must match the number of entries in the index.
The validation checks do not require that all NetBackup activity be suspended. However, the checks may report any transient errors that are a result of transactions that are in progress.
- -vxdbms_nb_data directory
This command updates the VXDBMS_NB_DATA parameter that is stored in the bp.conf file on UNIX systems and in the registry on Windows systems. This parameter contains the main location of the NBDB and the BMRDB databases.
- -vxdbms_nb_server servername | EMMSERVER
Changes the database server name to the given servername or EMMSERVER from
bp.conffile.
- -vxdbms_nb_staging directory
Changes the staging directory from the default to the specified directory. This option saves the information in the
vxdbms.conffile.