BPM, Workflow, and Case

BPM, Workflow, and Case

Come for answers. Stay for best practices. All we’re missing is you.

 View Only

  • 1.  perfDWTool and cleaning up old data

    Posted Thu September 17, 2020 06:00 PM

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



  • 2.  RE: perfDWTool and cleaning up old data

    Posted Wed October 25, 2017 01:18 PM

    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.



  • 3.  RE: perfDWTool and cleaning up old data

    Posted Fri October 27, 2017 01:14 PM

    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!



  • 4.  RE: perfDWTool and cleaning up old data

    Posted Fri September 18, 2020 03:03 AM
    Edited by Stephanie Wilkerson Mon July 26, 2021 04:30 PM
    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
    ------------------------------

    Original Message