--- title: "Dataset SMS History" slug: "dataset-sms-history" updated: 2022-11-09T10:18:06Z published: 2022-11-09T10:18:06Z canonical: "docs.zetaly.io/dataset-sms-history" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.zetaly.io/llms.txt > Use this file to discover all available pages before exploring further. # Dataset SMS History Stored in smsHist Comes from [smsData](/v1/docs/smf-42-6-dasd-data-set-level-io-statistics) | 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 | | | $\frac{SUM(avgRespTime*totIo)}{SUM(totIo)}$ | | avgConnTime | SUM | avgConnTime totIo | | | $\frac{SUM(avgConnTime*totIo)}{SUM(totIo)}$ | | avgPendTime | SUM | avgPendTime totIo | | | $\frac{SUM(avgPendTime*totIo)}{SUM(totIo)}$ | | avgDiscTime | SUM | avgDiscTime totIo | | | $\frac{SUM(avgDiscTime*totIo)}{SUM(totIo)}$ | | avgQueueTime | SUM | avgQueueTime totIo | | | $\frac{SUM(avgQueueTime*totIo)}{SUM(totIo)}$ | | avgActvTime | SUM | avgActvTime totIo | | | $\frac{SUM(avgActvTime*totIo)}{SUM(totIo)}$ | | avgReadDiscTm | SUM | avgReadDiscTm totIo | | | $\frac{SUM(avgReadDiscTm*totIo)}{SUM(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 | | | | | |