Jobs running slow on Tuesday

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
anandsh16
Premium Member
Premium Member
Posts: 17
Joined: Tue Dec 12, 2006 3:34 am

Jobs running slow on Tuesday

Post by anandsh16 »

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What are your commit settings and array size settings?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

So, those settings might be bad only on Tuesdays? :wink:

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

"You can never have too many knives" -- Logan Nine Fingers
Post Reply