Page 1 of 1

DataStage jobs are progressing very slowly

Posted: Wed Aug 31, 2016 12:13 am
by testuser33
Jobs are hung on the DataStage server. Even a reboot does not help. We checked one job - all the processes are on sleep. Could you please help.

Posted: Wed Aug 31, 2016 6:00 am
by eostic
One possibility is the WLM.... Take a close look at the Operations Console and the Work Load Manager....could be you have the threshholds too low.....such as the number of Jobs allowed to start concurrently, or the CPU value required before Jobs are allowed to start (raise it...maybe something "else" is consuming CPU and preventing your Jobs from starting).

Ernie

Posted: Fri Sep 02, 2016 3:53 am
by ray.wurlod
What is the job status as reported by Director client?

Re: DataStage jobs are progressing very slowly

Posted: Mon Sep 05, 2016 6:55 pm
by SURA
testuser33 wrote:Even a reboot does not help.
On top of the Rays comment, please clear the &PH& etc. I have seen the issue due to not cleaning it.

Posted: Tue Sep 06, 2016 7:23 am
by PaulVL
Was there a new code migration that you are not aware of?

Was that a "first time" execution of the code in a new environment?