Datastage Job Hangs

UAUITSBI · Post by **UAUITSBI** » Tue Dec 01, 2009 8:55 am

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

chulett · Post by **chulett** » Tue Dec 01, 2009 9:51 am

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.

UAUITSBI · Post by **UAUITSBI** » Tue Dec 01, 2009 9:54 am

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 )

chulett · Post by **chulett** » Tue Dec 01, 2009 10:07 am

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.