Clearing Audit and Statistical Data for Process Instances

The audit entries of a process instance are not required once the process instance completes, is cancelled, or failed. You can use stored procedures to delete these audit entries and statistical data for COMPLETED, CANCELLED, and FAILED process instances.

Stored procedures for different databases such as Microsoft SQL Server, Oracle, and DB2 are available in your installation location. The installer installs the stored procedure for the database available at CONFIG_HOME\bpm\bpm_app_name\database\ec.

Tip:
  • The same functionality as in these procedures is available as an API provided by the EventCollectorManagementService. See the TIBCO ActiveMatrix BPM - BPM Developer’s Guide for details.
  • Neither the EventCollectorManagementService API nor these stored procedures include any provision for backing up or archiving your database. TIBCO recommends that you backup your database, according to whatever backup strategy your organization has implemented, before initiating the procedure. Refer to the documentation supplied with your database server for information on how to do this.