User's Manual

System Maintenance
Database Maintenance
9
9-7
Database Maintenance
Let’s be honest. Computers and software aren’t bullet proof. Somewhere,
somehow, somebody will find a way to “crash” a program—intentionally or not,
no matter how robust or advanced the system claims to be. To not at least mention
the possibility of having to fix things, somewhat implies that there is no chance of
ever having to fix things. To not provide a few simple tools to help you fix things
would be careless.
Discussed in this section are the following tools, which are only available to the
Admin:
• Database Diagnostics
• Rebuilding Indexes
One instance where you may need to use these tools is following a power failure
while DPC/TRACK was running. (Obviously, DPC/TRACK itself wouldn’t be to
blame for a power outage, but its future performance could be affected by such an
event, as could any of your programs, for that matter.)
Database Diagnostics
DPC/TRACK’s Database Diagnostics tool analyzes the integrity of your database
files and checks for potential problems. Because of this tool’s ability to check for
potential problems, there’s certainly no harm in using this tool on a weekly basis
as a preventative maintenance measure. You may want to do this at the end of the
work day.
To initiate Database Diagnostics, do the following:
1. Select the System Setup button on the Main Menu to access the System
Setup screen.
2. Select the Database Diagnostics button.
As the diagnostics proceed, you will see a status bar indicating the relative
progress of the diagnostic session. If all goes well, you will see a screen stating
that your files passed diagnostics.
3. Select the OK button.
4. Select the Main Menu button to return to the Main Menu.
In the extremely unlikely event that you receive a screen different than that shown
above, you should contact Fluke.