Command to check Netezza topology
To check Netezza toppology, run the below command. This command will just pull all the info related to topology and give a detailed output for each SPA followed by a summary of warnings at the end. The presence of WARNING or ERRORS at the end of the output indicates that there is some action that the administrators need to do. Furthermore, in case there are errors and there is a failed SPA, fix this issue by restoring from back up and/or replacing the device.
In this article, we will cover
hide
COMMAND:
nzds show -topology
OUTPUT:
The output lists all the spus. Here is how the warnings look:
WARNING: 13 issues detected
spu0305 hba [0] port [2] has 3 disks
spu0401 hba [0] port [2] has 3 disks
spu0401 hba [0] has 5 disks
spu0401 hba [1] port [0] has 3 disks
spu0401 hba [1] has 5 disks
spu0405 hba [0] port [3] has 3 disks
spu0405 hba [0] has 5 disks
spu0405 hba [1] port [1] has 3 disks
spu0405 hba [1] has 5 disks
spu0407 hba [0] port [2] has 3 disks
spu0407 hba [0] has 5 disks
spu0407 hba [1] port [0] has 3 disks
spu0407 hba [1] has 5 disks
To get rid of the warnings:
nzstop/nzstart
<OR>
nzhw rebalance
How to find the serial number of the Netezza appliance?
To find serial number for your Netezza appliance use the below command:
locate nps_serial.txt | xargs cat