Teradata VS: I/O Statistics Columns - Analytics Database - Teradata Vantage

Resource Usage Macros and Tables

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
wqp1472240716284
lifecycle
latest
Product Category
Teradata Vantageā„¢
You can populate the ResUsageSpdsk table I/O statistics columns without having a Teradata VS license.

These columns identify the I/O statistics reported by the Extent Driver.

Column Name Mode Description Data Type
ConcurrentMax count Maximum number of concurrent I/O requests. FLOAT
ConcurrentReadMax max Maximum number of concurrent read I/O requests. FLOAT
ConcurrentWriteMax max Maximum number of concurrent write I/O requests. FLOAT
MigrationBlockedIos count Number of inputs and outputs that are blocked due to migration request. FLOAT
ReadCnt count Number of logical device reads. FLOAT
ReadKB count Number of KB read from the logical device. FLOAT
ReadRespMax max Maximum of individual read response time in centiseconds. FLOAT
ReadRespSq count Total of squares of the individual read response time in centiseconds. FLOAT
ReadRespTot count Total of individual read response time in centiseconds. FLOAT
WriteCnt count Number of logical device writes. FLOAT
WriteKB count Number of KB written to the logical device. FLOAT
WriteRespMax max Maximum of individual write response time in centiseconds. FLOAT
WriteRespSq count Total of squares of the individual write response time in centiseconds. FLOAT
WriteRespTot count Total of individual write response time in centiseconds. FLOAT