5.18 Describe the intent share (is) lock mode type
NOTE: the shading on this picture may not be accurate. Please click on
the picture to obtain a larger image, which is accurate.
Key points
- An intent share (IS) lock indicates an intention to read data (that is,
acquire an S lock) at a lower level of granularity.
- An IS lock on a PUBLICROW table together with an IS lock on a page indicates
an intention to read one or more rows on that page.
- An IS lock on a PUBLIC table indicates an intention to read one or more pages.
- An IS lock on a table indicates that the transaction wants to read some
of the rows in the table (an S lock on a table indicates that the transaction
wants to read all of the rows).
- An IS lock is also called a subshare lock.
Page last updated on November 29, 1995
|
Printable version
