Reorganizing the Event Collector database tables

If an error similar to the following is encountered while running the cleanup script under DB2, a reorganization might be needed on the Event Collector database tables:

DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;BPMUSER.EC_WI_STATUS

1. Shut down the BPM node.
2. Execute whichever of the following reorganization queries are indicated by the error message:

   REORG TABLE EC_EVENT_INT;
   REORG TABLE EC_EVENT_ATTR;
   REORG TABLE EC_PE_STATUS;
   REORG TABLE EC_PE_ACTIVITY;
   REORG TABLE EC_WI_STATUS;
   REORG TABLE EC_PROC_TEMPLATE;
   REORG TABLE EC_USER_ACTIVITY;
   REORG TABLE EC_STATS;

3. Retry the cleanup script.