Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Is your table indexed?
try the below code
Select * from adcd.xyz with ur;
Regards
ASHFAQ
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