Kbase 16073: What is the -lkwtmo used for?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/15/2009 |
|
Status: Verified
GOAL:
How to change the Lock wait timeout?
GOAL:
-lkwtmo parameter
GOAL:
Lock Timeout (-lkwtmo)
GOAL:
What is the -lkwtmo parameter used for?
GOAL:
How to use Lock Timeout (-lkwtmo) for WebSpeed?
FACT(s) (Environment):
All Supported Operating Systems
WebSpeed 2.x
OpenEdge 10.x
WebSpeed 3.x
FIX:
Use Lock Timeout (-lkwtmo) to specify a different wait time (in seconds).
An OpenEdge process encountering a locked resource waits for a limited time before continuing execution. If the resource is still locked, the process times out and the wait is canceled. This feature is called ?lock wait timeout.?
When the lock wait times out, the wait will be cancelled and the effect will be exactly the same as if an interactive user had pressed cancel in the alert box in GUI mode or pressed control-c in character mode.
Default:
The default wait time is 1800 seconds (30 minutes).
The minimum value is 60 seconds.
If a user specifies a value less than 60 seconds, Progress silently sets the value at 60 seconds.
For WebSpeed the default lock wait timeout is 10 seconds. To use add -lkwtmo the parameter and it's value in the Agents connections parameters.
Note:
- The wait time is accurate to within one minute of the value specified.
- Lock timeout applies to interactive and batch clients and component server processes.
- Lock timeout affects WAIT-FOR record locks, schema locks, and transaction commit locks.
- Lock timeout does not affect internal locks used inside the database manager, such as buffer locks.