The ResUsageSps 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 | count | Number of time that processes are blocked waiting for a lock on the CI. The permanent column name CISleeps is reserved for future use. |
FLOAT |
Spare01 | count | Total amount of time in milliseconds that processes are blocked waiting for a lock on the CI. The permanent column name CISleepTime is reserved for future use. |
FLOAT |
Spare02 | max | Maximum amount of time in milliseconds that processes are blocked waiting for a lock on the CI. The permanent column name CISleepTimeMax 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 | Number of times that processes are blocked waiting for a lock on the MI. The permanent column name MISleeps is reserved for future use. |
FLOAT |
Spare09 | count | Total amount of time in milliseconds that processes are blocked waiting for a lock on the MI. The permanent column name MISleepTime is reserved for future use. |
FLOAT |
Spare10 | max | Maximum amount of time in milliseconds that processes are blocked waiting for a lock on the MI. The permanent column name MISleepTimeMax is reserved for future use. |
FLOAT |
Spare11 - Spare14 | count | Reserved for future use. | FLOAT |
Spare15 | count | Number of I/Os submitted to local disks. This data is included in IOSubmitted. The permanent column name IOSubmittedLocal is reserved for future use. |
FLOAT |
Spare16 | count | Amount of I/O submitted, in KB, to local disks. This data is included in IOSubmittedKB. The permanent column name IOSubmittedLocalKB is reserved for future use. |
FLOAT |
Spare17 | count | Time in milliseconds processes were throttled because of PSF WM I/O COD or I/O hard limits. The permanent column name ProcWaitIoThrottle is reserved for future use. |
FLOAT |
Spare18 - Spare19 | count | Reserved for future use. | FLOAT |
SpareInt | track | This column reports the number of CPUs available for Teradata tasks at the end of the reporting period. These CPUs are TD-enabled CPUs. Teradata tasks only have access to TD-enabled CPUs while Non-Teradata tasks have access to all online CPUs. This count may change dynamically after database is up but is always less than or equal to the count reported in NCPUs. In future use, this data will be reported in a permanent SPS statistics column named TDEnabledCPUs. |
FLOAT |