- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
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 |