Results 1 to 4 of 4

Thread: locks on table

  1. #1
    Join Date
    Feb 2004
    Posts
    37

    Unanswered: locks on table

    hi again,

    can anybody tell me what this part of db2diag.log means?

    thanks

    bab

    ...

    ADM5502W The escalation of "2079" locks on table "BSM .GSPBTF$" to lock
    intent "X" was successful.

    2004-03-09-13.35.32.190105 Instance:db2inst1 Node:000
    PID:1494(db2agent (BSMSUNDB)) TID:8192 Appid:AC10009B.G7F1.00FB2F9B2635
    data management sqldEscalateLocks Probe:3 Database:BSMSUNDB

    ADM5502W The escalation of "2121" locks on table "BSM .GSPOSF" to lock
    intent "X" was successful.

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: locks on table

    It just means, that DB2 had allot of locks on that table, and lock memory was starting to get full, so it escualted the locks to conserver memory, If its causing you performace problems. increase your locklist memory. Otherwise its just an informational message.
    David Quigley

  3. #3
    Join Date
    Feb 2004
    Posts
    37

    Re: locks on table

    Originally posted by quigleyd
    It just means, that DB2 had allot of locks on that table, and lock memory was starting to get full, so it escualted the locks to conserver memory, If its causing you performace problems. increase your locklist memory. Otherwise its just an informational message.
    hi quigleyd

    thank you

    bab

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    There is also another parm called maxlocks which determines the maximum percent of the locklist that any one application can have before it triggers escalation. The higher the percent setting, the less likely that escalation occurs.

    Note that lock escalation increases the likelihood of contention between applications, but also increases performance by not having to maintain row level locking.
    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
  •