How to increase performance?
Posted: Sun Sep 19, 2010 11:49 pm
Hi,
My job design is like:
DB2---------->Modify----------->DB2
I have 5,925,155 records in source, an I am doing direct load into target using write/append option. In modify I'm using NOWARN specification. Other than this I'm not doing any kind of conversion. In source I'm converting decimal to char using char(bigint(internet_order_nbr) function. This is taking 1 hour to get complete. Is there any option to increase the performance?
Please let me know..
Thanks& Regards,
Kalpana.
My job design is like:
DB2---------->Modify----------->DB2
I have 5,925,155 records in source, an I am doing direct load into target using write/append option. In modify I'm using NOWARN specification. Other than this I'm not doing any kind of conversion. In source I'm converting decimal to char using char(bigint(internet_order_nbr) function. This is taking 1 hour to get complete. Is there any option to increase the performance?
Please let me know..
Thanks& Regards,
Kalpana.