INTERBASE

Wed, 7 May 2003 14:52:35 +0100

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_01C3149F.E9E265F0
Content-Type: text/plain

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_01C3149F.E9E265F0
Content-Type: text/html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE></TITLE>

<META content="MSHTML 5.50.4725.2100" name=GENERATOR></HEAD>
<BODY>
<DIV>Hi 
Jeff,</DIV>
<DIV>&nbsp;</DIV>
<DIV>It's 
been a long long time, but I used to use Interbase 4.0 on HP-UX a few years 
ago.&nbsp; Here are some random thoughts (or ramblings of a senile old fool, as 
the case may be :-)</DIV>
<DIV>&nbsp;</DIV>
<DIV>I seem 
to recall that 'lock manager out of room' messages were to do with the 
configuration settings in isc_config under /usr/interbase.</DIV>
<DIV>&nbsp;</DIV>
<DIV>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.</DIV>
<DIV>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.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Has 
this database been running OK then&nbsp;mysteriously started giving problems, or 
has something on the system changed to cause the problem?&nbsp; Did you try 
backing up the database using gbak then restoring it?&nbsp; Did you check to see 
if the database sweep (which finds and deletes old record versions) has been 
running?&nbsp; </DIV>
<DIV>&nbsp;</DIV>
<DIV>Check 
that the database file has not exceeded 2Gb too.&nbsp; If you're still 
struggling, you may want to&nbsp;try the ibphoenix web site to see if any other 
InterBase users have seen and fixed your problem.&nbsp; (<A 
href="http://www.ibphoenix.com">http://www.ibphoenix.com</A>) 
</DIV>
<DIV>&nbsp;</DIV>
<DIV>Good 
luck!</DIV>
<DIV>&nbsp;</DIV>
<DIV>Mark 
Fry</DIV>
<DIV><A 
href="mailto:Mark.Fry@Cognos.com">Mark.Fry@Cognos.com</A></DIV>
<DIV> &nbsp;-----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 </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
 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: 
 &gt;&gt;&gt;&gt; 
 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 
 [&lt;mailto:wonicon@optushome.com.au&gt;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.</BLOCKQUOTE></BODY></HTML>

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_01C3149F.E9E265F0--