By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

query timeout

P: n/a
Hi all,

I'm writing an ODBC application on NT Server, accessing a db2 udb v
8.1.6 database on AIX. I'd like to issue a query, and if the
table/page/row is locked, to timeout instantly, rather than wait for
the lock to expire.

I can't modify the LOCKTIMEOUT parameter for the database because
ultimately the customer will have control over it, and my application
won't be the only one using that database.

By setting the statement attribute SQL_ATTR_QUERY_TIMEOUT to 1, and
setting QUERYTIMEOUTINTERVAL=1 in the db2cli.ini, I've managed to get
down to a 3 second timeout. Is there any way to further reduce the
timeout? I'd really appreciate any advice on this.

Thanks,

Abram Friesen
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.