Neville:
Modify the following file with the root account.
AIX : /etc/secuirty/limits
Linux : /etc/security/limit.conf
After editing the file, log in to that account and it will take effect.
Of course, if you see that the value has changed, you need to restart the program.
$ tail -20 /etc/security/limits
rss = -1
fsize = -1
db2i81:
core = -1
data = 491519
stack = 32767
rss = -1
fsize = -1
informix:
fsize = -1
core = -1
cpu = -1
data = -1
rss = -1
stack = -1
threads = 32767
nofiles = 32767
$ su - informix
/home/informix]ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 32767
threads(per process) 32767
processes(per user) unlimited
------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------
Original Message:
Sent: Wed February 26, 2020 11:55 PM
From: Neville Monteiro
Subject: File Descriptors for Connection Manager.
Hello Sir,
We will have to increase the "total number of file descriptors" and "total number of file descriptors per process" to 32767. Is there any way wherein we can get the values for these 2 parameters into effect right-a-away without a system restart ?
------------------------------
Neville Monteiro
------------------------------
Original Message:
Sent: Wed February 26, 2020 07:57 AM
From: Art Kagel
Subject: File Descriptors for Connection Manager.
Neville:
Yes, it could cause you problems down the road. You should increase the number of file descriptors total and per process in the OS to at least 32767, although in a production environment you may want to make that even higher, perhaps 65535 or more.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
Original Message------
Dear All,
On starting Informix Connection Managers, the following is written to the log file of Connection Managers :-
16:51:52 set the maximum number of file descriptors 32767 failed
16:51:52 the current maximum number of file descriptors is 1024
Even though the above message is written to its log file, the Connection Managers are still working fine.
Now, is the above message something to be worried about or can it be ignored ?
Thanks & Regards,
Neville Monteiro.
#Informix