DSXchange

Hi,

We have a job with Oracle Enterprise stage as the target. The job has 1.3 million+ records coming from source. This job has been migrated from DatStage7.5.1 The design is as below:
In DataStage 7.5.1, the job finishes in 7 minutes.
But in DataStage8.1, it takes 40 minutes to process 0.18 million records. The write method in the Oracle Enterprise stage is Upsert(User defined Update & Insert)

So can anyone help us understand why does the same job takes very long time to run and finally hangs in DataStage 8.1?

Well.. it happened to me once, can you try importing all the column definations in all the stages (specially for the source and target stages) again and run the job.

Its strange, but it worked for me once !

Because apart from the Version nothing else changed..

Is the only thing that changed the DataStage version -> or is there a new database or DS machine? Just changing DS versions should not have this impact and I would look elsewhere first.