Home > Term: repeatable read (RR)
repeatable read (RR)
An isolation level that prevents any row that is read from being changed by other applications until the transaction is completed. For WITH HOLD cursors, this applies to when the rows were actually read. For read-only WITH HOLD cursors, the rows might have actually been read in a prior transaction. RR also prevents any row changed by other applications from being read until the change is committed. A transaction that issues the same query more than once is guaranteed to read exactly the same rows again, disallowing phantom rows from being injected into the result set. See also cursor stability, read stability, uncommitted read, isolation level.
- Part of Speech: noun
- Industry/Domain: Software
- Category: Globalization software service
- Company: IBM
0
Creator
- Peteh
- 100% positive feedback