The ResUsageSpma table spare fields are named Spare00 through Spare19, and SpareInt.
The SpareInt field has a 32-bit internal resolution while all other spare fields have a 64-bit internal resolution. All spare fields default to count but can be converted to min, max, or track mode fields if needed when they are used.
Column Name | Mode | Description | Data Type |
---|---|---|---|
Spare00 - Spare01 | count | Reserved for future use. | FLOAT |
Spare02 | track | I/O capacity configured for a node in MB/s based on a 96k 90/10 R/W workload not adjusted for COD. The permanent column name NodeMbs is reserved for future use. |
FLOAT |
Spare03 - Spare06 | count | Reserved for future use. | FLOAT |
Spare07 | count | Number of prioritized I/Os that were starved and had their priority updated to alleviate starvation. A prioritized I/O is one that Priority Scheduler issues to the Teradata I/O Scheduler (TDSCHED) Expedited or Normal priority RBTREE queues with a non-zero priority key that determines its position in the associated queue. One of these I/Os that is starved has waited in the TDSCHED queue longer than the Priority Scheduler I/O anti-starvation threshold, the value of which appears in "schmon -iodata -debug" output with the "iostarvedthreshold=" field. The permanent column name IoPrioStarvedCount is reserved for future use. |
FLOAT |
Spare08 | count | Time in centiseconds processes were blocked pending non-step work (AWT only). This data is included in ProcWaitMsgRead. The permanent column name ProcWaitMsgReadAwt is reserved for future use. |
FLOAT |
Spare09 - Spare19, SpareInt | count | Reserved for future use. | FLOAT |