Summary of command-line commands
The following table describes the commands that you can use to monitor and manage the Netezza Performance Server system. These commands are in the /nz/kit/bin directory on the Netezza Performance Server host. A subset of these commands is also installed with the Netezza Performance Server client kits and can be run from a remote client system, as described in Command locations.
To run these commands from the Netezza Performance Server system, you must be able to log in as a valid Linux® user on the Netezza Performance Server system. Most users typically log in as the nz user. In addition, many commands require that you to specify a valid database user account and password; the database user might require special privileges, as described in Command privileges. Throughout this section, some command examples show the database user and password options on the command line, and some examples omit them with the assumption that the user and password were cached such as by using nzpassword.
Netezza Performance Server for Cloud Pak for DataNetezza Performance Server for Cloud Pak for Data as a Service
Ports 5481, 5482, and 5483 are turned off. You must install the nz remote command line to remotely run Netezza Performance Server commands in a secure way through TLS/SSL.
| Command | Description | Reference |
|---|---|---|
| nzbackup | Backs up an existing database. | For command syntax and more information, see The nzbackup command. |
| nzcontents | Displays the revision and build number of all the executable files, plus the checksum of Netezza Performance Server binaries. | For command syntax, see The nzcontents command. For more information, see Software revision levels. |
| nzconvert | Converts character encodings for loading with the nzload command or external tables. | For command syntax, see The nzconvert command. |
| nzds | Manages and displays information about the data slices on the system. | For command syntax, see The nzds command. |
| nzevent | Displays and manages event rules. | For command syntax, see The nzevent command. For more information, see Event rules. |
| nzhistcleanupdb | Deletes old history information from a history database. | For command syntax, see The nzhistcleanupdb command. For more information, see Collecting data history. |
| nzhistcreatedb | Creates a history database with all its tables, views, and objects for history collection and reporting. | For command syntax, see The nzhistcreatedb command. For more information, see Collecting data history. |
| nzhostbackup | Backs up the host information, including users and groups. | For command syntax, see The nzhostbackup command. |
| nzhostrestore | Restores the host information. | For command syntax, see The nzhostrestore command. |
| nzhw | Manages system hardware components. | For command syntax, see The nzhw command. |
| nzinventory | This command is obsolete in Release 5.0. | See the command The nzhw command. |
| nzkey | Creates and manages authentication keys for self-encrypting drives (SEDs). | For command syntax, see The nzkey command. |
| nzkeydb | Creates and manages a key store for SED authentication keys. | For command syntax, see The nzkeydb command. |
| nzkeybackup | Creates a backup of a key store for SED authentication keys. | For command syntax, see The nzkeybackup command. |
| nzkeyrestore | Restores from a backup of a key store for SED authentication keys. | For command syntax, see The nzkeyrestore command. |
| nzload | Loads data into database files. | |
| nzpassword | Stores a local copy of the user password. | For command syntax, see The nzpassword command. For more information, see Encrypted passwords. |
| nzreclaim | Grooms databases and tables to remove deleted or outdated rows, and also reorganizes the tables based on their organizing keys. | For command syntax, see The nzreclaim command. For more information, see Groom tables. |
| nzrestore | Restores the contents of a database backup. | For command syntax and more information, see The nzrestore command. |
| nzrev | Displays the current software revision for any Netezza Performance Server software release. | For command syntax, see The nzrev command. For more information, see Software revision levels. |
| nzsession | Shows a list of current system sessions (load, client, and sql). Supports filtering by session type or user, aborting sessions, and changing the current job list for a queued session job. | For command syntax, see The nzsession command. For more information, see Session management. |
| nzsfi | This command is obsolete in Release 5.0. | See the command The nzhw command. |
| nzspu | This command is obsolete in Release 5.0. | See the command The nzhw command. |
| nzspupart | Shows a list of all the SPU partitions and the disks that support them. | See the command The nzspupart command. |
| nzsql | Runs the SQL command interpreter. | For usage information, see Databases and user tables. |
| nzstart | Starts the system. | For command syntax, see The nzstart command. For more information, see Manage the system state. |
| nzstate | Displays the current system state or waits for a specific system state to occur before it returns. | For command syntax, see The nzstate command. For more information, see Display the current system state. |
| nzstats | Displays system level statistics. | For command syntax, see The nzstats command. For more information, see Working with system statistics. |
| nzstop | Stops the system. | For command syntax, see The nzstop command. For more information, see Manage the system state. |
| nzsystem | Changes the system state or displays the current system information. | For command syntax, see The nzsystem command. For more information, see Manage the system state. |
| nztopology | This command is obsolete in Release 5.0. | See the command The nzds command. |