Extreme Networks EPICenter 4.1, Software Installation Manual

Page: 518 / 546

518 EPICenter Software Installation and User Guide
EPICenter Backup
Database Utilities
Sybase database validation and backup utilities are shipped with the EPICenter software.
The Validation utility validates all indexes and keys on some or all of the tables in the database. The
Validation utility scans the entire table and looks up each record in every index and key defined on the
table. This utility can be used in combination with regular backups to give you confidence in the
security of the data in your database.
The Backup utility makes a backup copy of all data in the database, except for user names and
passwords, which are kept in separate files. Backing up your database regularly will ensure that you
will not need to re-enter or recreate all the switch, VLAN, Topology, and Alarm information in the event
that the database is corrupted or destroyed.
Both database utilities are found in the
<install_dir>\database
directory. <
install_dir
> is the
directory where you installed the EPICenter software. Substitute the name of the actual directory for
<
install_dir
> when you run these commands.
NOTE
In the Solaris environment, you must ensure that the EPICenter database path is set in the
LD_LIBRARY_PATH environment variable. This should be set to
< install_dir >/database
where
< install_dir >
is the root directory of the EPICenter install, for example /
opt/extreme/epc4_1.
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 MS DOS 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 EPICenter database running under Windows, use the command:
< install_dir >\database\dbvalid -c
“uid=dba;pwd=sql;eng=EPIC41;dbf=< install_dir >\basecamp.db”
Under Solaris, use the command:
< install_dir >/database/dbvalid -c
“uid=dba;pwd=sql;eng=EPIC41;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 EPICenter 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 EPICenter 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” on page 520. If there are no backups, the
EPICenter software must be re-installed.