B2B Integration

 View Only

 Schedule_PurgeService hang for sometime in the JDBC service

Taha LEBIED's profile image
Taha LEBIED posted Thu April 10, 2025 03:40 AM

Hello,

On our new environment the BP of purge service sometimes it tooks a lot of time to execute, it runs each 10 minutes sometimes the jdbc request take few seconds but sometimes it take up to 1 hour.

My question is what could make this happen?

I modified the Archive manager settings, where it was set to archive, now it's on a purge mode, will this help (this is our settings in our old environment where we have no problem)?

What's the steps to analyse this issue.

Thanks in advance!

Lindsay McCurdy's profile image
Lindsay McCurdy posted Fri April 11, 2025 06:05 AM

Hi,

It is recommended to use External Purge.

Some steps for analysis/troubleshooting:

Use the Dashboard > System > Troubleshooter screens to make sure your processes are all in state that can be archived/purged.

Use the DBStats report to check the current status.

Make sure Datasweeper is scheduled. Check the results.

Check that Schedule_IndexBusinessProcessService, Schedule_LinkagePurgeService and Schedule_AssociateBpsToDocs are scheduled and completing successfully.

NB Lock errors are ok as long as the processes do not always fail.

These BPs might need to be tuned, depending on the load on your deployment.

If you are still concerned, open a ticket with IBM Support to get help.

Hope this helps.

Related Content