The ResUsageSpdsk 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 - 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 - Spare19, SpareInt | count | Reserved for future use. | FLOAT |