DSXchange

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?

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.

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.