LockWait
The LockWait attribute enables an application to configure the lock wait interval for the connection.
LockWait values significant to tenths
of a second can be specified using decimal format for the number of seconds. For
example:LockWait = 0.1
results in a lock wait of one tenth of a second.
LockWait can be set to any value between 0 and 1,000,000
inclusive to a precision of tenths of a second. The default is 10
seconds:
LockWait = 10.0
Actual lock wait response time is imprecise and can be exceeded by up to one tenth of a second, due to the scheduling of the agent that detects timeouts. This imprecision does not apply to zero second timeouts, which are always reported immediately.
The number of connections to a database can impact the time needed to resolve lock contentions. If you anticipate having many connections to the database, increase the lock wait interval.
A
connection can change the lock wait interval at any time by calling the
built-in procedure.
To display a list of
all locks on a particular database you can use the TimesTen utility ttXactAdmin.
Required Privilege
No privilege is required to change the value of this attribute.
Setting
Set LockWait as follows:
| Where to set the attribute | How the attribute is represented | Setting |
|---|---|---|
|
C or Java programs or UNIX and Linux systems |
|
|
|
Windows ODBC Data Source Administrator |
Not applicable |