TVSTemperature Reserved Storage Management Query Bands - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

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-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

In general, customer-written applications should not use reserved query band names, which are reserved for use by Teradata-written applications and applications written by third party Teradata partners. However, the TVSTemperature query bands are an exception to this rule because they support both Teradata Virtual Storage and temperature-based block-level compression.

Use the TVSTemperature query band for tables whose effective BLOCKCOMPRESSION option is AUTOTEMP. For AUTOTEMP to be active, both BLC and TempBLC must be enabled in DBS Control. In that case the TVSTemperature query band specifies the desired temperature for the table cylinders on which the table data is to be stored. This temperature determines the compressed or noncompressed state of blocks in the table. The DBS Control parameter TempBLCThresh determines which temperatures compress data and which decompress data.

Following are the temperature bands for block-level compression. The percentages are approximate.

Temperature Description
COLD The 20% of data that is least frequently accessed.
WARM The remaining 60% of data that falls between the COLD and HOT bands.
HOT The 20% of data that is most frequently accessed.
VERY HOT Data that you or Teradata Virtual Storage determines should be added to the Very Hot cache list and have its temperature set to very hot when it is loaded using the TVSTemperature query band.
The following query band names are used for TVSTemperature.
  • TVSTEMPERATURE_PRIMARY
  • TVSTEMPERATURE_PRIMARYCLOBS
  • TVSTEMPERATURE_FALLBACK
  • TVSTEMPERATURE_FALLBACKCLOBS

You can specify either VERY HOT, HOT, WARM, or COLD for each of these query band names.

These query bands are valid for both sessions and transactions.

See Teradata Vantage™ - Teradata® Virtual Storage, B035-1179 for more information on these query band names.

Table data being added to an already allocated cylinder retains the temperature initially set for the cylinder, not the temperature you set for the query band.