Non-default Netezza Performance Server port numbers for clients

If Netezza Performance Server non-default port numbers, your client users must specify the port number when they connect by using commands such as nzsql, nzload. For example, if you change the NZ_DBMS_PORT number from the default of 5480, your client users must specify the new port value, otherwise their commands return an error that they cannot connect to the database server at port 5480.

Some Netezza Performance Server commands such as nzsql and nzload have a -port option that allows the user to specify the DB access port. In addition, users can create local definitions of the environment variables to specify the new port number.

For example, on Windows clients, users can create an NZ_DBMS_PORT user environment variable in the System Properties > Environment Variables dialog to specify the non-default port of the Netezza Performance Server system.

For a Linux® system, you can define a session-level variable by using a command similar to the following format:

$ NZ_DBMS_PORT=5486; export NZ_DBMS_PORT

For the instructions to define environment variables on your Windows, Linux, or UNIX client, see the operating system documentation for your client.

If a client user connects to multiple Netezza Performance Server hosts that each use different port numbers, those users might have to use the -port option on the commands as an override, or change the environment variable value on the client before they connect to each Netezza Performance Server host.