Teradata Virtual Storage (VS): Extent Driver I/O Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

These columns identify the I/O statistics reported from the extent driver.

Column Name Mode Description Data Type
ReadsCold count Total number of reads issued to all cylinders that are considered COLD.

A cylinder is considered to be COLD if the response time of its associated physical storage is less than TVS Percentile Cold Lower Bound configuration setting.

This column is not currently valid. It should not be used.
FLOAT
ReadsHot count Total number of reads issued to all cylinders that are considered HOT.

A cylinder is considered HOT if the response time of its associated physical storage is greater than the Teradata VS Percentile Hot Lower Bound configuration setting.

This column is not currently valid. It should not be used.
FLOAT
ReadsWarm count Total number of reads issued to all cylinders that are considered WARM.

A cylinder is considered to be WARM if the response time of its associated physical storage is between TVS Percentile Hot Lower Bound and TVS Percentile Cold Upper Bound configuration settings.

This column is not currently valid. It should not be used.
FLOAT
WritesCold count Total number of writes issued to all cylinders that are considered COLD.
This column is not currently valid. It should not be used.
FLOAT
WritesHot count Total number of writes issued to all cylinders that are considered HOT.
This column is not currently valid. It should not be used.
FLOAT
WritesWarm count Total number of writes issued to all cylinders that are considered WARM.
This column is not currently valid. It should not be used.
FLOAT
ReadResponseColdTotal count Total read response time of all cylinders that are considered COLD
This column is not currently valid. It should not be used.
FLOAT
ReadResponseHotTotal count Total read response time of all cylinders that are considered HOT.
This column is not currently valid. It should not be used.
FLOAT
ReadResponseWarmTotal count Total read response time of all cylinders that are considered WARM.
This column is not currently valid. It should not be used.
FLOAT
WriteResponseColdTotal count Total write response time of all cylinders that are considered COLD.
This column is not currently valid. It should not be used.
FLOAT
WriteResponseHotTotal count Total write response time of all cylinders that are considered HOT.
This column is not currently valid. It should not be used.
FLOAT
WriteResponseWarmTotal count Total write response time of all cylinders that are considered WARM.
This column is not currently valid. It should not be used.
FLOAT
ReadResponseColdMax max Maximum read response time of all cylinders that are considered COLD.
This column is not currently valid. It should not be used.
FLOAT
ReadResponseHotMax max Maximum read response time of all cylinders that are considered HOT.
This column is not currently valid. It should not be used.
FLOAT
ReadResponseWarmMax max Maximum read response time of all cylinders that are considered WARM.
This column is not currently valid. It should not be used.
FLOAT
ReadResponseColdMin min Minimum read response time of all cylinders that are considered COLD.

This column has a default value of the largest value of a 64-bit integer column.

This column is not currently valid. It should not be used.
FLOAT
ReadResponseHotMin min Minimum read response time of all cylinders that are considered HOT.

This column has a default value of the largest value of a 64-bit integer column.

This column is not currently valid. It should not be used.
FLOAT
ReadResponseWarmMin min Minimum read response time of all cylinders that are considered WARM.

This column has a default value of the largest value of a 64-bit integer column.

This column is not currently valid. It should not be used.
FLOAT
WriteResponseColdMax max Maximum write response time of all cylinders that are considered COLD.
This column is not currently valid. It should not be used.
FLOAT
WriteResponseHotMax max Maximum write response time of all cylinders that are considered HOT.
This column is not currently valid. It should not be used.
FLOAT
WriteResponseWarmMax max Maximum write response time of all cylinders that are considered WARM.
This column is not currently valid. It should not be used.
FLOAT
WriteResponseColdMin min Minimum write response time of all cylinders that are considered COLD.

This column has a default value of the largest value of a 64-bit integer column.

This column is not currently valid. It should not be used.
FLOAT
WriteResponseHotMin min Minimum write response time of all cylinders that are considered HOT.

This column has a default value of the largest value of a 64-bit integer column.

This column is not currently valid. It should not be used.
FLOAT
WriteResponseWarmMin min Minimum write response time of all cylinders that are considered WARM.

This column has a default value of the largest value of a 64-bit integer column.

This column is not currently valid. It should not be used.
FLOAT