Oracle bulk load stage
Posted: Tue May 15, 2007 12:41 pm
I have a job that reads data from a DB2 table in mainframe and loads the data into an oracle table table using SQLLOad stage. There is no transformation involved.
DB2STG----------->Transformer------------------->OCILoadstage
The jobs run at a nice speed at about 3000 rows per second and in about 10-12 minutes the links show the total number records in the source table. However, the count in the links keeps increasing. It alsmost takes another 15 - 20 minutes for the job to complete.
I would like to understand what the job is basically waiting on. Is it the load to the table (I believe so) that is the bottleneck or some datastage parameters that need to be set properly. By the way, I am using the 'Automatic' for the batch mode and the max record number is 1000.
I will appreciate any help.
Thanks,
Bhusan
DB2STG----------->Transformer------------------->OCILoadstage
The jobs run at a nice speed at about 3000 rows per second and in about 10-12 minutes the links show the total number records in the source table. However, the count in the links keeps increasing. It alsmost takes another 15 - 20 minutes for the job to complete.
I would like to understand what the job is basically waiting on. Is it the load to the table (I believe so) that is the bottleneck or some datastage parameters that need to be set properly. By the way, I am using the 'Automatic' for the batch mode and the max record number is 1000.
I will appreciate any help.
Thanks,
Bhusan