Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    68

    Unanswered: Lock escalation....... what does that mean??

    I often see this type of error in the db2adm.nfy file:



    ADM5502W The escalation of "4203" locks on table
    "DB2ADMIN.CASH_HAND_MINE" to lock intent "X" was successful.

    ADM5500W DB2 is performing lock escalation. The total number of locks
    currently held is "4295", and the target number of locks to hold is "2147".




    What does this mean? Do I have locking issues?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It means that you are experiencing escalation from row level locks to table level locks, usually because you are running short of storage for locks (locklist parm). You should probably increase your locklist parm, and maybe the maxlocks (the percent of the locklist that can used by any one application before escalation occurs).

    If you don’t have contention (lock timeouts or deadlocks) keep in mind that lock escalation can sometimes be a good thing because DB2 will spend less time locking at the table level than having to lock each individual row.
    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
  •