Netezza – Monitor grown defects on disks

SQL to monitor the number of grown defects on disks for TwinFin Architecture:

The output of this script will list all the disks on Netezza server where number of grown defects is greater than 0.

Possibility of disk failure increases with increase in disk defects. Below you can find the list that shows the max disk defects at which disk will fail

Disk Type                             FRU number           Disk Failure @ Max defects


ST31000640SS                   42D0549                  2000+
ST31000424SS                   42D0778                  4000+
ST31000424SS                   49Y1939                  4000+
ST1000NM0001                    42D0778                  4000+