Re: Upload MS Access DB to the iSeries (too slow!)

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Peter,

It depends how you have defined the ODBC SQL statement.
Is the PF keyed and index rebuild set to *IMMED?

We had a similar procedure to update about 16 files, the smallest with
about 100 records (halve of the files) and the largest about 75000 records,
others under 30000 records. This took more than 12 hours.

We changed it to AS/400's impor/excport function (CPY__IMPF) and it ran
within 2,5 hours.

Do you really need to do this with ODBC?

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 14-5-2007 at 16:02 Peter Vidal wrote:

> Hi list!
>
> I have a file on the iSeries with the appropriate fields, sizes, and such.
Then I am using the iSeries/Access ODBC driver on my PC to create a link 
> table in Access, and then create an update query in Access that will write
records to the iSeries via ODBC. 
> My issue is that it is EXTREMELY SLOW.  My ODBC Configuration is as
follows:
> a) PACKAGES Tab: Nothing is checked.
> b) PERFORMANCE Tab: ENABLE DATA COMPRESSION is the only one checked.
> c) TRANSLATION Tab: Convert binary data 65535 is checked
> d) DIAGNOSTIC Tab: Nothing is checked.
>
> I do not know what else to check.  Any hints of how to speed up this?