IBM PureData System for Analytics, Version 7.1

Netezza CLI

You can use the IBM® Netezza® CLI to manage the Netezza software, hardware, and databases.

Netezza Support might also ask you to run specific low-level diagnostic commands to investigate problems. This section provides information about the Netezza user commands and the Netezza Customer Service commands.

Summary of command-line commands
Netezza CLI command syntax
The nzbackup command
Use the nzbackup command to back up your database.
The nzconfigcrypto command
Use the nzconfigcrypto command to enable or disable the enhanced cryptography support on an IBM Netezza appliance.
The nzcontents command
Use the nzcontents command to display the IBM Netezza program names, the revision level, the build level, and the checksum of binaries.
The nzconvert command
Use the nzconvert command to convert between any two encodings, between these encodings and UTF-8, and from UTF-32, UTF-16, or UTF-8 to NFC, for loading with the nzload command or external tables.
The nzds command
Use the nzds command to manage and obtain information about the data slices in the system.
The nzevent command
You use the nzevent command to manage the alerts and triggers for problem and condition reporting on the IBM Netezza appliances.
The nzhealthcheck command
Use the nzhealthcheck command to run the Netezza System Health Check tool and view the report on possible system issues.
The nzhistcleanupdb command
Issue the nzhistcleanupdb command to delete outdated history information from a history database.
The nzhistcreatedb command
Use this command to create a history database including all the tables, views, and other objects needed to collect history data.
The nzhostbackup command
Use the nzhostbackup command to back up the IBM Netezza data directory and system catalog on the host.
The nzhostrestore command
Use the nzhostrestore command to restore your IBM Netezza data directory and metadata.
The nzhw command
Use the nzhw command to manage the hardware of the IBM Netezza system.
The nzload command
Use the nzload command to load ASCII data into database tables.
The nzOpenPmr command
Use the nzOpenPmr command to configure and manage the callhome service and the automatic notifications for issues that are detected on the IBM PureData™ System for Analytics appliances.
The nzpassword command
Use the nzpassword command to manage passwords. The primary use is to store your password locally and thus use IBM Netezza CLI commands without having to type your password on the command line.
The nzreclaim command
Use the nzreclaim command to recover disk space that is used by updated or deleted data by using the GROOM TABLE command.
The nzrestore command
Use the nzrestore command to restore your database from a backup.
The nzrev command
Use the nzrev command to display the IBM Netezza software revision level.
The nzsession command
Use the nzsession command to view and manage sessions.
The nzspupart command
Use the nzspupart command to display information about the SPU partitions on an IBM Netezza system including status information and the disks that support the partition.
The nzstart command
Use the nzstart command to start system operation after you stop the system. The nzstart command is a script that initiates a system start by setting up the environment and starting the startup server.
The nzstate command
Use the nzstate command to display the current system state or to wait for a particular system state to occur.
The nzstats command
Use the nzstats command to display statistics about system capacity, faults, and performance.
The nzstop command
Use the nzstop command to stop the IBM Netezza software operations. Stopping a system stops all the IBM Netezza processes that were started with the nzstart command.
The nzsystem command
Use the nzsystem command to change the system state, and show and set configuration information.
Customer service troubleshooting commands
Occasionally, IBM Netezza Customer Service might ask you to use commands that are in the /nz/kit/bin/adm directory. These commands are low-level diagnostic commands that can be run only on the host and require administrative privileges.