Skip to content

Identify disks to be failed over manually – Netezza

Below query can be used identify disks with read write erros more than 1000 should be a candidate of manual failover. These disks can fail cause data corruption if not taken care off in timely manner.

Run below query to identify the disks:

nzsql -x -c “select hwid, diskserial,rack,spa,encl,slot,grown_defects,uncor_read,uncor_verify from v_scsi_disk where uncor_write >=250 or uncor_read>=1000 or uncor_verify >=250 order by rack, spa, encl, slot;”

Here we are also looking for disks with uncorrectable write errors more than 250 or uncorrectible verify errors moe than 250 as well.