Several factors affect the mode and granularity of database manager
locks.
These factors include:
The type of processing that the application performs
The data access method
The values of various configuration parameters
Locks and types of application processing
For the purpose of determining lock attributes, application
processing can be classified as one of the following types: read-only,
intent to change, change, and cursor controlled.
Locks and data-access methods
An access plan is the method that the optimizer
selects to retrieve data from a specific table. The access plan can
have a significant effect on lock modes.