Rockwell Automation Emonitor with a Gupta Multi-User Database - Manual (Page 34)

I NSTALLING E MONITOR S OFTWARE WITH A G UPTA SQLB ASE M ULTI -U SER D ATABASE
30
• •
•
•
•
Checking the integrity of your database
A database is a file, or set of files, stored on your computer. In rare instances, a database
can be damaged or corrupted. If this happens, you may not know about it until you
attempt to recall information from the damaged part of the database. In some cases, you
may not discover the damage for days, weeks, or months.
For this reason, it is important that you regularly check the integrity of your databases, for
both the Entek and the Econfig databases.
1. If you are using a network version of Emonitor, make sure that all users are logged out
of Emonitor, and that no one is accessing the database with SQLTalk or another utility.
2. Start SQLTalk as described in Using SQLTalk Interactive on page 29.
3. In the Input Window (the top pane), type the following, including the semicolon:
check database;
4. Press Shift+F2 to execute the command, or click Execute Command from the
Session menu. If the check is successful, SQLTalk displays the message:
DATABASE CHECKED
If any other message appears, your database may be corrupt. Contact Customer
Support immediately for assistance. Run this command on both the Entek and the
Econfig databases.
Speeding up database access
You can also use SQLTalk Interactive to speed up database access by optimizing the
database. To do so, follow these steps.
1. If you are using a network version of Emonitor, make sure that all users are logged out
of Emonitor, and that no one is accessing the database with SQLTalk or another utility.
2. Start SQLTalk and connect to the Entek database. See Using SQLTalk Interactive on
page 29.
3. In the Input Window (the top pane), type the following, including the semicolon:
update statistics on database;
4. Press Shift+F2 to execute the command, or click Execute Command from the
Session menu. If the check is successful, SQLTalk displays a message similar to this
one depending on the number of rows in your database:
STATISTICS UPDATED ON 44,410 ROWS