How can I eliminate old tracking data to make room for new tracking data in the database? 

Hi,

I can give this link

https://www.ibm.com/support/knowledgecenter/SSFTBX_8.5.5/com.ibm.wbpm.admin.doc/topics/using_perfsvr_commands_prune_run.html

Also I can give

https://www.ibm.com/support/knowledgecenter/SSNJFY_8.0.1/com.ibm.wbpm.admin.doc/adminguide/topic/removing_proc_instances_db.html

https://www.ibm.com/support/knowledgecenter/SSFPJS_8.5.7/com.ibm.wbpm.ref.doc/topics/rref_BPMProcessInstancesCleanup.html

 

you can automate these 2 things by using shell script and wsadmin which I have done.

Thank you! I ended up finding an answer here: https://www.ibm.com/developerworks/bpm/bpmjournal/1312_spriet/1312_spriet.html

but I am happy to have your links too!

Hi,
you can use the prune command option to get rid of old tracking data in the PDW database, see the product documentation here:
https://www.ibm.com/support/knowledgecenter/SS8JB4_19.x/com.ibm.wbpm.admin.doc/topics/using_perfsvr_commands_prune.html

The only option to cleanup data is the daysOld parameter, so you can specify that you want to purge data which is older than xx days. There is no option to cleanup tracking data only for one process application or anything else.

Depending on your product version, you can use the perfDWTool script to cleanup data with the prune command or you can initiate the cleanup from the process admin console - health management page.


------------------------------
Thomas Nold
------------------------------