topic Re: IBM DB2 AIX ODBC connector in QlikView

IBM DB2 AIX ODBC connector

arthur — Tue, 06 May 2014 20:12:45 GMT

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

Re: IBM DB2 AIX ODBC connector

ashfaq_haseeb — Wed, 07 May 2014 06:17:15 GMT

Hi,

Is your table indexed?

try the below code

Select * from adcd.xyz with ur;

Regards

ASHFAQ

Re: IBM DB2 AIX ODBC connector

arthur — Thu, 08 May 2014 21:51:53 GMT

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