Job with Oracle Enterprise stage as the target hangs

Lavanya B · Post by **Lavanya B** » Fri Jul 30, 2010 5:34 am

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:

Code: Select all

ODBC--->Transformer-->Remove Duplicates-->Oracle Enterprise
             |
             |             
      Sequential file

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?

bakshdwh · Post by **bakshdwh** » Fri Jul 30, 2010 5:37 am

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..

ArndW · Post by **ArndW** » Fri Jul 30, 2010 6:28 am

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.