issue:
we have done some maintanance on Netezza 7.0 and after maintenance we are unable to start the Netezza database,it throws the below error,while starting the NPS.
nz@<server_name>:/export/home/nz> nzstart
ERROR: System limit for 'nofile' is too low (1024); must be 9600
ERROR: System limit for 'nice' is too low (0); must be 20
nz@<server_name>:/export/home/nz> nzstate
System state is 'Stopped'.
Solution:
when we check the log,we dont have anything on sysmgr.log,because ,it not even started HW components like SPU & DISK,Then we relaised the ulimit value would be small to startup the system and increased the ulimit and issue resolved.
However to increase the ulimit on the Netezza server you may need root privilege to update the new value on the server.
This is happened because our NPS got failover to HA2 and we never had HA2 as active server and this server does not have sufficient ulimit value and fixed later.
ulimit -n 9600
we have done some maintanance on Netezza 7.0 and after maintenance we are unable to start the Netezza database,it throws the below error,while starting the NPS.
nz@<server_name>:/export/home/nz> nzstart
ERROR: System limit for 'nofile' is too low (1024); must be 9600
ERROR: System limit for 'nice' is too low (0); must be 20
nz@<server_name>:/export/home/nz> nzstate
System state is 'Stopped'.
Solution:
when we check the log,we dont have anything on sysmgr.log,because ,it not even started HW components like SPU & DISK,Then we relaised the ulimit value would be small to startup the system and increased the ulimit and issue resolved.
However to increase the ulimit on the Netezza server you may need root privilege to update the new value on the server.
This is happened because our NPS got failover to HA2 and we never had HA2 as active server and this server does not have sufficient ulimit value and fixed later.
ulimit -n 9600
No comments:
Post a Comment