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 |