Results 1 to 5 of 5

Thread: Db2_rr_to_rs

  1. #1
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513

    Unanswered: Db2_rr_to_rs

    Does anyone know where this went for v8?
    --
    Jonathan Petruk
    DB2 Database Consultant

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow

    No !

    Can you explain what it does? (did!)

    HTH
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  3. #3
    Join Date
    Mar 2004
    Posts
    448
    This registry parameter set next key locking guarantee the repeatable read isolation level by locking the next key for all insert and delete statements and the next highest keyvalue above the result set for Select statement.

    I think after type 2 indexes introduced in ver 8, this may become obselete.

    Regards,

    mujeeb

  4. #4
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Available

    Hi,

    FYI..

    This parameter is still available in DB2 V8, and as mentioned it could not be all that applicable since DB2 V8 provides type 2 indexes but given the isolation level of RR by default we have set the same to avoid frequent locking.
    HTH

    Nitin

    Ask the experienced rather than the learned

  5. #5
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by nitingm
    Hi,

    FYI..

    This parameter is still available in DB2 V8, and as mentioned it could not be all that applicable since DB2 V8 provides type 2 indexes but given the isolation level of RR by default we have set the same to avoid frequent locking.
    dbforums sure has been flakey lately!

    Anyway, type 2 indexes have gone a long way to resolving locking issues, but it's still nice to be able to force RS as the maximum isolation level. RR is rarely required.

    db2set -lr
    -> doesn't show DB2_RR_TO_RS as a possibility though... but when I set it there are no complaints! So I guess it does still exist.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •