Spare Columns - Analytics Database - Teradata Vantage

Resource Usage Macros and Tables

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
wqp1472240716284
lifecycle
latest
Product Category
Teradata Vantageā„¢

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