read committed with lock

read committed with lock determines whether an SAP ASE using transaction isolation level 1 (read committed) holds shared locks on rows or pages of data-only-locked tables during select queries.

Summary Information

Default value

0 (off)

Valid values

0 (off), 1(on)

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Lock Manager

For cursors, read committed with lock applies only to read-only cursors declared.

For transaction isolation level 1, select queries on allpages-locked tables continue to hold locks on the page at the current position. Any updatable cursor on a data-only-locked table also holds locks on the current page or row. See the Performance and Tuning Series: Basics.