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.
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:
For more information on Netezza performance portal, refer the link to Netezza Performance Portal details