IBM DB2 AIX ODBC connector

[arthur]

Hi,

We are extracting data from IBM DB2 9.1 running on AIX. We are using the default IBM ODBC connector.

The problem is that the query is running very slowly, returning chunks of 6K rows only. It took around 1 hour to extract 1.8 million rows.

Does anyone know how we could possibly improve this?

Is there any environment variable that could be set to increase the number of records returned in each block?

Thanks,

Arthur

[ashfaq_haseeb]

Hi,

Is your table indexed?

try the below code

Select * from adcd.xyz with ur;

Regards

ASHFAQ

[arthur · Accepted solution]

Hi ASHFAQ,

Thanks for your response. Unfortunately we tried that but the result was the same.

We did not notice at first that there was also an OLEDB Connector for DB2. We then connected through this OLEDB Connector and the performance got a lot better.

Regards,

Arthur