Oracle Enterprise stage errors out

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
splayer
Charter Member
Charter Member
Posts: 502
Joined: Mon Apr 12, 2004 5:01 pm

Oracle Enterprise stage errors out

Post by splayer »

I am bringing in 15million+ rows into a join using an OraEnt stage. Job aborts with error messages such as "Unspecified error", "pipe write faile","fileReadAck()" etc. When I put the data of this stage into a dataset and use the dataset to do the join, the job works.

Any idea why?
Top
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

may be the scratch area is not enough to hold the input data in join stage.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”