- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Stored in cacheHist
Comes from cacheDataUnique and cfgVolDataWork on volser, storageArray, tag, cacheDataUnique.seconds > 0 and cfgVolDataWork.manufacture = 'EMC'
DB Column name | Aggregation Function | FROM DB Column name | Configurable | In GROUPBY | Description |
---|---|---|---|---|---|
scope | |||||
startTime | MIN | cacheDataUnique | X | ||
endTime | MAX | cacheDataUnique | |||
seconds | MAX | cacheDataUnique | |||
storageGroup | cfgVolDataWork | X | |||
storageArray | cacheDataUnique | X | |||
ssid | cacheDataUnique | X | |||
typeNum | cfgVolDataWork | X | |||
modelNum | Empty | ||||
manufacture | cfgVolDataWork | X | |||
plant | cfgVolDataWork | X | |||
seqNum | cfgVolDataWork | X | |||
devices | COUNT | ||||
volCapacityGb | SUM | cfgVolDataWork.cylinders | |||
cylinders | SUM | cfgVolDataWork | |||
beRead | SUM | cacheDataUnique.phyRead cacheDataUnique.seqRead cacheDataUnique.cacheRead cacheDataUnique.byteRead cacheDataUnique.cacheReadHit | IBM Mode SUM(phyRead) EMC Mode | ||
beWrite | SUM | cacheDataUnique.phyWrite cacheDataUnique.seqWrite cacheDataUnique.cacheWrite cacheDataUnique.byteWrite | IBM Mode SUM(phyRead) EMC Mode | ||
beReadKb | SUM | cacheDataUnique.byteRead | |||
beWriteKb | SUM | cacheDataUnique.byteWrite | |||
beReadTime | SUM | cacheDataUnique.phyReadRt | |||
beWriteTime | SUM | cacheDataUnique.phyWriteRt | |||
cacheRead | SUM | cacheDataUnique | |||
cacheReadHit | SUM | cacheDataUnique | |||
cacheWrite | SUM | cacheDataUnique | |||
cacheWriteHit | SUM | cacheDataUnique | |||
cacheInhibit | SUM | cacheDataUnique | |||
cacheBypass | SUM | cacheDataUnique | |||
seqRead | SUM | cacheDataUnique | |||
seqReadHit | SUM | cacheDataUnique | |||
seqWrite | SUM | cacheDataUnique | |||
seqWriteHit | SUM | cacheDataUnique | |||
phyRead | SUM | cacheDataUnique | |||
phyWrite | SUM | cacheDataUnique | |||
phyReadByte | SUM | cacheDataUnique | |||
phyWriteByte | SUM | cacheDataUnique | |||
phyReadRt | SUM | cacheDataUnique | |||
phyWriteRt | SUM | cacheDataUnique | |||
byteRead | SUM | cacheDataUnique | |||
byteWrite | SUM | cacheDataUnique | |||
byteReadRt | SUM | cacheDataUnique | |||
byteWriteRt | SUM | cacheDataUnique | |||
nretRead | SUM | cacheDataUnique | |||
nretReadHit | SUM | cacheDataUnique | |||
nretWrite | SUM | cacheDataUnique | |||
nretWriteHit | SUM | cacheDataUnique | |||
xfrSeqDasd | SUM | cacheDataUnique | |||
xfrNormDasd | SUM | cacheDataUnique | |||
xfrCacheDasd | SUM | cacheDataUnique | |||
fwBypass | SUM | cacheDataUnique | |||
fwCache | SUM | cacheDataUnique | |||
fwSeq | SUM | cacheDataUnique | |||
recCacheMiss | SUM | cacheDataUnique | |||
recCacheWrPro | SUM | cacheDataUnique | |||
recModeRead | SUM | cacheDataUnique | |||
ckdWrite | SUM | cacheDataUnique | |||
ckdWriteHit | SUM | cacheDataUnique | |||
cfwBypass | SUM | cacheDataUnique | |||
lowIntRt | SUM | cacheDataUnique | |||
zhpfRead | SUM | cacheDataUnique | |||
zhpfWrite | SUM | cacheDataUnique | |||
xrcRead | SUM | cacheDataUnique | |||
xrcWrite | SUM | cacheDataUnique | |||
pprcTrack | SUM | cacheDataUnique | |||
actionId | cacheDataUnique | ||||
cec_name | cacheDataUnique | X | |||
cec_model | cacheDataUnique | X | |||
cec_type | cacheDataUnique | X | |||
lpar_name | cacheDataUnique | X |