Locked rows overview

Table rows are locked whenever a job accesses the data within the table. When a job holds a row lock and another job attempts to retrieve that row for update, the requesting job waits and is removed from active processing until the row lock is released or a specified wait time ends.

To display locked rows for a table, see Display locked rows.

To display locked row properties, see Display Locked row properties.

You can also Customize the columns displayed for locked rows.

For more information, see Commitment control in the Information Center Link to Information center.