Returned Columns - Advanced SQL Engine - Teradata Database

SQL Operators and User-Defined Functions
Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
xwv1596137968859.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

The following columns can be obtained from the tdheatmap function.

General Fields

TheDate

The date the heatmap was produced.

TheTime

The time the heatmap was produced.

AmpNumber

The VPROC identifier of the AMP on which the heatmap was originally produced.

DatabaseName

The name of the database.

TableName

The name of the table.

CylinderId(Lsw+Msw)

The unique identifier of cylinder.

Starting Table

StartTableId

StartTableIdUniq and StartTableIdTypeAndIndex.

StartTableIdUniq

The unique ID that identifies the starting table. It can be joined to dbc.tvm.tvmid.

StartTableIdTypeAndIndex

The subtable type of the starting table: Primary, Fallback, Secondary. For example, 1024 is the Primary data, 1028 is the Secondary Index, 2048 is the Primary fallback.

StartPartition

Internal partition number of the starting row.

This is not an external partition.
StartRowId

The rowId(hash0 + hash1 + uniq0 + uniq1) of the starting row.

Ending Table

EndTableId

EndTableIdUniq and EndTableTypeAndIndex.

EndTableIdUniq

The unique ID that identifies the ending table. It can be joined to dbc.tvm.tvmid.

EndTableTypeAndIndex

Subtable type of the ending table: Primary, Fallback, Secondary. For example, 1024 is the Primary data, 1028 is the Secondary Index, 2048 is the Primary fallback.

EndPartition

Internal partition number of the ending row.

This is not the external partition associated with PARTITION keyword via SQL.
EndRowHash

The row hash value (hash0 and hash1) of the ending row.

Temperature Information

Temperature

The TVS temperature in the float point.

NormalizedTempInfo

If Temperature is greater than warmceiling, it is classified as ‘HOT’. Any Temperature between warmceiling and warmfloor is ‘WARM,’ and the rest is COLD.

RequestedTempInfo

The requested temperature by Vantage when File System requests the allocation of a cylinder.

TempPercentile

Percentage value indicates how many percent permanent cylinders are colder than this cylinder.

TempWarmCeiling

The upper limit of the warm/hot temperature boundary.

TempWarmFloor

The lower limit of the warm/hot temperature boundary.

TempVeryHotFloor

The lowest temperature above which temperature can be considered to belong to VeryHotCache.

PercentFull

Percentage value indicates how much percent of the extent is full.

TIM Cache

VeryHotCandidate

Yes or No. TVS identifies whether the selected cylinder is the hot candidate. If TIM is not activated, this column displays BLANK.

VeryHotCache

Yes or No. The cylinder is (or is not) actually in VeryHotCache. If TIM is not activated, this column displays BLANK.

Storage Placement

Grade

Describes whether the cylinder storage media is SLOW, MEDIUM, or FAST. If TVS is not enabled on the system, this column displays BLANK.

MediaType

Specifies the cylinder storage media type as DISK, FILE, SSD, NETWORK, or OTHER. Each value indicates whether the data is on a rotating disk drive, a flat file, a solid state drive, a network-attached storage device, or another media type.

StorageClass

Specifies the cylinder storage media class as PRIMARY or SECONDARY. The default is PRIMARY.