17.05 - Spare Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

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

The ResUsageSvpr table spare fields are named Spare00 through Spare29, 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 - Spare02 count Reserved for future use. FLOAT
Spare03 count

Number of spool data segments that were forced to change their age to ageoutnow.

In a future release this data will be reported in a permanent SVPR statistics column named FileSpoolForceAgeoutnow.

FLOAT
Spare04 count

Volume of spool data segments in KB that were forced to change their age to ageoutnow.

In a future release this data will be reported in a permanent SVPR statistics column named FileSpoolForceAgeoutnowKB.

FLOAT
Spare05 count

Number of spool data segments that keep their age irrespective of FSGINFOSPOOLAGEOUTNOW flag.

In a future release this data will be reported in a permanent SVPR statistics column named FileSpoolKeepAge.

FLOAT
Spare06 count

Volume of spool data segments in KB that keep their age irrespective of FSGINFOSPOOLAGEOUTNOW flag.

In a future release this data will be reported in a permanent SVPR statistics column named FileSpoolKeepAgeKB.

FLOAT
Spare07 - Spare29 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 SVPR statistics column named TDEnabledCPUs.

FLOAT