How to increase Netezza Max connection limit?

Reading Time: < 1 minute

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 missing, 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