17.05 - Teradata VS 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 pdisk I/O statistics that are reported by the Node Agent.

Column Name Mode Description Data Type
TvsReadCnt count Number of logical device reads.

The TvsReadCnt column is a summary of the ReadCnt column in the SPDSK table.

FLOAT
TvsReadRespMax max Maximum read response time in centiseconds during the reporting period. FLOAT
TvsReadRespTot count Total of individual read response time in centiseconds.

The TvsReadRespTot column is a summary of the ReadRespTot column in the SPDSK table.

FLOAT
TvsWriteCnt count Number of logical device writes.

The TvsWriteCnt column is a summary of the WriteCnt column in the SPDSK table.

FLOAT
TvsWriteRespMax max Maximum response time in centiseconds of logical device writes during the reporting period. FLOAT
TvsWriteRespTot count Total of individual write response time in centiseconds.

TvsWriteRespTot is a summary of the WriteRespTot column in the SPDSK table.

FLOAT