Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011

    Unanswered: LOCKLIST is set to automatic


    something strange with LOCKLIST parameter for my database.
    Initially it was set to 16384 then I changed it to 32768. But when I checked the db cfg it was set to automatic. I changed it to 32768 again and now it is automatic again.
    Why it is changed to automatic? Is there any dependences from another parameters?

    We using db2 9.7 with fix pack 5.

  2. #2
    Join Date
    Aug 2008
    Toronto, Canada
    Check db2diag.log. It's possible STMM changed it back to automatic. Try the following:
    db2 connect to <db name>
    db2 update db cfg for <db name> using locklist 32768

  3. #3
    Join Date
    Jan 2013
    Check MAXLOCKS as well, they both (LOCKLIST and MAXLOCKS) have to be set to a set value, or both have to be AUTOMATIC.

Posting Permissions

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