DataStage Migration 6 to 7.5

Prashantoncyber · Post by **Prashantoncyber** » Wed Feb 22, 2006 2:17 am

Hi All,

While migrating the job from 6 to 7.5 ,One job js running for quite long time which is extracting the data from the oracle table .Infact its running big extration querry in ORAOCI8.
I ran same querry on sql pls .there also it ran for long.
However the same job took very less time whilce running on DS-6 on the same table and same database.
All ready searched the forum.

Can any body suggest?

Thanks
Prashant

ArndW · Post by **ArndW** » Wed Feb 22, 2006 2:21 am

Prashant,

you stated that

ran same querry on sql pls .there also it ran for long.

. If you only changed from DataStage 6 to 7.5 and didn't make any changes to your database, then the pure SQL query should have run for the same time. Since this query that doesn't use DataStage also ran slower, why do you think the cause might be inside DataStage?

Prashantoncyber · Post by **Prashantoncyber** » Wed Feb 22, 2006 2:31 am

Hi,

As i stated, when i ran the same job in DS-6 it took normal ie very less time where as its taking its taking very long time on DS-7.5 .

thanks
Prashant

ArndW · Post by **ArndW** » Wed Feb 22, 2006 2:39 am

But didn't you also state that running the same SQL from the command line now also takes a long time?

Prashantoncyber · Post by **Prashantoncyber** » Wed Feb 22, 2006 2:55 am

ya, this what i am wondering at.....

Thanks
Prashant

chulett · Post by **chulett** » Wed Feb 22, 2006 7:58 am

In other words, stop focusing on the DS upgrade as the culprit and look into what changed in the query or database to cause this to 'run long'. Your stats may be out of date and the query plan changed dramatically. I'd suggest working with your DBA unless you feel comfortable doing the analysis yourself.