Maintaining Tables for SQL Server - EnterWorks_Process_Exchange_(EPX) - 10.6

EnterWorks EPX Administration

Product type
Software
Portfolio
Verify
Product family
EnterWorks
Product
Precisely EnterWorks > EnterWorks Process Exchange (EPX)
Version
10.6
Language
English
Product name
Precisely EnterWorks
Title
EnterWorks EPX Administration
Topic type
Administration
Configuration
First publish date
2007

Installations of EPX that use SQL Server as the repository will have several tables used to manage sequences that will grow over time. A stored procedure is provided called sequence_cleanup()" that can be executed to purge unnecessary rows from these tables. It is suggested that this stored procedure be executed on a periodic basis to ensure the tables do not grow unnecessarily large.

To maintain tables for SQL Server:

  1. Open the Query Analyzer Tool that can access the SQL Server EPX Repository.

  2. Log in using the EPX user name and password (or another ID or password that has the same access rights to the database).

  3. Inside the Query Analyzer Tool, select the database you want to maintain in the Databasedropdown list.

  4. Type in the command exec SEQUENCE_CLEAN_UP; and run the execute command.

Note: The result can be verified at the Messages tab underneath the Query box.