Notifier UniNet 2000, Installation, Operation, And Administration Manual

Page: 103 / 200

103
The Workstation Installation/Operation Manual Version 2 Document 51540 Rev. B1 4/8/02
Section 3.5: System Maintenance
3.5.1 Database Management
There are three main databases that are maintained in a UniNet system. These three databases are:
• History Database - Holds a record of all events and actions that have taken place. The history
database holds a large amount of data and can become the largest of all the database files.
•
Screen Database
- The screen database holds information for the backgrounds, devices, buttons,
etc. for all of the screens and sites on the UniNet network.
• System Database - Contains all workstation configuration parameters, including monitoring and
security profiles as well as printer and I/O buffers.
Backing Up the Databases
Any time editing is completed, it is advised to back up these databases. Backing up after each time databases are
edited insures that there is a backup copy of the latest database file on the computer. In addition, if any changes
are made in the future that need to be undone, the backup can simply be restored.
The
Maintenance, Backup menu provides options to backup all three databases individually, as well as an
option to backup ALL databases (performs the three individual backups).
Backing up the Screen or System database will create a backup file with a .scr extension for the screen db backup,
and .sys for the system db backup. These files can be restored using the Synchronize to External Database features
(discussed below). Backups are stored in the c:\uninet\ws\backup directory.
The History Database Backup function allows the user to back up the current history buffer and create a blank
history buffer. The history buffer may contain an unlimited number of entries but it is recommended to perform a
backup when the history buffer has reached 100,000 events. At this point, a warning dialog will appear stating
the history buffer contains 100,000 events. The system will display a warning dialog for every 100 events thereaf-
ter. The history file can also be backed up automatically using the history backup scheduler. This feature is
selected in the General tab of the System Setup folder under the Workstation Configuration, Options
menu.
After selecting the backup function, the system backs up the current history buffer to a file whose name is the
current date in YYYYMMDD.HIS format (ie. Jan 30, 2001's backup would be 20010130.HIS) and places the file
in c:\uninet\ws\history. If multiple backups are made the same day the file name will include a counter
starting at zero (using the above example, a second backup would be 20010130_00.HIS). The backed-up history
files may be opened using the History Manager or Microsoft Access.
Repairing Damaged Databases
The Maintenance, Database Utilities, Repair menu contains options to repair all three databases. Damage
to the database is caused by software or hardware level corruption of the database file. If some portion of the file
index becomes damaged, the file will be unreadable. If this corruption does not affect the actual entries, or only a
portion, the database is repairable. The repair functions reconstruct the index file, and un-reference any damaged
entries. Use these functions if a database file will not open properly or its information seems damaged.
3.5