Examples | Temperature, Cylinder, Heatmap Data | Teradata Vantage - 17.10 - Example: Data Temperature Report Showing a Specific Table - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

The following is an example of a heatmap report showing the temperature property of cylinder ID '0006000100000038'.

Only one cylinder is selected for ease of illustration.
SELECT * FROM demo.tdheatmap_v WHERE DatabaseName = ‘EMPLOYEE’ AND TableName = ‘BASIC_INFO’ ORDER BY Temperature DESC
Field Results
TheDate 9/23/2015
TheTime 20:46:49
AmpNumber 1
DatabaseName EMPLOYEE
TableName BASIC_INFO
StartTableId 00-00-0A-A8-04-0A
StartTableIdUniq 00-00-A8-0A
StartTableIdTypeAndIndex 1,024
StartPartition 0
StartRowId DB-BA-AF-F3-00-00-00-01
EndTableId 00-00-0A-A8-04-0A
EndTableIdUniq 00-00-A8-0A
EndTableIdTypeAndIndex 1,024
EndPartition 0
EndRowHash F0-30-4E-94
CylinderId 00-06-00-01-00-00-00-38
CylinderIdMsw 393,217
CylinderIdLsw 56
Temperature 29.41
NormalizedTempInfo WARM
RequestedTempInfo WARM
VeryHotCandidate  
VeryHotCache  
TempWarmCeiling 113.42
TempWarmFloor 18.11
TempVeryHotFloor 0
PercentFull 90.72
TempPercent 47.00
Grade MEDIUM
MediaType DISK
StorageClass PRIMARY
This sample heatmap report indicates the following:
  1. The cylinder belongs to a primary permanent table:
    StartTableIdTypeAndIndex = 1024
  2. TIM is not enabled:
    VeryHotCandidate = BLANK
    and
    VeryHotCache = BLANK
    and
    TempVeryHotFloor = 0
  3. This cylinder is not a mixed cylinder:
    StartTableIdUniq = 0000A80A
    and
    EndTableIdUniq = 0000A80A
    If it is a mixed cylinder, StartTableIdUniq and EndTableIdUniq shows different values.
  4. This heatmap was taken from AMP 1:
    AmpNumber = 1
  5. This table is not partitioned:
    StartPartition = 0
    and
    EndPartition = 0