DataStage jobs are progressing very slowly

testuser33 · Post by **testuser33** » Wed Aug 31, 2016 12:13 am

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.

eostic · Post by **eostic** » Wed Aug 31, 2016 6:00 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Sep 02, 2016 3:53 am

What is the job status as reported by Director client?

SURA · Post by **SURA** » Mon Sep 05, 2016 6:55 pm

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.

PaulVL · Post by **PaulVL** » Tue Sep 06, 2016 7:23 am

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?

DSXchange

DataStage jobs are progressing very slowly

DataStage jobs are progressing very slowly

Re: DataStage jobs are progressing very slowly