INTERBASE
Nancy Tietz
ntietz@MCARE.MED.UMICH.EDU
Wed, 7 May 2003 10:19:59 -0400
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C314A3.BDD789F0
Content-Type: text/plain;
charset="iso-8859-1"
'lock manager out of room'
Or, in our case where we don't have a room to lock the manager out of, you
can always try to convince her to take a day off.
<just kidding>
nt
-----Original Message-----
From: Fry, Mark [mailto:Mark.Fry@COGNOS.com]
Sent: Wednesday, May 07, 2003 9:53 AM
To: 'Jeff Hoffman'; powerh-l@lists.swau.edu
Subject: RE: INTERBASE
Hi Jeff,
It's been a long long time, but I used to use Interbase 4.0 on HP-UX a few
years ago. Here are some random thoughts (or ramblings of a senile old
fool, as the case may be :-)
I seem to recall that 'lock manager out of room' messages were to do with
the configuration settings in isc_config under /usr/interbase.
>From memory, the V4-LOCK_MEM_SIZE setting is the one to increase, but I
think you need to check the unix kernel to make sure you do not exceed the
shmsize set in there.
The other option to check is (I think) V4_LOCK_SEM_COUNT, which controls the
number of semaphores used by the lock header, but again make sure that this
does not exceed the max number of semaphores configured in the kernel.
Has this database been running OK then mysteriously started giving problems,
or has something on the system changed to cause the problem? Did you try
backing up the database using gbak then restoring it? Did you check to see
if the database sweep (which finds and deletes old record versions) has been
running?
Check that the database file has not exceeded 2Gb too. If you're still
struggling, you may want to try the ibphoenix web site to see if any other
InterBase users have seen and fixed your problem. (
http://www.ibphoenix.com <http://www.ibphoenix.com> )
Good luck!
Mark Fry
Mark.Fry@Cognos.com <mailto:Mark.Fry@Cognos.com>
-----Original Message-----
From: Jeff Hoffman [mailto:wonicon@optushome.com.au]
Sent: 06 May 2003 23:34
To: powerh-l@lists.swau.edu
Subject: RE: INTERBASE
Hi
I do not think that they have done any. I have not been reponsible for the
site for over 5 years.
I was just hoping somebody may have done something recently that could help.
Jeff
At 01:20 PM 06-05-03 -0400, Christina wrote:
>>>>
Hi Jeff,
Can you please advise whether you have done any kind of performance and
tuning with the database?
If so, what type?
Regards,
Christina Hasse
ADT North American Technical Manager
COGNOS CORPORATION
christina.hasse@cognos.com
425 N. Martingale Road, Suite 600
Schaumburg, IL 60173
Office: 847 - 285 - 2905
Cell: 847 - 269 - 1909 (new)
Fax: 847 - 240 - 0252
-----Original Message-----
From: Jeff Hoffman
[<mailto:wonicon@optushome.com.au>mailto:wonicon@optushome.com.au]
Sent: Tuesday, May 06, 2003 10:44 AM
To: powerh-l@lists.swau.edu
Subject: INTERBASE
Hi
Sorry I forgot : Interbase V4 on HP9000 (HPUX).
My old site is having trouble:
Fatal lock manager - lock manager out of room.
this is not the exact message but is close.
They increased the number of locks by a huge amount and the system is
running, but verrrry slowly.
Can anybody out there suggest something to improve performance?
Sorry I do not have much info, but your suggestions would be appreciated.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+
+ Jeff Hoffman + e-mail: wonicon@optushome.com.au +
+ Director + +
+ WoniCon Pty Ltd (ABN 93 083 502 630)+ ,-_|\ +
+ 21 Prices Circuit + voice: +61 2 9542 1527 / \ +
+ Woronora NSW 2232 + \_,-._* +
+ AUSTRALIA + mobile: 040 790 3929 v +
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+ = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l@lists.swau.edu Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu Unsubscribe: "unsubscribe " in message body
to powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l This list is closed, thus to
post to the list you must be a subscriber.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
------_=_NextPart_001_01C314A3.BDD789F0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE></TITLE>
<META content="MSHTML 6.00.2713.1100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><STRONG>'lock manager out of
room'</STRONG> </FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=265571514-07052003><FONT face=Arial color=#0000ff size=2>Or, in
our case where we don't have a room to lock the manager out of, you can always
try to convince her to take a day off.</FONT></SPAN></DIV>
<DIV><SPAN class=265571514-07052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=265571514-07052003><FONT face=Arial color=#0000ff
size=2><just kidding></FONT></SPAN></DIV>
<DIV><SPAN class=265571514-07052003><FONT face=Arial color=#0000ff
size=2>nt</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Fry, Mark
[mailto:Mark.Fry@COGNOS.com]<BR><B>Sent:</B> Wednesday, May 07, 2003 9:53
AM<BR><B>To:</B> 'Jeff Hoffman'; powerh-l@lists.swau.edu<BR><B>Subject:</B>
RE: INTERBASE<BR><BR></FONT></DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff size=2>Hi
Jeff,</FONT></SPAN></DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff size=2>It's
been a long long time, but I used to use Interbase 4.0 on HP-UX a few years
ago. Here are some random thoughts (or ramblings of a senile old fool,
as the case may be :-)</FONT></SPAN></DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff size=2>I
seem to recall that 'lock manager out of room' messages were to do with the
configuration settings in isc_config under /usr/interbase.</FONT></SPAN></DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff size=2>From
memory, the V4-LOCK_MEM_SIZE setting is the one to increase, but I think you
need to check the unix kernel to make sure you do not exceed the shmsize set
in there.</FONT></SPAN></DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff size=2>The
other option to check is (I think) V4_LOCK_SEM_COUNT, which controls the
number of semaphores used by the lock header, but again make sure that this
does not exceed the max number of semaphores configured in the
kernel.</FONT></SPAN></DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff size=2>Has
this database been running OK then mysteriously started giving problems,
or has something on the system changed to cause the problem? Did you try
backing up the database using gbak then restoring it? Did you check to
see if the database sweep (which finds and deletes old record versions) has
been running? </FONT></SPAN></DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff
size=2>Check that the database file has not exceeded 2Gb too. If you're
still struggling, you may want to try the ibphoenix web site to see if
any other InterBase users have seen and fixed your problem. (<A
href="http://www.ibphoenix.com">http://www.ibphoenix.com</A>)
</FONT></SPAN></DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff size=2>Good
luck!</FONT></SPAN></DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff size=2>Mark
Fry</FONT></SPAN></DIV>
<DIV><SPAN class=418082012-07052003><FONT face=Arial color=#0000ff size=2><A
href="mailto:Mark.Fry@Cognos.com">Mark.Fry@Cognos.com</A></FONT></SPAN></DIV><SPAN
class=418082012-07052003></SPAN><FONT face=Tahoma>
<DIV><BR><FONT size=2><SPAN
class=418082012-07052003> </SPAN>-----Original
Message-----<BR><B>From:</B> Jeff Hoffman
[mailto:wonicon@optushome.com.au]<BR><B>Sent:</B> 06 May 2003
23:34<BR><B>To:</B> powerh-l@lists.swau.edu<BR><B>Subject:</B> RE:
INTERBASE<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P>Hi </P><BR>
<P>I do not think that they have done any. I have not been reponsible for
the site for over 5 years. </P><BR>
<P>I was just hoping somebody may have done something recently that could
help. </P><BR>
<P>Jeff </P><BR>
<P>At 01:20 PM 06-05-03 -0400, Christina wrote: </P>
<P>>>>> </P><BR>
<P><FONT size=2>Hi Jeff,</FONT> </P><BR>
<P><FONT size=2>Can you please advise whether you have done any kind of
performance and tuning with the database?</FONT> </P><BR>
<P><FONT size=2>If so, what type?</FONT> </P><BR>
<P><FONT size=2>Regards,</FONT> </P><BR>
<P><FONT size=2>Christina Hasse</FONT> </P>
<P><FONT size=2>ADT North American Technical Manager</FONT> </P>
<P><FONT size=2>COGNOS CORPORATION</FONT> </P>
<P><FONT size=2>christina.hasse@cognos.com</FONT> </P>
<P><FONT size=2>425 N. Martingale Road, Suite 600</FONT> </P>
<P><FONT size=2>Schaumburg, IL 60173</FONT> </P>
<P><FONT size=2>Office: 847 - 285 - 2905</FONT> </P>
<P><FONT size=2>Cell: 847 - 269 - 1909 (new)</FONT> </P>
<P><FONT size=2>Fax: 847 - 240 - 0252</FONT> </P><BR><BR>
<P><FONT size=2>-----Original Message-----</FONT> </P>
<P><FONT size=2>From: Jeff Hoffman
[<mailto:wonicon@optushome.com.au>mailto:wonicon@optushome.com.au]</FONT>
</P>
<P><FONT size=2>Sent: Tuesday, May 06, 2003 10:44 AM</FONT> </P>
<P><FONT size=2>To: powerh-l@lists.swau.edu</FONT> </P>
<P><FONT size=2>Subject: INTERBASE</FONT> </P><BR><BR>
<P><FONT size=2>Hi</FONT> </P><BR>
<P><FONT size=2>Sorry I forgot : Interbase V4 on HP9000 (HPUX).</FONT>
</P><BR>
<P><FONT size=2>My old site is having trouble:</FONT> </P><BR>
<P><FONT size=2>Fatal lock manager - lock manager out of room.</FONT> </P>
<P><FONT size=2>this is not the exact message but is close.</FONT> </P><BR>
<P><FONT size=2>They increased the number of locks by a huge amount and the
system is</FONT> </P>
<P><FONT size=2>running, but verrrry slowly.</FONT> </P><BR>
<P><FONT size=2>Can anybody out there suggest something to improve
performance?</FONT> </P><BR>
<P><FONT size=2>Sorry I do not have much info, but your suggestions would be
appreciated.</FONT> </P><BR><BR>
<P>+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
</P>
<P>+ Jeff Hoffman + e-mail: wonicon@optushome.com.au + </P>
<P>+ Director + + </P>
<P>+ WoniCon Pty Ltd (ABN 93 083 502 630)+ ,-_|\ + </P>
<P>+ 21 Prices Circuit + voice: +61 2 9542 1527 / \ + </P>
<P>+ Woronora NSW 2232 + \_,-._* + </P>
<P>+ AUSTRALIA + mobile: 040 790 3929 v + </P>
<P>+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l@lists.swau.edu Subscribe: "subscribe" in message body to
powerh-l-request@lists.swau.edu Unsubscribe: "unsubscribe " in message body
to powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l This list is closed, thus to
post to the list you must be a subscriber.</P></BLOCKQUOTE><BR>
<P><FONT face=Arial size=2>This message may contain privileged and/or
confidential information. If you have received this e-mail in error or are not
the intended recipient, you may not use, copy, disseminate or distribute it;
do not open any attachments, delete it immediately from your system and notify
the sender promptly by e-mail that you have done so. Thank
you.</FONT></P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C314A3.BDD789F0--