DSXchange

Hi, we have a scenario where in many datastage jobs in production run quite slow as compared to other days. Some jobs also fail only on Tuesday with the error below
=============================================
main_program: APT_PMsyncWithSectionLeaders: non-zero status 1 from APT_PMpollUntilZero.
==============================================

We have checked whether any other process runs on the datastage or db2 server but there is none.

Also, regarding the slow running jobs ,DBAs say that the database is waiting for the application to send commands to the connections.

Does anyone has any idea regarding such issues

What are your commit settings and array size settings?

So, those settings might be bad only on Tuesdays?

For these symptoms, I would say it is definitely other things running on that day. Just because you haven't found any doesn't mean they're not there.