BPM, Workflow, and Case

 View Only

  • 1.  Purge PDWDB

    IBM Champion
    Posted Thu June 17, 2021 07:35 PM

    Hi guys,

    Would you able to help me with official IBM docs to purge PDWDB?

    We are on the latest BAW 20.0.0.x version. 

    There's another issue I want to consult you all. 

    Do you know why there's a LSW_TASK in PDWDB? What is it used for? As far as I know, we don't use any tracking features in BPM in our applications and yet this table has been populated with even more data than the actual LSW_TASK in BPMDB. This amazed me for a bit. 

    Therefore, I'm looking to understand why this table is being populated. 
    Is there any config to turn it off if we're not using PDWDB at all? and how should we purge this entire PDWDB correctly?

    Appreciate any responses you may have!

    Regards
    Thong Huynh



    ------------------------------
    Thong Huynh
    Sydney NSW
    ------------------------------


  • 2.  RE: Purge PDWDB

    Posted Fri June 18, 2021 02:47 AM
    Hi,

    PDW is enabled by default.
    To disable it see https://www.ibm.com/mysupport/s/question/0D50z00005phtbZCAQ/disabling-tracking-data-generation-for-a-process-server-or-process-center-in-ibm-business-process-manager-bpm?language=en_US
    To clean up the PDW db see  https://www.ibm.com/support/pages/node/479527 (except steps 12 and 13 since PDW will be disabled).

    ------------------------------
    Bruno Charpentier
    ------------------------------

    Original Message


  • 3.  RE: Purge PDWDB

    Posted Fri June 18, 2021 02:50 AM
    Concerning the LSW_TASK table in PDW questions, it is similar to the BAW table but not exactly. In PDW due to the database model you can have several rows for a task instance and there are rows related to process instances (the start/stop process activities are considered as a task).

    ------------------------------
    Bruno Charpentier
    ------------------------------

    Original Message


  • 4.  RE: Purge PDWDB

    IBM Champion
    Posted Mon June 21, 2021 08:52 PM
    Thanks Bruno,

    Appreciate it much.

    Let me try these steps out and post back to the community if we could successfully get it to work.

    Regards,
    Thong

    ------------------------------
    Thong Huynh
    Sydney NSW
    ------------------------------

    Original Message


  • 5.  RE: Purge PDWDB

    IBM Champion
    Posted Tue June 22, 2021 12:37 AM
    Hi Bruno,

    We were able to successfully disable the Performance Data Warehouse feature in BPM. Here are the steps we did

    Step 1 - Locate 100custom.xml at cell level E:\IBM\WebSphere\AppServer\profiles\BPMPCDmgr01\config\cells\BPMPCCell01\clusters\BPMPC.AppCluster\process-center\config
    E:\IBM\WebSphere\AppServer\profiles\BPMPCDmgr01\config\cells\BPMPCCell01\nodes\BPMPCNode01\servers\BPMPC.AppCluster.BPMPCNode01.0\process-center\config

    Step 2 - Add the following to 100Custom.xml

        <common merge="mergeChildren">

        <performance-server-communication> <enabled merge="replace">false</enabled> </performance-server-communication>

        </common>

    Step 3 - Full Synchronize

    Then, do a full synchronization to apply changes from dmgr to all nodes' clusters members.

    Login to WAS console, to System Administration > Nodes, select node and click Full Synchronize

    Or you can stop dmgr before you begin and restart after you're done.

    Step 4 - verify the changes 

    Check TeamWorksConfiguration.running at nodes

    Also we do a select count(*) from pdwdb.lsw_task and we could see that no more data populated to this table. Hooray!

    Regards!

    ------------------------------
    Thong Huynh
    Sydney NSW
    ------------------------------

    Original Message


  • 6.  RE: Purge PDWDB

    Posted Thu June 24, 2021 05:43 AM
    hey Thong :) 
    One more thing to mention - if you ever need to enable PDW back on in future then make sure you check all BPDs/Processes to see if any of them are enabled with auto-tracking. If yes, that would populate most of PDW tables with data (including LSW_TASK) because timing intervals are created for each step of the Process when autotracking is enabled.

    ------------------------------
    Sergei Malynovskyi
    ------------------------------

    Original Message


  • 7.  RE: Purge PDWDB

    IBM Champion
    Posted Thu June 24, 2021 08:23 AM
    Hi Sergei 
    Hope you are well. Long time!

    Thanks for the tip!

    ------------------------------
    Thong Huynh
    Sydney NSW
    ------------------------------

    Original Message