Clearing Audit and Statistical Data Not Related to a Process Instance

Audit data not associated with process instances or work items can be purged. 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: These stored procedures do not 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.