Page 1 of 1

Datastage Job Hangs

Posted: Tue Dec 01, 2009 8:55 am
by UAUITSBI
Hi

We have created a job that is designed as follows

DRS - IPC - XF - XF - IPC - DRS

The jobs in Director shows it is still running where as the first link from the DRS to the IPC and the last link from the IPC - DRS show that they are finished (Only these 2 links are green, all others are Blue)

Any idea why this might be happening?

Thanks

Posted: Tue Dec 01, 2009 9:51 am
by chulett
What point do you think those IPC stages are serving in the job? :?

Remove them and then either run without row bufferring or enable it at the job level.

Posted: Tue Dec 01, 2009 9:54 am
by UAUITSBI
Personally I think absolutely no point :)

But unfortunately these are jobs delivered by Peoplesoft so changing them might not be in my best interest ( I might need to change over 1000 )

Posted: Tue Dec 01, 2009 10:07 am
by chulett
They're not the "magic bullet" that some seem to believe they are. And I'm not sure what anyone can suggest if you can't make any changes to the jobs. I'm going to have to defer to some of the more smarter folks here as to what might be going on under the covers but it sure seems IPC related to me.