DB2 Load Running Very Slow
Posted: Mon Nov 23, 2009 11:59 am
Hi,
We have a datastage job which reads from the TD and Writes into DB2.
TD Connector -> DB2 enterprise stage.
The DB2 enterprise stage looks like this:
Write Method: Load
Write Mode: Append
Non - Recoverable Transactions: True
We find this DB2 write part to be very slow. We tried creating a Sequential file out of this TD read (this job took about < 10 minutes) and loaded that flat file using DB2 Bulk Load utility (the load took about 7 minutes). But the original job (show above in the email takes 1:40 minutes, which is too long).
Is not the DB2 enterprise stage using the DB2 Bulk Load utility, when we set the Write Method as Load and if so, it should approximately take the same time as the manual bulk load? Do we need to do any configuration setting for DB2 connections, at the datastage level? Or is there anything that we are missing in our job design?
Thanks
Venkatesh
We have a datastage job which reads from the TD and Writes into DB2.
TD Connector -> DB2 enterprise stage.
The DB2 enterprise stage looks like this:
Write Method: Load
Write Mode: Append
Non - Recoverable Transactions: True
We find this DB2 write part to be very slow. We tried creating a Sequential file out of this TD read (this job took about < 10 minutes) and loaded that flat file using DB2 Bulk Load utility (the load took about 7 minutes). But the original job (show above in the email takes 1:40 minutes, which is too long).
Is not the DB2 enterprise stage using the DB2 Bulk Load utility, when we set the Write Method as Load and if so, it should approximately take the same time as the manual bulk load? Do we need to do any configuration setting for DB2 connections, at the datastage level? Or is there anything that we are missing in our job design?
Thanks
Venkatesh