Hi All,

I had a Redhat 7.3 with Pervasive.SQL v8.5 server. I've one concern
about this installation, When I connect my Pervasive Monitor that is
on a windows machine and check on Resource Usage I see that File
Handles is set only at 200 Maximum on the RedHat machine. The
/var/log/messages of the RedHat is showing this kind of messages
"mkded: Cannot set file handle limit 1024, the current limit is 1024."

I beleived that File Handle seetings is being handled dymanically by
Pervasive. but with only 200 is set I think I'm gonna have a problem
with this.

Is this a bug on Pervasive v8?

Thanks

The number of files is dynamic on all Pervasive.SQL V8 environments. You
should be able to ignore this "maximum setting".
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: March, 2004: See our web site for details!


jhun bacala wrote:

While you can ignore the maximum setting for Pervasive as the database
engine is dynamic, Linux will enforce the file handle limit of 1024.
With overhead this works out to be around 1000 physical database
files.
If you need more (not likely but possible) you will need to add a
ulimit statement to increase the OS limit in the
/etc/rc.d/init.d/psql
startup script.

Leonard

On 24 Feb 2004 11:02:05 EST, Bill Bach <bbach (AT) cncdsl (DOT) com> wrote:

Thanks Bill


Bill Bach <bbach (AT) cncdsl (DOT) com> wrote

Hi Leonard,

I'm very much interested on your suggestion, perhaps you can show me
how to add a ulimit statement in the /etc/rc.d/init.d/psql

Thanks

Jhun Bacala


Leonard <lharvey (AT) austin (DOT) rr.com> wrote

I just added a
ulimit -n <number of files>
to the
/etc/rc.d/init.d/psql
in the
start_psql()
section. I threw mine in after the
fi
echo mkded

Leonard

On 25 Feb 2004 18:19:22 -0800, jhun.bacala (AT) nccc (DOT) com.ph (jhun bacala)
wrote: