17.00 - Spare Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

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 - 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 a future release this data will be reported in a permanent SPS statistics column named TDEnabledCPUs.

FLOAT