17.20 - Spare Columns - Analytics Database - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables - 17.20

Product
Analytics Database
Teradata Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-10-17
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval

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