The following columns can be obtained from the tdheatmap function.
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.
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.
The rowId(hash0 + hash1 + uniq0 + uniq1) of the starting row.
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.
The row hash value (hash0 and hash1) of the ending row.
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 Teradata Database 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.
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.
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.