Saving a workflow takes a long time to complete

Resolving The Problem

It is recommended to delete old data from TWFL_WEE_WORKFLOW_EVENT_ENTRY and TWFL_WFE_WORKFLOW_EVENT tables once in a while. It will not only prevent slow workflow save operation, but may speed up processing of items within collaboration areas as well.

This task can be done using maintenance script delete_collab_history.sh, which is available starting with release 10.1.0. Instructions on its usage can be found in the knowledge center:

At previous releases you may delete no longer needed data using SQL as outlined in the following.

Attention:

• Run the SQLs only when IBM Master Data Management Collaboration Server is stopped
• Use a timestamp, which is at least 10 days older than current timestamp. For example, when you take action on the 11th of August, then use as input timestamp the 1st of August or some older timestamp.

SQLs when using IBM DB2 database

DELETE FROM wee WHERE
wee_event_id IN (
SELECT wfe_id FROM wfe WHERE
wfe_finish_time < timestamp_format('2014-08-01 01:00:00', 'YYYY-MM-DD HH24:MI:SS')
AND wfe_event_status = 'DONE'
);

DELETE FROM wfe WHERE
wfe_finish_time < timestamp_format('2014-08-01 01:00:00', 'YYYY-MM-DD HH24:MI:SS')
AND wfe_event_status = 'DONE';

DELETE FROM wee WHERE
wee_event_id IN (
SELECT wfe_id FROM wfe WHERE
wfe_finish_time < to_date('01-AUG-2014','DD-MON-YYYY')
AND wfe_event_status = 'DONE'
);

DELETE FROM wfe WHERE
wfe_finish_time < to_date('01-AUG-2014','DD-MON-YYYY')
AND wfe_event_status = 'DONE';