IBM PureData System for Analytics, Version 7.0.3

Summary of command-line commands

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.

Table 1. Command-line summary
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 Query history collection and reporting.
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 Query history collection and reporting.
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.


Feedback | Copyright IBM Corporation 2013 | Last updated: 2013-07-31