Question:
What does the lock timeout error mean and what
can I do to change the timeout?
Answer:
"lock timeout" error, TIMEOUT and MAX QUERY TIME parameters.
By default, SQL statements sent to MS SQL and Sybase servers
using DB-Lib are sent using the synchronous query submission
API. Earlier versions of SQL Links used the asynchronous query
submission API. To use the asynchronous query submission API, add
2048 to the current value of DRIVER FLAGS or set it to 2048 if
it's blank.
To control the time-out for synchronous query submission use the
MSSQL and Sybase driver TIMEOUT param.
To control the time-out for Asynchronous query submission use the
MSSQL and Sybase driver and ALIAS MAX QUERY TIME param.