Kbase P62508: Are semaphores used even though -spin is also being used during database startup?
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  04/10/2010 |
|
Status: Verified
GOAL:
Are semaphores still used when the database is started with -spin?
GOAL:
If using -spin, do I still use semaphores?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
Yes, if you have an Enterprise license and you use the -spin parameter, the database engine will continue to use semaphores as well as latches.
Semaphores are ALWAYS used for "long term" waits (such as a wait for a record lock) regardless of the setting of -spin. -spin covers "short term waits" which are basically latches used by the database storage engine to protect critical sections of code (usually shared memory lookups and updates).