Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unanswered: ADM5502W The escalation of "1" locks on table

    In my db2 database i am getting following message

    ADM5502W The escalation of "1" locks on table "TTE .PE_REQUEST" to lock
    intent "S" was successful.

    Why it is escalated to table level lock when there is only 1 lock...?
    If there is any problem if these message keeps coming ?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    There are several reasons for lock escalation. One reason may be that the locklist parameter is running out of memory for additional row level locks. You might want to increase the size of the locklist to prevent escalation because of memory problems.

    Another reason for escalation is if one application has more than a certain percentage of the locks in the locklist. This is controlled by the maxlocks parameter.

    The message you got about getting "1" table level lock is not related to the number of other locks that may have caused the escalation.

    Check the "Administration Guide: Performance" for more information on these parameters.
    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
  •