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.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.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 |