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