Job hangs at the join stage
Posted: Fri Jul 15, 2011 2:20 am
Hi, We made an upgrade to DS 8.5 by installing the datastage 8.5 fix pack 1.
Some jobs have been behaving weird. The jobs hang during execution at the join stage. And the jobs never complete.
Work around suggested by ibm was to set the Buffer settings in the Input links of join stage to Buffer (from default). Most jobs ran successfully after that. However one of them still runs forever and doesn't complete.
The job has the following stages. Dataset(1567374 rows) Join (Ref data: 2253004) Xfm and Target Dataset.
Please let me know if anyone is this forum had faced this issue or kindly post in your suggestions.
All these jobs have been working perfectly in 8.5(w/o fix pack)
Some jobs have been behaving weird. The jobs hang during execution at the join stage. And the jobs never complete.
Work around suggested by ibm was to set the Buffer settings in the Input links of join stage to Buffer (from default). Most jobs ran successfully after that. However one of them still runs forever and doesn't complete.
The job has the following stages. Dataset(1567374 rows) Join (Ref data: 2253004) Xfm and Target Dataset.
Please let me know if anyone is this forum had faced this issue or kindly post in your suggestions.
All these jobs have been working perfectly in 8.5(w/o fix pack)