Kbase P123923: How to set the PROSQL_LOCKWAIT_TIMEOUT parameter
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/12/2010 |
|
Status: Verified
GOAL:
How to set the PROSQL_LOCKWAIT_TIMEOUT parameter
GOAL:
What is the PROSQL_LOCKWAIT_TIMEOUT parameter
GOAL:
Where to add the PROSQL_LOCKWAIT_TIMEOUT setting
GOAL:
Where to set the PROSQL_LOCKWAIT_TIMEOUT environment variable
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
OpenEdge 10.0x
OpenEdge 10.1x
All Supported Operating Systems
FIX:
The PROSQL_LOCKWAIT_TIMEOUT environment variable was introduced in 9.1D06 and is used to limit how long a client will wait for a record that has a share or exclusive lock against it.
This setting does not effect, nor is it needed for an SQL Client with an isolation level of READ UNCOMMITTED, because they will read a record that has a share or exclusive lock against it.
The PROSQL_LOCKWAIT_TIMEOUT environment variable enables you to determine how long SQL clients will wait in a lock queue for a particular record. The environment variable must be present before a broker is started and is applied to every SQL connection of the broker.
The minimum time-out value is the default of five seconds (DFLT_LOCKWAIT-TIMEOUT). The maximum time-out value is limited to a 32-bit integer value of 4,294,967,295 seconds or 1,193,046.5 hours.
You can set this environment variable prior to starting the database broker or AdminServer. For example, to set it to 30 seconds:
UNIX:
PROSQL_LOCKWAIT_TIMEOUT=30 ; export PROSQL_LOCKWAIT_TIMEOUT
Windows:
Control Panel -> System -> Advanced tab -> Environment Variables -> System Variables. Add a new variable.