Teradata VS Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

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