A customer of mine has one or two times a month an error 11400
(too many open files).

They are running Triton2.2d with bisam on a HP-UX.
Now I want to change the parameters in bisamconfig, so is there some documentation about this subject. Further had I also to change some other parameters (ulimit etc.)?

Jan,

I never worked with Triton2.2d version. I found info in the tools manual, they might be valid for your BaaN version.

104 ETOOMANY - Too many files open
--------------------------------------------------------------------------------
Description:
This error indicates too many tables are open.
Solution:
If you use the BAAN Base database increase the MAXOPENF parameter.

24 EMFILE - Too many open files
--------------------------------------------------------------------------------
Description:
This error indicates that too many file descriptors are open. No user is allowed to open any file.
Solution:
No process can have more than 20 file descriptors open at a time. Ask your system administrator to change the following parameters to increase the number of open files that is allowed:
The NOFILES parameter, which defines the maximum number of open files per process and must have minimum value of 256. Preferably more.
The NFILE parameter, which defines the number of open files in Baan and must have minimum value of NOFILES * BAAN User License * 3 + 100. Preferably more

Jan,

from the Baan Tools Help for Database Driver "Baan Base" (but from BaanIV)

Parameters tbase/tbase_tp
MAXOPENF
Maximum number of BAAN Base(TP) tables which may be used by one database server. Exceeding this limit will generate error 11400. The value of MAXOPENF must be less than FILES.

Default: MAXOPENF = 500

Juergen

Thanks for all information. Here the parameters in the bisamconfig file:

PROCESSES = 208
LOCKS = 25200
FILES = 2400
IDXDESC = 3600
4KBUFFERS = 1500
WATERMARK = 500
MAXOPENF = 2048
BMANAGER_INT = 60
LOCK_RESOURCE = 24200
TRANSTBL = 2400
LOGBUFS = 10
LOGMARK = 6
SWAPBUF = 75
SWAPWATER = 25
RES_RIMG = 14400
RIMG_RESOURCE = 7200
RES_COMMIT = 410
RES_RI_ADDR = 36000
RES_IDX_TREE = 2880
RES_SWAP_IDX = 5050
RES_KEY_POOL = 2880000
NOTRCHKP = 750
WATCHDOG_INT = 120


They have 48 licented users.
Depending on the information I want to change
MAXOPENF = 4096
FILES = 4800

Must/Can I also change other parameters?

Jan,

if they work with only one Baan company then the setting for Files = 4800 is o.k for me. If they work with more companies then I would increase the value for Files (for example Files = 10000).

The maximum number of index descriptions should be calculated by
IDXDESC = 2 * Files

so in your case IDXDESC = 9600


If they work with Baan TP then,
TRANSTBL = 2 * FILES
RES_IDX_TREE = 0.6 * TRANSTBL
RES_RI_ADDR = 5 * RES_IDX_TREE
RES_RIMG = RES_RI_ADDR/2
RIMG_RESOURCE = RES_RIMG/1.5


Hope this helps a little,
Rgds,
Juergen

Juergen,

They have (don't be shocked) about 150 companies. They have a kind of Multi Finance / Single Project this is done by linking under Unix all project and other relevant files.
So I think it is a good idea to increase the value for FILES much higher as my first proposal.

At last they are using bisam

great, never seen such a setup:-)

But if the error only occurs one or two times per month with 150 companies(!), then they have some kind of very special setup as you wrote. So I would begin with setting the value for Files to 5000 (or maybe 10000) and see what happens.

Rgds,
Juergen

Did you ever checked the kernel settings?

Normally bisam closes files and/or should open a driver if you need more open files. However perhaps you are running into a system wide setting for maximun number of open files?

Rgrds,
Han

Well,

Today changed the parameters, till now no errors.

Thanks for all who helped me.