What should be the Kernel parameter settings to avoid "Cannot open file error 23 :43"

[Usha_2]

Hi,

Can anyone let me know the Kernel Parameter values required to avoid the folllowing error:
Cannot find or open file /u03/pilot/eb2/atadmp_10.d2, errno = 23. (43)

This error occured when 59 users were logged in the database and the 60th user was trying to log in.
This was a test environment. In production environmnent the actual no of users will be around 90-95.

OS: HP Unix 11
Progress: Ver 9.1D
MFG/Pro : EB2

Current Kernel Parameter Settings:
STRMSGSZ 65535
dnlc_hash_locks 512
maxdsiz_64bit 0X40000000
maxfiles 2048
maxfiles_lim 2048
maxssiz 0X800000
maxssiz_64bit 0X800000
maxswapchunks 2048
maxtsiz 0X4000000
maxtsiz_64bit 0X40000000
maxusers 200
nfile 12008
nflocks 4096
nproc 2816
npty 512
nstrpty 512
nstrtel 512
semmni 3320
semmns 6640
semmnu 660
semume 64
shmmax 1024000000
shmmni 512
shmseg 200
ninode 3256 - ((NPROC+16+MAXUSERS)+32+(2*NPTY))


Rgds,
Usha

[Tom Geudens]

Hi Usha,
Forgive me for asking the obvious, but the kernelparameters look (at first sight) to be ok, so here goes :
- The stated file does really exist ?
- The number of allowed sessions (on the database) isn't exceeded ?

Can you post the exact messages from the alertfile (or is the above all you get) ? Is there a tracefile in the "udump" directory ?

Regards,
Tom Geudens

[Usha_2]

Hi Tom,

Yes the stated files do exist.
These files are part of the MFg/Pro Progress database.

And the number of users allowed to the database is 100.

This is the only error message that appears on the screen.
(though the same is repeated for all the database extent files).
And then the database gets disconnected and even the exisitng users are thrown out of the database.

Regards,
Usha

[Massimo Bianchi · Accepted solution]

Hi,

#define ENFILE 23 /* File table overflow */


So it looks like you have to increase nfile and, consequently, nflocks.

I suggest a +20% in each.

Check the actual use with


sar -v 3 1000

during the day and after decide.

Massimo

[Usha_2]

Hi,

Thanks a lot for the response.

I increased the NFILE value to 17000 and now upto 95 users can log in without any issues.

However, I did not try to increase the value for nflock.

Regards,
Usha