Job sits in run status without running

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
lsnovick
Participant
Posts: 80
Joined: Fri May 25, 2007 7:24 am
Location: Troy

Job sits in run status without running

Post by lsnovick »

My job compiles and looks like it starts running. If I look at it in the monitor, it is in ready. The job never runs. It just keeps running without really doing anything.

I have:

Netezza, transformation, lookup, Difference, Transformation and insert and update.

I have Netezza all as connector.

Anyone experience this?
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Is the job actually dispatched yet?

Is the DSD.RUN active?

Did you ask your Netezza DBA if your connection was established yet? It could simply be building your result set.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Check on UNIX to see if the processes are running, "ps -ef | grep {jobname}" and if processes are running see if they are consuming CPU.
Post Reply