Nexus220 Database Maintenance using the Database Archive Utility

How to Archive Transactions

Database Archive Utility


Introduction


This Utility lets you archive transactions (Normal, Status and Alarms), placing the transactions in a separate archived Database. We recommend that you run the Database Archive Utility on a regular basis. Running the Utility regularly keeps your Database below the maximum recommended database size of 2 GB.

This action has the following major benefits:

  • Manages the size of the Database, freeing up space on the PC.
  • Keeps a cleaner, uncluttered Database.

Keeps Database performance at optimum speed.

Opening and Using the Database Archive Utility

1.  In the PC where Nexus220 software is running go to C:\Nexus220\Bin\Database Archive.
2.  Enter your Username (SYSDBA) and Password (masterkey).



Select the Archive Date


NOTE: This is the end date for the archive. Your newly archived database will therefore contain all transactions for this date and earlier.

 

1.  In the Database Archive Utility dialog, from the Archive Date group, click the Change button.
2.  In the calendar dialog, click on the Month drop-down list and select the desired month from the list.
3.  Click the Year drop-down list and select the year from the list.
4.  From the grid, select the day number.


Confirm the Archiving Options

1.  In the Database Archive Utility dialog, click on the Options button.
2.  In the Archiving Options dialog, click either the Archive or Delete radio button for each of the       named transaction types.


NOTE: If you select the delete option, confirm the deletion in the Delete Transactions dialog, by clicking on the OK button. After confirmation, the Archiving Options dialog closes automatically.

 


3. Click on the OK button.


Archive the Transactions
1. In the Database Archive Utility dialog, click on the Archive button.
2. In the Archiving Options dialog, confirm the archiving details by clicking on the OK button.
3. In the Archive Complete dialog, click the OK button.