Hi,
I was getting the error: sqlcode: -911 sqlstate: 40001 , which is
"The maximum number of lock requests has been reached for the
database."
So i increased the locklist size to 200 from the default value of 100.
I wanted to know what other effects it will have on the database?
Like, will the performance reduce, if the locklist size is 200 and 120
locks are on it as compared to when the locklist size is 130 and 120
locks requests.
If yes, how can i try to improve the performance degradation caused by
increasing the locklist?
Also, when i run the command "db2 list applications", the number of
applications running is much less than 100, still it gives the above
error of locklist getting exceeded.
Thanks
Rahul 4 8262
On Aug 22, 10:25 am, Rahul B <rahul.babb...@ gmail.comwrote:
Hi,
I was getting the error: sqlcode: -911 sqlstate: 40001 , which is
"The maximum number of lock requests has been reached for the
database."
So i increased the locklist size to 200 from the default value of 100.
I wanted to know what other effects it will have on the database?
Like, will the performance reduce, if the locklist size is 200 and 120
locks are on it as compared to when the locklist size is 130 and 120
locks requests.
If yes, how can i try to improve the performance degradation caused by
increasing the locklist?
Also, when i run the command "db2 list applications", the number of
applications running is much less than 100, still it gives the above
error of locklist getting exceeded.
Thanks
Rahul
It seems like you got reason code 68 with sqlcode -911 which is for
locktimeout.
In case there are too many lock escalations (which you may find using
the snapshot monitor), then you should try increasing locklist
parameter. Following URL should help you out more http://publib.boulder.ibm.com/infoce...n/r0000267.htm
Regards
Saurabh
On Aug 22, 12:33 pm, spider007 <saurabh.saurab hj...@gmail.com wrote:
On Aug 22, 10:25 am, Rahul B <rahul.babb...@ gmail.comwrote:
Hi,
I was getting the error: sqlcode: -911 sqlstate: 40001 , which is
"The maximum number of lock requests has been reached for the
database."
So i increased the locklist size to 200 from the default value of 100.
I wanted to know what other effects it will have on the database?
Like, will the performance reduce, if the locklist size is 200 and 120
locks are on it as compared to when the locklist size is 130 and 120
locks requests.
If yes, how can i try to improve the performance degradation caused by
increasing the locklist?
Also, when i run the command "db2 list applications", the number of
applications running is much less than 100, still it gives the above
error of locklist getting exceeded.
Thanks
Rahul
It seems like you got reason code 68 with sqlcode -911 which is for
locktimeout.
In case there are too many lock escalations (which you may find using
the snapshot monitor), then you should try increasing locklist
parameter. Following URL should help you out morehttp://publib.boulder. ibm.com/infocenter/db2luw/v8/index.jsp?topic =/c...
Regards
Saurabh
Yes,
I have increased it.
I wanted to know if there will be any performance issues/other issues
that might come up with increasing this parameter.
Rahul
"Rahul B" <ra***********@ gmail.comwrote in message
news:11******** *************@x 40g2000prg.goog legroups.com...
I have increased it.
I wanted to know if there will be any performance issues/other issues
that might come up with increasing this parameter.
Rahul
Unless you have a read only database (data warehouse), you should increase
it to 4096. The default is 100, but I believe that has not changed since
1990.
Having a larger locklist helps prevent lock escalation from row to table
level. Table level locking is more efficient in theory (because DB2 does not
have to keep track of locks on each row), but has poor concurrency if rows
are being inserted, updated, or deleted. Even though table level locking may
be faster than locking every row (strictly in terms of CPU utilization), DB2
can lock rows in locklist memory very efficiently and it is rarely a
problem.
Getting a -911 or having long lock wait times (which you may not be seeing
if the locktimeout parm is not exceeded) is usually a MUCH bigger
performance problem in terms of total execution time of SQL statements.
Increase it to 4096.
On Aug 22, 4:56 am, Rahul B <rahul.babb...@ gmail.comwrote:
On Aug 22, 12:33 pm, spider007 <saurabh.saurab hj...@gmail.com wrote:
On Aug 22, 10:25 am, Rahul B <rahul.babb...@ gmail.comwrote:
Hi,
I was getting the error: sqlcode: -911 sqlstate: 40001 , which is
"The maximum number of lock requests has been reached for the
database."
So i increased the locklist size to 200 from the default value of 100.
I wanted to know what other effects it will have on the database?
Like, will the performance reduce, if the locklist size is 200 and 120
locks are on it as compared to when the locklist size is 130 and 120
locks requests.
If yes, how can i try to improve the performance degradation caused by
increasing the locklist?
Also, when i run the command "db2 list applications", the number of
applications running is much less than 100, still it gives the above
error of locklist getting exceeded.
Thanks
Rahul
It seems like you got reason code 68 with sqlcode -911 which is for
locktimeout.
In case there are too many lock escalations (which you may find using
the snapshot monitor), then you should try increasing locklist
parameter. Following URL should help you out morehttp://publib.boulder. ibm.com/infocenter/db2luw/v8/index.jsp?topic =/c...
Regards
Saurabh
Yes,
I have increased it.
I wanted to know if there will be any performance issues/other issues
that might come up with increasing this parameter.
Rahul- Hide quoted text -
- Show quoted text -
In general, increasing the locklist parameter will not have any
negative performance impact. That being said, there are some rare
situations where we've seen increases in the locklist parameter which
cause performance degredations. Let my try to explain how this can
happen.
Increasing the locklist parameter increases the amount of locks that
are available to the database. This serves to reduce the probability
that a lock escallation will occur. Of course, if the number of rows
that need to be locked for any given query is larger than the locks
available in the locklist then lock escallation is inevitable.
Peformance problems can occur if the database thinks it can avoid an
escallation and tries to perform row locking for one or more tables.
Then, midway through acquiring row locks, it realizes that there
aren't enough locks available and so it must release all of the
already acquired row locks and acquire a table lock. If, with a
smaller locklist, it would have acquired a table lock directly, the
performance impact is in acquiring and releasing all of the row locks.
Adam This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Steve Jorgensen |
last post by:
== On Error Resume next, and Err.Number ==
If you want to call one of your procedures from another procedure, and check
for errors afterward, you mayimagine that you should write code something like
this...
On Error Resuse Next
MyFoo 123
lngErrNum = Err.Number
On Error Goto 0
|
by: Lauren Quantrell |
last post by:
I have constructed the following code that simulates the common
rollover effect when moving the mouse over a label (this example makes
the label bold.)
I'm wondering if anyone has come up with a better solution.
lq
'start code:
|
by: Mantorok Redgormor |
last post by:
Can emulation of the logical OR be done in standard C to obfuscate its
use? So I don't have to use if(a||b) but instead make that even more
obfuscated without its use but testing the same condition
|
by: Niklaus |
last post by:
This is one of the posts that i got.
------------------------------
A "side effect" of an operation is something that
*happens*, not something that *is produced*. Examples:
In the expression 2+2, the value 4 *is produced*. Nothing
*happens*.
Thus, 4 is the value of the expression, and it has no side effects.
In the expression g=2.0, the value 2.0 is produced. What *happens*
is that 2.0 is assigned to g. Thus, 2.0 is the value of the...
|
by: Joe Lester |
last post by:
I installed Postgres 7.4.1 on a dual processor G5 running Mac OS
10.3.2. I'm trying to increase the max_connections to 300 and running
into some trouble. If anyone could shed some light, I'd greatly
appreciate it.
Here's part of my postgresql.conf:
# - Connection Settings -
tcpip_socket = true
max_connections = 300
| |
by: cwdjrxyz |
last post by:
There have been fancy dhtml text effects since the early days of
javascript. The rainbow text effect was one of the early ones. While
some such effects may be fun on private pages, they can easily become
obnoxious, especially on commercial sites. To a large extent, dhtml
text effects have been replaced by flash, likely because the flash
effects often are more easy to make for many people.
How bad can a dhtml text effect be? Many of you...
|
by: saran |
last post by:
I'm hoping someone can clarify the side-effects of setting the
innodb_locks_unsafe_for_binlog parameter for me.
I'm running a fairly standard web application hitting a MySQL 5.0
backend, currently using the default transaction isolation level of
repeatable-read. We're seeing a fair amount of lock contention, and
think it would be safe to move down to read-committed. We also want to
disable next-key locking as this also causes some...
|
by: Senthil |
last post by:
Hi,
Whenever i read a C++ book or a newsgroup posting, i come across the
terms like " before the side effects completes" , "destructor with
side effects" etc. What is this side effect mean in C++ world?
Is it like something that is not desired but happens automatically and
we cannot prevent it?
Would be great if someone throws light on this.
Thanks,
|
by: Academia |
last post by:
I get the following watch message:
tsSource.Text.ToUpper() This expression causes side effects and will
not be evaluated string
The Text is &Edit
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
| |