17.05 - Teradata Virtual Storage (VS): Extent Driver I/O Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

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