Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    58

    Unanswered: Need Help with Lock Escalations

    I own a tool which is putting a very heavy load on a database, and I am
    getting lock escalation warnings and alarms. I have taken some steps
    to mark transactions as unconditional reads to try and make the DBs life
    easier, but I was wondering if there was any way to see which tables are
    getting the lock escalations so I can narrow down the problem.

    I recently added some logging in the DB to monitor exactly what requests
    are being asked of the tool, but I think that that addition itself is putting
    a heavy load on the DB. I think I am going to cache that info in memory and
    load it into the DB at regular intervals to ease that load.

    Any help/advice on tracking down locking issues would be appreciated.

    Thanks,
    Wayne

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by wayneb64
    I was wondering if there was any way to see which tables are
    getting the lock escalations so I can narrow down the problem.
    Try "GET SNAPSHOT FOR LOCKS..."

  3. #3
    Join Date
    Aug 2003
    Posts
    58
    Thanks, I was able to use:

    db2 get snapshot for locks on dbname | grep "Table Name"

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    For most databases, you should increase the LOCKLIST which has a default that is too low. This will help reduce the lock escalation.

    db2 connect to sample

    db2 update db cfg using LOCKLIST 4096
    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
  •