467,198 Members | 1,207 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,198 developers. It's quick & easy.

query timeout

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
  • viewed: 3154
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Stefano | last post: by
reply views Thread by Philip.M.Collins@gmail.com | last post: by
3 posts views Thread by Stijn Vanroye | last post: by
1 post views Thread by traceable1 | last post: by
1 post views Thread by msmith@crypticedge.net | last post: by
reply views Thread by laurenquantrell | last post: by
2 posts views Thread by laurenquantrell | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.