Data insert to DB2 slow

[JKDeveloper0718]

We are having an issue with data inserting into DB2 using SSIS. We are using the Microsoft OLE DB Provider for DB2 and we are reading from a DB2 staging table to a DB2 destination table that is the exact copy of the staging table. The following are some of the specifics as to what our problem is:

Data Volume: 48 Million
Fields: 757
Problem: Inserting
Through Put: 5-6 rows/sec

When
Fields: 20
Through put was 120 rows/sec

This is way too slow and we are wondering if there are any suggestions to remedy this issue.

 

[NiceArms]

Are you doing a bulk insert?

In SSIS within your OLE DB Destination Editor > Data Access mode, you have the option "Table or view - fast load"

This option is much quicker.

/Nice

 

[JKDeveloper0718]

We are doing a normal insert and the Data Access mode is set to Fast Load.

 

[JKDeveloper0718]

With the Microsoft OLE DB Provider for DB2 driver we are finding that the OLE DB Destination Data Access mode does not have a choice for a Fast Load.