informix-datastage Digest 30 May 2001 00:00:00 -0000 Issue 2
Posted: Wed May 30, 2001 2:20 pm
This is a topic for an orphaned message.
Hello,
I was wondering if others in some jobs are processing through millions of records in some OCI stages. I had a problem reading from an OCI stage processing through 54 million records with some basic constraints. The job ran for 106 hours. I made a change to where the job now relies on the OCI stage for the sorting using where clauses therefore eliminating transformers and constraints. The job ran in under 20 hours. Has anyone experienced this type of problem before?