Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Hong Kong
    Posts
    41

    Unanswered: locktimeout error with insert and delete sqls

    I am using DB2 UDBV7.2.5, AIX 5.X

    I delete and reinsert a record to a table in connection 1, then I want to delete another record in that table in connection 2. After issuing delete sql in connection 2, i get locktimeout error.

    in the time between delete sql in connection 2 and locktimeout, i get snapshot for locks and found the following locks in the table:

    connection 1:
    X on row
    IX on table
    X on key value
    S on key value

    connection 2:
    IX on table

    I wonder if X and S on key value cause the locktimeout error, but I don't know what is key value.

    Can anyone help me?
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Yes, X and S locks are not compatible. Check out the following to see lock compatibility chart:

    http://publib.boulder.ibm.com/infoce...help/index.jsp
    and search for "Lock type compatibility".

    Andy

Posting Permissions

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