Documentation for Axxon PSIM 2.0. Documentation for other versions of PSIM is available too.

Previous page Removing the events from the PROTOCOL table using SQL queries  Compressing the database size Next page


If necessary, you can clear the table with events from the Axxon PSIM database. For example, if the database has become very large.

Attention!

Once you remove the event table, it cannot be undone. We recommend you to create a backup before removal (see Creating the database backup copy).

To remove the events table from the Axxon PSIM database, do the following:

  1. Shut down Axxon PSIM on the server where the database to be cleared is stored.
  2. Launch the SQL Server Management Studio utility and connect to the server. For details, see Viewing Axxon PSIM database.
  3. Go to the folder with tables Databases/Axxon PSIM/Tables.
  4. Delete the PROTOCOL table.
  5. Quit SQL Server Management Studio.
  6. Run the idb.exe utility (Start -> Programs -> Axxon PSIM -> Update database).
  7. Click the Update database button in the utility and wait for the message about the completion of the update (see Interface elements of the idb.exe window).
  8. Close the idb.exe utility with the OK button.

As a result, the event table will be deleted.

  • No labels