Background documentationRegion Locate this document in the navigation structure

 

A region is a specific synchronization mechanism used by the SAP MaxDB database system to synchronize exclusive task access to a critical section in the working memory.

Special Synchronization Mechanisms

Name

Used for

Description

Region

Data Cache

EXCLUSIVE

When a task accesses a critical section, the associated region blocks this critical section for all other tasks.

Reader-writer lock

(share lock)

Catalog Cache

Shared SQL Cache

EXCLUSIVE or SHARED

If a task write-accesses a critical section, the associated reader-writer lock (share lock) blocks this critical section for all other write-accesses but allows other read-accesses.

If a task read-accesses a critical section, the associated reader-writer lock (share lock) blocks this critical section for all other write-accesses but allows other read-accesses.

More Information

Concepts of the Database System, Working Memory Areas

Database Administration in CCMS, Critical Sections