Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184

    Unanswered: next key locking cause timeout & deadlock ?

    DB2 UDB V7

    Next Key Locking causes timeout & deadlocks in V7. What can be done to resolve this?

    TIA.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    db2set DB2_RR_TO_RS=YES

    This only applies to DB2 V7, since type 2 indexes in V8 don't have this problem.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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