Unlock Time in Seconds
In the software, it may prove useful to lock data from the database during a transaction. This is made possible using the following instructions:
- the Lock instruction that carries out a symbol lock.
- the With lock clause in a read command.
- the Readlock instruction that reads and locks a line in a table.
This technical parameter is used to define, when faced with a first failed attempt at locking because another user has already placed a lock, the number of seconds during which the engine automatically repeats its attempt before failing by warning the user via a locking message.
Level of localization / Global variable
The parameter is defined at the level Folder.Belongs to Module SUP (Supervisor) and to Group PRF (Performances),in which the following parameters can also be found :
- AUZMEMO (Create all memos)
- CLOMAX (Max no.)
- MAXUPDTRS (Update transaction limit)
- MEMTXT (Size of text memory)
- NBTRABUFF (Number of lines in memory)
- NXTREC (Threshold for last read read)
- ORAOPTMIZ (Oracle optimization)
- ORAOPTNB (Oracle optimization)
- ROLLBACK (Lock attempts before rollback)
- SELWARN (Limit for control memos)
- TIMOUT (Time limit for response)
The lockwait system variable is associated with this parameter.