Kbase 20208: How to Change the -spin Parameter at Runtime via 4GL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/6/2008 |
|
Status: Verified
GOAL:
How to Modify -spin parameter with a 4GL routine.
FACT(s) (Environment):
Progress 8.2x
Progress 8.3x
Progress 9.x
FIX:
The Spin Lock Retries (-spin) is an algorithm used for access to shared memory structures. On the earlier Progress database versions the PROMON utility could be used to change the value of the -spin parameter without a database shutdown.
Starting with Version 8.2, the Virtual System Tables can be utilized to fetch the value for the -spin parameter and modify it using a 4GL routine. Follow this example code:
find first _startup.
update _startup._startup-spin.
that the -spin parameter has on the system.