Locks

A lock is a software mechanism that prevents others from using a resource. You can place a lock on the following items:

• An individual row or key
• A page of data or index keys
• A table
• A database

Additional types of locks are available for smart large objects. For more information, see Locks for Smart Large Objects.

The maximum number of rows or pages locked in a single transaction is controlled by the total number of locks configured. The number of tables in which those rows or pages are locked is not explicitly controlled.