Issuing commands

Deployment options: Netezza Performance Server for Cloud Pak for Data System Netezza Performance Server for Cloud Pak for Data

To issue an nz command, you must have access to the Netezza Performance Server system or you must install the Netezza Performance Server client kit on your workstation.

Netezza Performance Server for Cloud Pak for Data

Ports 5481, 5482 and 5483 are not exposed by default. You must install the nz remote command line to remotely run select Netezza commands in a secure way through TLS/SSL.

For more information, see Remote command-line nz.

While some of the nz commands can operate and display information without extra access requirements, some commands and operations require that you specify a Netezza Performance Server database user account and password. The account might also require appropriate access and administrative permissions to display information or process a command.

The following are several examples.

To display the state of a Netezza Performance Server system by using a Windows client command, run the following command:
```
C:\Program Files\Netezza Tools\Bin>nzstate show -host mynps -u user
-pw passwd
System state is 'Online'.
```

To display the valid Netezza Performance Server system states by using a Windows client command, run the following command:

C:\Program Files\Netezza Tools\Bin>nzstate listStates

State Symbol Description
------------ ------------------------------------------------------------
initialized  used by a system component when first starting
paused       already running queries will complete but new ones are queued
pausedNow    like paused, except running queries are aborted
offline      no queries are queued, only maintenance is allowed
offlineNow   like offline, except user jobs are stopped immediately
online       system is running normally
stopped      system software is not running
down         system was not able to initialize successfully

Note: In this example, you did not have to specify a host, user, or password. The command displayed information that was available on the local Windows client.

To back up a Netezza Performance Server database (you must run the command while logged in to the Netezza Performance Server system, as this is not supported from a client):
```
[nz@npshost ~]$ nzbackup -dir /home/user/backups -u user -pw
password -db db1
Backup of database db1 to backupset 20090116125409 completed
successfully.
```