on 02-06-2014 6:09 AM
I have two servers for IQ, WRITER and READER. I have implemented multiplexing on it.
Multiplexing is running smoothly. I checked by connecting both servers indivisualy using ISQL, both servers WRITER and READER are connecting and working fine.
But whenever I tried to execute any command on host machine (on linux), it is giving me error / message as "resources not available". After then if i killed process for Sybase IQ server (using another session) on READER, I can properly execute any command on linux host.
I am not sure wether the problem is of Linux host or multiplexing setup.
Linux Version : 2.6.32-279.el6.x86_64 #1 SMP Wed Jun 13 18:24:36 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
Sybase IQ Version : Sybase IQ/15.3.0.6056/110506/P/GA/Enterprise Linux64 - x86_64 - 2.6.9-67.0.4.ELsmp/64bit/2011-05-06 13:27:43
Is there anything that I have to change on linux server? or in multiplexing setup?
Waiting for reply.
Thanks,
We have as of now following setting on /etc/security/limits.conf
sybase soft nproc 1392
sybase hard nproc 2784
Is it sufficient or I need to increase it?
We have 32 CPU's on the servers in which i have assigned 20 CPU's for IQ using configuration file.
-iqnumbercpus 20
I am going to increase no of CPU's to 25 - 30 in future.
Accordingly what changes i have to make on linux host? Do I need to increase soft and hard nproc on host?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check out the Linux Release Bulletin known issues section. This is a redhat 6 configuration change that requires modification of the OS to work.
sybase soft nproc 7712 -- The soft limit allows for 2 servers on the 64-core system plus 1024 default.
sybase hard nproc 16384 -- Powers of 16 work well for kernel and engine settings. (1024 * 16) is rounded up for extra space.
You can increase the soft limit, but the hard limit is the threshold for the value unless raised by a privileged user limit.
To set limits for all users instead of the sybase user, replace sybase with *, for example:
* soft nproc 7712
* hard nproc 16384
ulimit –u 7712
#* soft nproc 1024
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.