Kbase P9177: Is there a way to change the lock timeout in SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/13/2007 |
|
Status: Verified
GOAL:
Is there a way to change the lock timeout in SQL-92?
FACT(s) (Environment):
Progress 9.1x
FIX:
Progress 9.1D Service Pack 6 introduces a new environment variable which gives you the option to define the lockwait timeout. The environment variable is called PROSQL_LOCKWAIT_TIMEOUT, the value is measured in seconds with a default/lower limit of 5 and upper limit of 4294967295. This environment variable has to be set on the database server before the startup of the database.
The lockwait timeout is set to 5 seconds for earlier versions and it cannot be changed.
If the database is started with the Progress / OpenEdge AdminServer, then the environment variable PROSQL_LOCKWAIT_TIMEOUT should be defined in the proadsv script which is located in $DLC/bin
If the database is started with the proserve script, then the then the environment variable PROSQL_LOCKWAIT_TIMEOUT should be defined in the proserve script.
If the database is started by any other custom script, then the then the environment variable PROSQL_LOCKWAIT_TIMEOUT should be defined in the proserve script.
An example of how to define an environment variable in Unix is:
PROSQL_LOCKWAIT_TIMEOUT=5; export PROSQL_LOCKWAIT TIMEOUT
An example of how to define an environment variable in Windows is:
set PROSQL_LOCKWAIT_TIMEOUT=5