Problem

-- B2Bi administrators Guide specifies the following as step 2 for setting up the DB2 database:

"Use the db2set tool to make local configuration changes on the DB2 server as follows (page 209):
db2set DB2_RR_TO_RS=YES"

The setting seemed to be used primarily to prevent deadlock in certain situations.

-- DB2 information center states that this setting is deprecated.
http://www.dba-db2.com/2011/12/db2-db2_rr_to_rs-environment-variable.html

-- can we can just leave out this variable or is there an alternative setting required ?

Resolution

* DB2_RR_TO_RS deprecated since DB v8.2.

* DB2_RR_TO_RS was set for performance issue, and is no more relevant in next versions : it has not been replaced by another variable.

* please refer to http://www.ibm.com/developerworks/data/library/techarticle/dm-0802tessarek/index.html for further details

"DB2_RR_TO_RS     This parameter is deprecated since DB2 v8.2. If you don't get an error when trying to set the parameter in DB2 higher than version 8.2, it is okay to have it set.
If you get an error, never mind. The next two variables are the replacement for it.
When DB2_RR_TO_RS is on, RR behavior cannot be guaranteed for scans on user tables because next key locking is not done during index key insertion and deletion.
Catalog tables are not affected by this option.
The other change in behavior is that with DB2_RR_TO_RS on, scans will skip over rows that have been deleted but not committed, even though the row may have qualified for the scan."