The HiRDB system automatically locks tables to prevent data inconsistencies, because data inconsistencies are apt to occur when several users manipulate a table simultaneously. This section explains the structure of locking and what aspects of locking the user can change.

Organization of this section

3.4.1 Units of locking

3.4.2 Lock modes

3.4.3 Lock period

3.4.4 Deadlocks and corrective measures

3.4.5 Unlocked conditional search

3.4.6 Non-locking of index key values

3.4.7 Lock and suppression implementable with a UAP

3.4.8 Lock sequence based on SQL statement and index types

3.4.9 Creating locked resources for index key values