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
------------------------------

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
------------------------------

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
------------------------------

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:
Sent: Fri June 18, 2021 02:50 AM
From: Bruno Charpentier
Subject: Purge PDWDB

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
------------------------------

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:
Sent: Fri June 18, 2021 02:50 AM
From: Bruno Charpentier
Subject: Purge PDWDB

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
------------------------------

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
------------------------------

Hi Sergei 
Hope you are well. Long time!

Thanks for the tip!

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

Original Message:
Sent: Thu June 24, 2021 05:43 AM
From: Sergei Malynovskyi
Subject: Purge PDWDB

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
------------------------------