3 Cleanup EIP Database

In the EIP database there are three Oracle PL/SQL procedures to cleanup the tables:

• EIP_CLEANUP_BPM_QUEUE

  To clean up BPM tables (T_BPM_ACT, T_BPM_PRC, T_BPM_VAR)

• EIP_CLEANUP_EIP_QUEUE

  To clean up table T_EIP_QUE

• EIP_CLEANUP_ALL

  Calls the other two procedures (EIP_CLEANUP_EIP_QUEUE and EIP_CLEANUP_BPM_QUEUE) with a time stamp value "param".

  The entries will be deleted previously at a given time stamp. This value is by default 7 days in the past (is equivalent to '-P7D' in old cleanup task configuration), but can be changed if desired.

  
  

  Note: To execute cleanup task on a regular basis, a database scheduler or "cron job" (Windows scheduler) can be used.

  
  
  
  

  Note: There is always an additional implicit constraint that limits the result to all not-processed records (processedx != 0)!