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_nbdb_backup_owner y|n] {-vxdbms_nb_server servername | EMMSERVER] [-auto_start NONE | NBDB | BMRDB | NBAZDB]
-adjust_server_settings [database_name]
-enable_request_logging [-persistent] [-duration minutes] [-logfile filename]
-disable_request_logging
-analyze_request_log -logfile filename
-list
-reorganize [database_name]
-validate [database_name] [-full]
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 SyBase database logging level. Use request logging for a problem that has an active support case. An analyze_request_log option reads the request log that the NBDB generates and performs some basic log analysis. Because of the excessive resource usage and general overhead, we do not recommend that you use this tool in a production environment.
OPTIONS
- -adjust_server_settings directory
Adjusts the settings of the given database directory through the Sybase utility. If no database is specified, the default is to adjust all databases.
- -analyze_request_log
Reads the request log generated by the NetBackup database and does some basic analysis. This procedure can cause excessive resource utilization and is not recommended for use on a production environment. Request logging for NBDB may be useful only if the customer is experiencing NBDB performance issues and has an active support case.
- -auto_start NONE | NBDB | BMRDB | NBAZDB
Sets which databases are automatically started when the database server is started. You can specify the NetBackup database (NBDB), the BMR database (BMRDB), or the NetBackup Authorization database (NBAZDB). The database daemon must be stopped and restarted to take effect. Or you can choose not to start any of the databases by using NONE.
- -dba new_password [-dbn NBDB | NBAZDB] [-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. 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 password is set to the old default password (nbusql), it is reset to a randomly generated password at the next NetBackup upgrade.
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 from the
server.conffile. Any change inserver.confrequires that you restart the NetBackup relational database 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 database files.
- -logfile filename
Specifies the absolute path to the log file for NBDB to use. If this option is not present, the absolute path is generated at the default location.
- -persistent
Saves the request logging settings to the
server.conffile so that request logging continues after the NetBackup relational database service (NBDB) is restarted.
- -reorganize database_name
Reorganizes the given database through the Sybase utility. 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 the NBDB database or the BMRDB database. The database_name field is optional. The NBDB database is the default for this command.
Note:
Before you take the database offline with the -stop option, stop all services that are running except SQL Anywhere.
- -validate database_name [-full]
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 -full option performs a full validation of the database or databases. It 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 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_nbdb_backup_owner y|n
This command updates the VXDMS_NBDB_BACKUP_OWNER parameter in the bp.conf file on UNIX systems and in the registry on Windows systems. This command specifies if the master server owns the backup of the databases that are included in the catalog backup. The default for this parameter is yes.
- -vxdbms_nb_server servername | EMMSERVER
Changes the database server name to the given servername or EMMSERVER from bp.conf file.
- -vxdbms_nb_staging directory
Changes the staging directory from the default to the specified directory. This option saves the information in the vxdbms.conf file.