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.