hi, we are using db2 udb v8.1 on 64 bit windows, this message is in
the db2diag.log file
ADM5502W The escalation of "38200" locks on table "xxx.xxx" to lock
intent "X" was successful.
currently i have locklist = 1075, maxlock=60, so based on the formula
(((locks held * 36)/ (locklist *4096)) *100) , i have the answer is
31, compare with maxlock 60, i should still have space for locks to
grow, so why this point the escalation happened?
12  7322 
"xixi" <da****@yahoo.c om> wrote in message
news:c0******** *************** ***@posting.goo gle.com... hi, we are using db2 udb v8.1 on 64 bit windows, this message is in
the db2diag.log file
ADM5502W The escalation of "38200" locks on table "xxx.xxx" to lock
intent "X" was successful.
currently i have locklist = 1075, maxlock=60, so based on the formula
(((locks held * 36)/ (locklist *4096)) *100) , i have the answer is
31, compare with maxlock 60, i should still have space for locks to
grow, so why this point the escalation happened?
Locks are 56 bytes on 64-bit DB2, not 36. This means that these 38200 locks
are consuming 48.5% of the lock list, not 31%.
(See http://publib.boulder.ibm.com/infoce...n/r0000268.htm)
Lock escalation occurs when the TOTAL number of locks held by ALL
applications exceeds MAXLOCKS percent of the lock list.
While it is true that the 38200 locks held on table xxx.xxx only consume
48.5% of the lock list, these locks combined with all the other locks held
in the system exceeded the 60% threshold (set by MAXLOCKS)
Thus, DB2 chooses the table with the largest number of row locks and
escalates the row locks to table locks, in order to free up lock list.
--
Matt Emmerton
"xixi" <da****@yahoo.c om> wrote in message
news:c0******** *************** ***@posting.goo gle.com... hi, we are using db2 udb v8.1 on 64 bit windows, this message is in
the db2diag.log file
ADM5502W The escalation of "38200" locks on table "xxx.xxx" to lock
intent "X" was successful.
currently i have locklist = 1075, maxlock=60, so based on the formula
(((locks held * 36)/ (locklist *4096)) *100) , i have the answer is
31, compare with maxlock 60, i should still have space for locks to
grow, so why this point the escalation happened?
Locks are 56 bytes on 64-bit DB2, not 36. This means that these 38200 locks
are consuming 48.5% of the lock list, not 31%.
(See http://publib.boulder.ibm.com/infoce...n/r0000268.htm)
Lock escalation occurs when the TOTAL number of locks held by ALL
applications exceeds MAXLOCKS percent of the lock list.
While it is true that the 38200 locks held on table xxx.xxx only consume
48.5% of the lock list, these locks combined with all the other locks held
in the system exceeded the 60% threshold (set by MAXLOCKS)
Thus, DB2 chooses the table with the largest number of row locks and
escalates the row locks to table locks, in order to free up lock list.
--
Matt Emmerton
> Lock escalation occurs when the TOTAL number of locks held by ALL applications exceeds MAXLOCKS percent of the lock list.
<snip>
--
Matt Emmerton
That differs from what the Administration Guide: Performance says:
"When the number of locks held by any one application reaches this
percentage [defined in maxlocks] of the total lock list size, lock
escalation will occur for the locks held by that application. Lock
escalation also occurs if the lock list runs out of space."
> Lock escalation occurs when the TOTAL number of locks held by ALL applications exceeds MAXLOCKS percent of the lock list.
<snip>
--
Matt Emmerton
That differs from what the Administration Guide: Performance says:
"When the number of locks held by any one application reaches this
percentage [defined in maxlocks] of the total lock list size, lock
escalation will occur for the locks held by that application. Lock
escalation also occurs if the lock list runs out of space."
"Mark A" <ma@switchboard .net> wrote in message
news:rh******** ******@news.usw est.net... Lock escalation occurs when the TOTAL number of locks held by ALL
applications exceeds MAXLOCKS percent of the lock list.
<snip>
--
Matt Emmerton
That differs from what the Administration Guide: Performance says:
"When the number of locks held by any one application reaches this
percentage [defined in maxlocks] of the total lock list size, lock
escalation will occur for the locks held by that application. Lock
escalation also occurs if the lock list runs out of space."
Sorry, my mistake.
--
Matt Emmerton
"Mark A" <ma@switchboard .net> wrote in message
news:rh******** ******@news.usw est.net... Lock escalation occurs when the TOTAL number of locks held by ALL
applications exceeds MAXLOCKS percent of the lock list.
<snip>
--
Matt Emmerton
That differs from what the Administration Guide: Performance says:
"When the number of locks held by any one application reaches this
percentage [defined in maxlocks] of the total lock list size, lock
escalation will occur for the locks held by that application. Lock
escalation also occurs if the lock list runs out of space."
Sorry, my mistake.
--
Matt Emmerton
i agree, and so why the lock escalated?
"Mark A" <ma@switchboard .net> wrote in message news:<rh******* *******@news.us west.net>... Lock escalation occurs when the TOTAL number of locks held by ALL
applications exceeds MAXLOCKS percent of the lock list.
<snip>
--
Matt Emmerton
That differs from what the Administration Guide: Performance says:
"When the number of locks held by any one application reaches this
percentage [defined in maxlocks] of the total lock list size, lock
escalation will occur for the locks held by that application. Lock
escalation also occurs if the lock list runs out of space."
i agree, and so why the lock escalated?
"Mark A" <ma@switchboard .net> wrote in message news:<rh******* *******@news.us west.net>... Lock escalation occurs when the TOTAL number of locks held by ALL
applications exceeds MAXLOCKS percent of the lock list.
<snip>
--
Matt Emmerton
That differs from what the Administration Guide: Performance says:
"When the number of locks held by any one application reaches this
percentage [defined in maxlocks] of the total lock list size, lock
escalation will occur for the locks held by that application. Lock
escalation also occurs if the lock list runs out of space."
"xixi" <da****@yahoo.c om> wrote in message
news:c0******** *************** **@posting.goog le.com... i agree, and so why the lock escalated?
Your application is taking out more locks than you're allowing (per
application or per instance). This may well be related to your other problem
(log space full): both being caused by not committing. Otherwise, increase
the lock list size. In any case (regardless of the explanation), use the DB2
monitor to monitor the lock list usage to see what's happening.
"Mark A" <ma@switchboard .net> wrote in message
news:<rh******* *******@news.us west.net>... Lock escalation occurs when the TOTAL number of locks held by ALL
applications exceeds MAXLOCKS percent of the lock list.
<snip>
--
Matt Emmerton
That differs from what the Administration Guide: Performance says:
"When the number of locks held by any one application reaches this
percentage [defined in maxlocks] of the total lock list size, lock
escalation will occur for the locks held by that application. Lock
escalation also occurs if the lock list runs out of space."
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: xixi |
last post by:
i am using db2 v8.1 windows 64 bit with fp3, i check db2diag.log ,
there is message stating
ADM5502W The escalation of "1540" locks on table "xxx.xxx" to lock
intent "X" was successful.
what does that mean?
i do have a sensitive updatable cursor to try to create a record lock
every time i read a row, then update the row, should the update
|
by: xixi |
last post by:
hi, we are using db2 udb v8.1 on 64 bit windows, this message is in
the db2diag.log file
ADM5502W The escalation of "38200" locks on table "xxx.xxx" to lock
intent "X" was successful.
currently i have locklist = 1075, maxlock=60, so based on the formula
(((locks held * 36)/ (locklist *4096)) *100) , i have the answer is
|
by: Jane |
last post by:
Our db2diag.log is full of messages like this:
2004-05-31-17.15.10.383766 Instance:tminst1 Node:000
PID:394948(db2agent (TMDB1) 0) TID:1 Appid:GA140956.EF26.03A4B1202647
data management sqldEscalateLocks Probe:3 Database:TMDB1
ADM5502W The escalation of "4759" locks on table "I2TM .SHPM_T" to lock
intent "S" was successful.
The message is always about Shared locks. What can I do to eliminate these errors?
|
by: Bruce Pullen |
last post by:
DB2 v7.2 (FP7 - DB2 v7.1.0.68) on AIX 5.2.0.0.
We're seeing unexpected single row (then commit) insert locking
behaviour.
We're seeing Applications that already hold row-level W locks in
lock-wait, waiting to acquire row-level X locks. The lock-waits are
behind applications that have row-level X locks on different rows
(honestly). Both executing and lock-waiting applications have been
granted IX table locks.
|
by: db2group88 |
last post by:
we are using db2 udb v8.1 on windows, the configure parameter for
locks is locklist 1000, maxlocks 60, but somehow i still have the
error message
ADM5502W The escalation of "1" locks on table "SYSIBM
..SYSSCHEMAAUTH" to lock
intent "X" was successful.
so why even one lock on table still escalate to X lock? our
application doesn't use this table, so why there is lock on it, is it
| | |
by: Trent |
last post by:
Hello, all.
I have the following production DB2 environment.
DB2 8.1.4 (fp4) WG edition with 2 production databases on Windows 2003
standard edition.
My first question is regard with locking. I found some escalations for
X lock on some tables. How do I work out an appropriate MAXLOCK &
LOCKTIMEOUT settings to optimize the lock escalation issue.
|
by: kavallin |
last post by:
I receives the following in the db2diag.log file many times / day :
2007-03-05-14.55.24.836553+060 E12415C457 LEVEL: Warning
PID : 2785 TID : 1 PROC : db2agent
(dbname)
INSTANCE: db2inst1 NODE : 000 DB : dbname
APPHDL : 0-946 APPID: *LOCAL.db2inst1.070305135434
FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:3
MESSAGE : ADM5502W The escalation of...
|
by: stefan.albert |
last post by:
Hi folks,
we have a little discussion about lock escalation...
What is better for performance: To have an escalation "early" (smaller
locklist) or aviod the escalation with a big lock list?
We don't care about concurrency - because the changes have to be done,
other SQL waiting for this is OK.
Anyhow - I think: A lock table in exclusive mode would be the the most
|
by: cburnett |
last post by:
Have a peculiar problem regarding lock escalation. Originally lock escalation was occurring because of an application changing most of the rows in a large table. After setting locksize to table to overcome this, still seeing periodic lock escalations (every hour or so) but only of abour 20 rows and for one application at a time. Given a 100MB lock list, why is escalation kicking in and only escalation about 2K of locks? MAXLOCKS would also...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
