Skip to content

Posts tagged ‘maxConnections’

How to increase Max connection limit – Netezza

To change to the parameter startup.maxConnections, please note that downtime is required.

1) Check the setting prior to change:
$ nzsystem showregistry| grep -i maxconn
startup.maxConnections =

2) Modify this line in the /nz/data/config/system.cfg file:
startup.maxConnections = 1000

* If the file is absent, you can create it as a new file and append the line into it.

3) Restart using ‘nzstop’ and ‘nzstart’

4) Check again to see if the setting has changed:
$ nzsystem showregistry| grep -i maxconn
startup.maxConnections = 1000