Netezza appliance topology

Reading Time: 2 minutes

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.

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