nbdb_admin

nbdb_admin — start or stop individual databases and change default password

SYNOPSIS

<nbu_dir_path>nbdb_admin -dba new_password [-backup directory]

<nbu_dir_path>nbdb_admin -start | stop [database_name]

<nbu_dir_path>nbdb_admin [-vxdbms_nb_data directory] [-vxdbms_nb_staging directory] [-vxdbms_nbdb_backup_owner y|n] [-vxdbms_nb_server servername | EMMSERVER] [-auto_start NONE | NBDB | BMRDB]

<nbu_dir_path>nbdb_admin -adjust_server_settings [database_name]

<nbu_dir_path>nbdb_admin -list

<nbu_dir_path>nbdb_admin -reorganize [database_name]

<nbu_dir_path>nbdb_admin -validate [database_name] [-full]

On Windows systems, <nbu_dir_path> is <install_path>\NetBackup\bin\

DESCRIPTION

The nbdb_admin command can be used to start or stop the NetBackup database or the BMR database.

The nbdb_admin command line utility is required 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. Secure SSL is used for encryption, and keys are handled in a consistent manner with the rest of NetBackup. The passwords are encrypted with AES-128-CFB by using the NetBackup private key. The permissions on the file enable it to be read or written only by the root user on UNIX or a Windows administrator.

During installation, the default password of nbusql is used for the NBDB and the 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.

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.

-auto_start NONE | NBDB | BMRDB

These options enable an administrator that runs locally on an Authentication server to add or remove domains within the private Veritas Domain Database. These domains are not accessible from within any operating system. They are meaningful only within Symantec product Authentication and Authorization Service. Use them where a centralized naming authority (such as a PDC/AD or NIS domain) is not available.

-dba new_password [-backup directory]

Enables you to change the default password, nbusql, for the NBDB and the BMRDB databases for all DBA and application accounts.

If the - backup option is used, the new password is saved in the directory specified by directory with the file name nbdbinfo.da. Otherwise, it is saved under the default location with the same file name.

-list

Lists all database files.

-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_namefield. 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.