Skip to content

How to check if Netezza appliance is having a topology issue?

How to check if Netezza appliance is having a topology issue?

To check if there is a topology in-balance in your Netezza system just run the below command and look for WARNING at the end of the output.

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.

COMMAND:
nzds show -topology

OUTPUT:
Here is what to look for in the output.. In my expamle I found 13 warnings all on SPA 4.

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

In order to fix this issue we have to first make sure there is no failed SPA in the system. If there is any then kindly get that fixed first and after that just issue below command to fix this issue or nzstop/nzstart can also take care of this issue.

nzhw rebalance