IBM BPM, V8.0.1, All platforms > Tuning > Advanced tuning > Business Process Choreographer tuning > Tuning BPEL processes > Tuning long-running processes
Remove unnecessary objects from the Business Process Choreographer database
You can improve the performance of your database by deleting or archiving runtime objects after they are no longer needed.
During normal operation, new runtime objects are created in the Business Process Choreographer database. Unless you take regular actions to remove unnecessary objects, the database will keep growing, which can reduce the performance.
Procedure
- If you have configured the Business Process Archive Manager, you can run the archive.py script to move completed process instances and human tasks to an archive database.
- Delete any data in the database that cannot be archived when the data is no longer required. You can use one of the Business Process Choreographer cleanup procedures to delete the data.
- If none of your applications use the Business Flow Manager or Human Task Manager query or query table APIs, you can run the optionalUpgradeIndexes.sql script to remove the indexes that are only used by those APIs. If you have not already dropped these indexes, remove the redundant indexes.
Related concepts:
BPEL process archiving overview
Cleanup procedures for Business Process Choreographer
Related tasks:
Remove redundant indexes
Tuning the DB2 database for Business Process Choreographer Tuning the Oracle database for Business Process Choreographer
Related reference:
Archiving completed BPEL process and task instances