Choose a topic
LockWaitEnables an application to configure the lock wait interval for the connection. The lock wait interval is the number of seconds to wait for a lock when there is contention on it. Sub-second LockWait values significant to tenths of a second can be specified using decimal format for the number of seconds. For example:LockWait = 0.1results in a lock wait of one tenth of a second.LockWait may 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.0Actual lock wait response time is imprecise and may 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.Cache grid uses message wait time with lock wait time. When using cache grid, lock wait times are approximately half the value you have specified. If your applications require the full lock wait time, specify twice the desired seconds.A connection can change the lock wait interval at any time by calling the ttLockWait built-in procedure.To display a list of all locks on a particular database you can use the TimesTen utility ttXactAdmin.Required privilegeNo privilege is required to change the value of this attribute.SettingSet LockWait as follows:Where to set the attributeHow the attribute is representedSettingC or Java programs or UNIX odbc.ini fileLockWaits - Indicates the number of seconds to wait for locking conflict resolution before timing out. The default is 10 seconds.Windows ODBC Data Source AdministratorLockWait fields - Indicates the number of seconds to wait for locking conflict resolution before timing out. The default is 10 seconds.