How Db2 chooses lock types

Different types of SQL data manipulation statements acquire locks on target tables.

Begin program-specific programming interface information.

The lock acquired because of an SQL statement is not always a constant throughout the time of execution. In certain situations,Db2 can change acquired locks during execution. Many other processes and operations acquire locks. End program-specific programming interface information.