The following table describes the commands that you can use to monitor and manage the IBM® Netezza® system. These commands are in the /nz/kit/bin directory on the Netezza host. A subset of these commands is also installed with the Netezza client kits and can be run from a remote client system, as described in Command locations.
To run these commands from the Netezza system, you must be able to log in as a valid Linux user on the Netezza 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.
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 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. For more information, see the IBM Netezza Database User’s Guide. |
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 History data collection. |
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 History data collection. |
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. |
nzload | Loads data into database files. | For command syntax and more information, see the IBM Netezza Data Loading Guide. |
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 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. For command syntax, see the IBM Netezza Database User’s Guide. |
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 Netezza 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. |