User guide

C-2 EXTREMEWARE ENTERPRISE MANAGER INSTALLATION AND USER GUIDE
DATABASE UTILITIES
THE VALIDATION UTILITY
The Validation utility validates all indexes and keys on some or all of the tables in the
database. Access the Validation utility from the MSDOS or Solaris command line using
the dbvalid command. This convention also allows incorporation into batch or
command files.
USING THE DBVALID COMMAND-LINE UTILITY
To validate the ExtremeWare Enterprise Manager database running under Windows NT,
use the command:
< install_dir >\database\dbvalid -c “uid=dba;pwd=sql;dbf=< install_dir >\basecamp.db”
Under Solaris, use the command:
< install_dir >/database/dbvalid -c “uid=dba;pwd=sql;dbf=< install_dir >/basecamp.db”
This example assumes a database user ID of dba, with password sql. These are the
defaults used when the database server is installed through the ExtremeWare Enterprise
Manager installation process. If you have changed your database user ID and password,
substitute your actual user ID and password in the command.
<
install_dir > is the directory where the Enterprise Manager software is installed.
Substitute the actual directory name in the command.
This operation should report no errors. If there are errors, the system should be stopped
and a backup database copied into place. See “Installing a Backup Database” later in
this appendix. If there are no backups, the Enterprise Manager software will need to be
re-installed.
Syntax: dbvalid [switches]
Table C-1: dbvalid Command Switches
Switch Description
-c “keyword=value; ...” Supply database connection
parameters