Help on tuning the job
Posted: Mon Jul 17, 2006 11:02 pm
Hello All,
I need some help in tuning my datastage load job.
I am using DRS stage as source and target to load the sql server tables. I am trying to load 3 million records from source to target which is taking close to 5 hrs and there are no transformations involved in this job.
I want some ideas to reduce the load time.
Is it possible to make the job multi-instance? If yes then any kind of ideas will be appreciated.
Will there be any improvement in the performance if we use the IPC stage in between?
Thanks for all the inputs.
RCil
I need some help in tuning my datastage load job.
I am using DRS stage as source and target to load the sql server tables. I am trying to load 3 million records from source to target which is taking close to 5 hrs and there are no transformations involved in this job.
I want some ideas to reduce the load time.
Is it possible to make the job multi-instance? If yes then any kind of ideas will be appreciated.
Will there be any improvement in the performance if we use the IPC stage in between?
Thanks for all the inputs.
RCil