IBM Netezza uses ports for nzsql CLI commands, JDBC, ODBC connections and nzadmin tool. The IBM Netezza system uses the following port numbers or environmental variables for the CLI commands and the NzAdmin tool. In this article, we will check Netezza default port numbers and corresponding environment variables.
Netezza Default Port Numbers and Corresponding Environment Variables
The following table lists the default ports and corresponding environment variables:
| Port # | Environment Variables | Description |
| 5480 | NZ_DBMS_PORT | The postgres port for the nzsql command, NzAdmin ODBC, and JDBC. |
| 5481 | NZ_CLIENT_MGR_PORT | The port for the CLI and NzAdmin tool messaging. |
| 5482 | NZ_LOAD_MGR_PORT | This port is not required in latest release. |
| 5483 | NZ_BNR_MGR_PORT | The port for the nzbackup and nzrestore |
Netezza SSH and FTP Ports
Below are the port for SSH and FTP connections:
Netezza SSH Port
By default, you can use the port 22 for SSH connection (putty) if remote service access is granted to connect to Netezza server.
Netezza FTP Ports
By default, you can use the port 20 and 21 for FTP connection if remote service access is granted to connect to Netezza server.
Changing Default Port Numbers in Netezza
You can change the default port numbers in Netezza. You should be a Netezza administrator or nz user to change the default ports.
Note that, be careful when you are changing the port numbers for the Netezza database access. Errors can severely affect the operation of the Netezza system. If you are not familiar with editing resource shell files or changing environment variables, contact IBM Netezza Support for assistance.
Procedure to Change Default Port Numbers in Netezza
Before changing the port, first, you should verify if the port is already being used by other process. To check the port numbers, you can review the /etc/services file to see whether the port number is specified for another process.
Steps:
- Login to Netezza server as nz user
- Change to the /nz/kit/sys/init
- Create a backup of the current nzinitrc.sh file
[nz@nzp01 init]$ cp nzinitrc.sh nzinitrc.sh.backup
- Review the nzinitrc.sh file. To define a variable in the nzinitrc.sh file,
use the format NZ_DBMS_PORT=newvalue; export NZ_DBMS_PORT.