If I turn on DS_PXDEBUG, will it degrade the performance?

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
goosarikiran
Participant
Posts: 9
Joined: Tue Jul 26, 2005 11:12 pm
Location: Bangalore

If I turn on DS_PXDEBUG, will it degrade the performance?

Post by goosarikiran »

Hi All,

We have a Datastage project which has more than 2600 jobs running daily. I have to set the DS_PXDEBUG parameter to 1 at project level for analyzing one job failure. If I turn on DS_PXDEBUG parameter at the project level, would it degrade the performance of all other jobs?

Thanks in Advance,
Kiran
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Technically if you turn on debug you are gathering extra information and putting it into the job log. The act of doing that has an effect be it ever so minimal on your job performance. Spanning that accross all 2600 jobs and it has a cumulative effect.


Even turning on the monitor in Director technically slows down your job.

Your question should be "Will it be a noticeable effect?". Probably not.

But you would only be turning on DEBUG mode for a short period of time. And you would have tested all of your process in your NON Production environment to begin with. You could do a before and after timing on your job execution to see the time impact (if any).
Post Reply