DB2 DB2_RR_TO_RS environment variable
Posted by: DBA DB2,
on 08 Dec 2011 |
View original | Bookmarked: 0 time(s)
The Environment Variable DB2_RR_TO_RS enables\disables the Repeatable Read attribute. I's enabled for DB2 performance purposes
DB2 registry parameter DB2_RR_TO_RS is used to:
Set a default isolation level for user tables to Read Stability (RS) isolation level. The RS level is not dissimilar to the Repeatable Read (RR) , with one difference a page or row retrieved remains locked to the UOW end , but if another application can insert a value , that will be read if your process access...