Stored in sms_exec
Comes from smsData
| DB Column name | Aggregation Function | FROM DB Column name | Configurable | In GROUPBY | Description |
|---|---|---|---|---|---|
| scope | |||||
| rec_type | recType | ||||
| start_time | startTime | ||||
| end_time | endTime | ||||
| seconds | |||||
| sid | |||||
| ds_name | dsname | ||||
| vol_ser | volser | ||||
| job_rdr_time | jobRdrTime | ||||
| job_name | jobName | ||||
| racf_user | racfUser | ||||
| pgn | |||||
| sms_stor_cls | smsStorCls | ||||
| wlm_class | wlmClass | ||||
| wlm_workload | wlmWorkload | ||||
| ds_descr_flag | dsDescrFlag | ||||
| entry_flag | entryFlag | ||||
| devnum | |||||
| ssid | |||||
| sub_type | subType | ||||
| ds_type | dsType | ||||
| blk_size | blkSize | ||||
| use_count | useCount | ||||
| stripes | |||||
| tot_io | totIo | ||||
| tot_read | totRead | ||||
| cache_io | cacheIo | ||||
| seq_io | seqIo | ||||
| write_io | writeIo | ||||
| rls_io | rlsIo | ||||
| inhibit_io | inhibitIo | ||||
| cache_hits | cacheHits | ||||
| write_hits | writeHits | ||||
| seq_read_blk | seqReadBlk | ||||
| rand_read_blk | randReadBlk | ||||
| seq_write_blk | seqWriteBlk | ||||
| rand_write_blk | randWriteBlk | ||||
| dir_read | dirRead | ||||
| dir_write | dirWrite | ||||
| avg_resp_time | avgRespTime | ||||
| avg_conn_time | avgConnTime | ||||
| avg_pend_time | avgPendTime | ||||
| avg_disc_time | avgDiscTime | ||||
| avg_queue_time | avgQueueTime | ||||
| avg_actv_time | avgActvTime | ||||
| avg_read_disc_tm | avgReadDiscTm | ||||
| max_resp_time | maxRespTime | ||||
| max_serv_time | maxServTime | ||||
| seq_read_dly | seqReadDly | ||||
| rand_read_dly | randReadDly | ||||
| seq_write_dly | seqWriteDly | ||||
| rand_write_dly | randWriteDly | ||||
| dir_read_dly | dirReadDly | ||||
| dir_write_dly | dirWriteDly | ||||
| is_open | isOpen | ||||
| is_close | isClose | ||||
| is_interval | isInterval | ||||
| is_ps | isPs | ||||
| is_pds | isPds | ||||
| is_pdse | isPdse | ||||
| is_da | isDa | ||||
| is_hfs | isHfs | ||||
| is_vsam | isVsam | ||||
| action_id | actionId |