Re: Lock table overflow
--0__=88BBE51EDFC1B3BC8f9e8a93df938690918c88BBE51EDFC1B3BC
Content-type: multipart/alternative;
Boundary="1__=88BBE51EDFC1B3BC8f9e8a93df938690918c88BBE51EDFC1B3BC"
--1__=88BBE51EDFC1B3BC8f9e8a93df938690918c88BBE51EDFC1B3BC
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
As the message suggests ..the lock table overflow happened ..Depending =
on
the version of the engine IDS will automatically add more memory for th=
e
locklist till 8 million locks.
Check out the onstat -k output and try to identify if the locks are bei=
ng
held by a session and are not required .. or you just need to increase =
the
value of LOCKS in the ONCONFIG.
HTH
Thanx much,
Rajib Sarkar
Advisory Software Engineer
DB2/UDB Regional Advanced Support
If we all did the things we are capable of doing, we would literally
astound ourselves. -- T. Edison
=
"LUQUE Valdivia =
Omar" =
<luque001@marina. =
To
mil.pe> <informix-list@iiug.org> =
Sent by: =
cc
owner-informix-li =
st@iiug.org Subj=
ect
Lock table overflow =
=
01/18/2005 07:02 =
AM =
=
=
=
Hi everyone,
I have observed that problem:
02:04:14 Lock table overflow - user id 1, session id 9425
02:04:14 Lock table overflow - user id 1, session id 9425
02:04:14 Lock table overflow - user id 1, session id 9425
What Happend?
Please, Help me
Thanks
Omar.
sending to informix-list
=
--1__=88BBE51EDFC1B3BC8f9e8a93df938690918c88BBE51EDFC1B3BC
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>As the message suggests ..the lock table overflow happened ..Dependi=
ng on the version of the engine IDS will automatically add more memory =
for the locklist till 8 million locks. <br>
<br>
Check out the onstat -k output and try to identify if the locks are bei=
ng held by a session and are not required .. or you just need to increa=
se the value of LOCKS in the ONCONFIG.<br>
<br>
HTH<br>
<br>
Thanx much,<br>
<br>
Rajib Sarkar<br>
Advisory Software Engineer<br>
DB2/UDB Regional Advanced Support<br>
<br>
<br>
If we all did the things we are capable of doing, we would literally as=
tound ourselves. -- T. Edison<br>
<br>
<img src=3D"cid:10__=3D88BBE51EDFC1B3BC8f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "LUQUE Valdivi=
a Omar" <luque001@marina.mil.pe>">"LUQUE Valdivia Omar&=
quot; <luque001@marina.mil.pe><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE51=
EDFC1B3BC8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"LUQUE Valdivia Omar" <luque001@ma=
rina.mil.pe></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: owner-informix-list@iiug.org</font>
<p><font size=3D"2">01/18/2005 07:02 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE51EDFC1B3BC8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE51EDFC1B3BC8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2"><informix-list@iiug.org></font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE51EDFC1B3BC8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE51EDFC1B3BC8f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE51EDFC1B3BC8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D88BBE51EDFC1B3BC8f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">Lock table overflow</font></td></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE51EDFC1=
B3BC8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE51EDFC1B3BC8f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Hi everyone,<br>
<br>
I have observed that problem: <br>
<br>
02:04:14 Lock table overflow - user id 1, session id 9425<br>
02:04:14 Lock table overflow - user id 1, session id 9425<br>
02:04:14 Lock table overflow - user id 1, session id 9425<br>
<br>
What Happend? <br>
<br>
Please, Help me<br>
<br>
Thanks<br>
<br>
<br>
<br>
Omar.<br>
<br>
<br>
sending to informix-list<br>
</tt><br>
</body></html>=@