TVSTemperature Reserved Storage Management Query Bands - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
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.