Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis
Browse by Tags · View All
DBA Scripts 51
performance 37
SQL Server 29
Object Management 24
#SQLServer 24
Backup and Restore 20
Security Management 20
Powershell 17
Indexes 14
DBA 14

Archive · View All
June 2011 38
January 2011 33
May 2011 32
August 2011 27
July 2011 26
January 2012 24
February 2011 19
April 2011 19
March 2011 17
March 2012 17

Jack Vamvas's Blog

DB2 DB2_RR_TO_RS environment variable

Dec 8 2011 12:00AM by Jack Vamvas   

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 the row a second time .
  • Reduce locking the next key for inserted or changed rows
  • Reduce deadlocks when using reverse scan indexes (ALLOW REVERSE SCANS) . i.e performing a scan in the opposite direction it’s intended

This environment variable is now deprecated

Republished from http://www.dba-db2.com.


Republished from SQL Server DBA [65 clicks].  Read the original version here [32134 clicks].

Jack Vamvas
5 · 27% · 8528
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"DB2 DB2_RR_TO_RS environment variable " rated 5 out of 5 by 1 readers
DB2 DB2_RR_TO_RS environment variable , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]