Filippo wrote:

>> Show us the isc_config file. There might be a syntax error.

>
> V4_LOCK_MEM_SIZE 196068
> ANY_LOCK_MEM_SIZE 98304

The V4_LOCK_MEM_SIZE value only applies to Version 4. You need to set
ANY_LOCK_MEM_SIZE to a value greater than the default.

>>
>> You might also want to say which version of Red Hat you are working
>> with.

> You're right. I'm using a RH 8. I'v installed it by selecting the
> "standard workstation" configuration (I don't remember the exact
> name). But I remember that a few months ago I had the same problem
> with previous versions of RH and with Mandrake Linux 8. In all these
> cases I selected, during installation, one of the standard
> "installation profiles", the one named "workstation" (or similar).

I'm not familiar with RH 8, but I must confess that I have never had a
problem with the lock manager being out of room. How many users are
attached to the database when this happens? I would suspect that there
is something about your application that is causing a lot of (possibly
unnecessary) locking.


Paul
--

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase