Check Netezza System Configurations using System Commands

  • Post author:
  • Post last modified:February 27, 2018
  • Post category:Netezza
  • Reading time:4 mins read

Verifying the Netezza system configuration is basic step to identify any issues with the system. You can troubleshoot the problem once you identify the same. In this article, we will see how to check Netezza system configurations using system commands and see some of examples.

Check Netezza System Configurations using System Commands

Netezza System Configurations

All the Netezza system configuration details are available in system.cfg file. This configuration file contains configuration settings that the Netezza uses for system startup, system management, host processes, and SPUs. It is advised to get in touch with IBM support team before editing system registry file.

Check Netezza System Configurations using System Commands

Below table describes the commands that can be used to check Netezza system configurations:

Command Description
nzrev Display the Netezza or NPS version
nzhw -detail Displays information about virtual hardware used by NPS including SPUs virtual machines and virtual disks.
nzsystem showRegistry Display the content of system configuration file
nzsystem Check the status of the Netezza system. You can execute this command with options too.
nzsystem showState show the overall system state (default)
nzsystem showRev show the system’s software revision
nzsystem showRegistry show the system’s configuration registry
nzsystem showIssues show the issues with system
nzsystem offline take the system offline
nzsystem showState pause the system
nzsystem showRev stop and then automatically start the system
nzsystem showRegistry bring the system back online
nzsystem showIssues stop the system
nzsystem set configure system setting(s)
nzds Displays NPS data slices, configuration, and state.
nzspupart Displays information about all partitions on SPU virtual disks.
lsb_release -a Displays operating system version
lscpu Displays CPU topology.
lsblk Displays a tree of block devices.
df -h Displays disks utilization in human readable form.
lspci -vv Displays list of PCI devices.
ifconfig Displays network configuration, including IP addresses.
route Displays network routing table.

System configuration commands are not limited to above list but there are more refer IBM site to manage Netezza server  for more information.

Netezza Performance Portal

You can manage the IBM Netezza performance server with help of Netezza performance portal which is a web-based administrative client for managing and monitoring IBM Netezza Performance Server systems.

Below is the sample image of the Netezza performance portal:

Netezza Performance Portal

For more information on Netezza performance portal, refer the link to Netezza Performance Portal details