[sqr-users] improving DB2 SQL select performance.

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

DB2 8.1 on Windows NT server
SQR 8.1

Can anyone recommend any "quick fixes" for DB2 select performance.  I am
running SQR and Brio intelligence on the same box, using the same DB2
connection, to a remote DB2 server, and Intelligence is running much faster.
I am basically running table scans against large databases - 4 million rows.

I added FOR FETCH ONLY to the end of my select which doubled the speed.
 The -Bnnn option doesn't seem to work with DB2.  Is there a way to increase
the buffer size?

I'll confess I know very little about DB2.  I know Brio Intelligence is
using an ODBC connection.  Is SQR using the same connection or does it use
CLI or something else?  I access DB2 using DB2 connect software.

Any tips greatly appreciated.

Thanks, Steve.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users