Performace issue in job sequence run

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
koolnitz
Participant
Posts: 138
Joined: Wed Sep 07, 2005 5:39 am

Performace issue in job sequence run

Post by koolnitz »

Hi

We have a job sequencer containing 10 jobs in row. If a job finishes successfully, its successor job kicks off and there are no other triggers defined between the jobs.

Earlier, the sum of Elapsed time of individual jobs was quite near to the total elapsed time of the job sequence. Now, DS takes 2-5 mins (God knows for what!) after finishing one job and kicking off the next job in sequence. We have a major performance issue because of this.

Has anyone faced similar issue? Any help would be highly appreciated.

PS: We have checked with our Unix Admin and everything seems to alright at OS level. We have even had the server rebooted, but in vain.

Thanks!
Nitin Jain | India

If everything seems to be going well, you have obviously overlooked something.
Raghavendra
Participant
Posts: 147
Joined: Sat Apr 30, 2005 1:23 am
Location: Bangalore,India

Post by Raghavendra »

Please check if your &PH& directory is filled up. I remember once we had problems like this and we cleared the &PH& directory. Just check this out or wait for the expert comments.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Along the same lines, check to see how big the log files of the 2 jobs in question are; purge them if necessary or ensure that the autopurge settings are enabled.
Raghavendra
Participant
Posts: 147
Joined: Sat Apr 30, 2005 1:23 am
Location: Bangalore,India

Post by Raghavendra »

Nitin Jain,

Is the problem solved? If so can you please post the deatils how you solved the problem so that it will be helpful us in identifying the performance issues.
Post Reply