The hard disks where your user databases reside record certain performance and reliability data as they perform I/O. This status is referred to as Self-Monitoring Analysis and Reporting Technology (SMART) status. You can use the event manager to notify you when certain threshold values are crossed in the recorded performance or reliability data.
Exceeding these thresholds might indicate that the disk has started to run poorly (that is, it reads or writes data more slowly than it should) and affects the speed at which queries are processed. It might even indicate that the disk might fail soon.
IBM® Netezza® sets the thresholds that are based on analysis of disk drives and their performance characteristics. If you receive any of these events, contact Netezza Support and have them determine the state of your disk. Do not aggregate these events. The templates do not aggregate these events by default.
-name 'SCSIPredictiveFailure' -on no -eventType scsiPredictiveFailure
-eventArgsExpr '' -notifyType email -dst 'you@company.com' -ccDst ''
-msg 'NPS system $HOST - SCSI Predictive Failure value exceeded for
disk $diskHwId at $eventTimestamp' -bodyText
'$notifyMsg\n\nspuHwId:$spuHwId\ndisk
location:$location\nscsiAsc:$scsiAsc\nscsiAscq:$scsiAscq\nfru:$fru\nde
vSerial:$devSerial\ndiskSerial:$diskSerial\ndiskModel:$diskModel\ndisk
Mfg:$diskMfg\nevent source:$eventSource\n' -callHome no
-eventAggrCount 0
| Arguments | Description | Example |
|---|---|---|
| spuHwId | The hardware ID of the SPU that owns or manages the disk that reported the event | |
| diskHwId | The hardware ID of the disk | 1013 |
| scsiAsc | The attribute sense code, which is an identifier of the SMART attribute | Vendor specific |
| scsiAscq | The attribute sense code qualifier of the SMART attribute | Vendor specific |
| fru | The FRU ID for the disk | |
| location | The location of the disk | |
| devSerial | The serial number of the SPU to which the disk is assigned | 601S496A2012 |
| diskSerial | The disk serial number | 7.21496rA2.21091rB1 |
| diskModel | The disk model number | |
| diskMfg | The disk manufacturer |