Consultor Eletrônico



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).