Setting the Lock Time-Out Value

 

The integer in the combo box specifies the lock time-out value in seconds. When the user needs to acquire a lock on a database object, such as a table or a tuple, and that object has been already been allocated to another transaction, the user must wait until the object is released. DBMaker will wait for the object until a lock is acquired on the object or until the waiting time expires, at which time a "lock time-out" error message will be returned. The waiting time can be shortened if the user prefers not to wait too long. To disable the time-out, set the combo box value to -1 or enable Always Wait For Lock . This will cause DBMaker to continue waiting until the lock is released. The combo box value can be set to 0 or Don't Wait For Lock is enabled to indicate that the user doesn't want to wait at all. Each connection has its own dmconfig.ini, so each user can set an individual lock time-out value before connection to the database. This setting corresponds to the DB_LTimO keyword in the dmconfig.ini file. The default lock time-out value is 5 seconds.


Related topic:

Connection