hi,

i use the DB2 Connect (Ver. 8.1) to load Data from
an AS/400 (V5R2) to a W2K Server and back to the AS/400.
(Datawarehouse ETL-Process).

Now i have problems with the performance of 1 table (about 200 columns and row length of 2000 bytes)

with other tables i got a performance up to 60.000 rows/sec (or normal 3-4.000 rows/sec).

with this table i have only 400 rows/sec.
The loading with ODBC (Client Express) ist faster than the DB2 connect.

Are there any settings within the DB2 Connect i can test?

Thanks in advance.

Anwy