- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Stored in smsHist
Comes from smsData
DB Column name | Aggregation Function | FROM DB Column name | Configurable | In GROUPBY | Description |
---|---|---|---|---|---|
scope | |||||
startTime | MIN | ||||
endTime | MAX | ||||
sid | X | ||||
dsname | X | ||||
volser | X | ||||
jobName | X | ||||
racfUser | X | ||||
smsStorCls | X | ||||
wlmClass | X | ||||
wlmWorkload | X | ||||
devnum | X | ||||
dsType | X | ||||
blkSize | MAX | ||||
stripes | MAX | ||||
useCount | SUM | isClose | |||
totIo | SUM | ||||
totRead | SUM | ||||
cacheIo | SUM | ||||
seqIo | SUM | ||||
writeIo | SUM | ||||
rlsIo | SUM | ||||
inhibitIo | SUM | ||||
cacheHits | SUM | ||||
writeHits | SUM | ||||
seqReadBlk | SUM | ||||
randReadBlk | SUM | ||||
seqWriteBlk | SUM | ||||
randWriteBlk | SUM | ||||
dirRead | SUM | ||||
dirWrite | SUM | ||||
avgRespTime | SUM | avgRespTime totIo | |||
avgConnTime | SUM | avgConnTime totIo | |||
avgPendTime | SUM | avgPendTime totIo | |||
avgDiscTime | SUM | avgDiscTime totIo | |||
avgQueueTime | SUM | avgQueueTime totIo | |||
avgActvTime | SUM | avgActvTime totIo | |||
avgReadDiscTm | SUM | avgReadDiscTm totIo | |||
maxRespTime | MAX | ||||
maxServTime | MAX | ||||
seqReadDly | SUM | ||||
randReadDly | SUM | ||||
seqWriteDly | SUM | ||||
randWriteDly | SUM | ||||
dirReadDly | SUM | ||||
dirWriteDly | SUM | ||||
isOpen | MAX | ||||
isClose | MAX | ||||
isInterval | MAX | ||||
isPs | MAX | ||||
isPds | MAX | ||||
isPdse | MAX | ||||
isDa | MAX | ||||
isHfs | MAX | ||||
isVsam | MAX | ||||
actionId |