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 |