Cache Volume History

Prev Next

Stored in cacheVolumes
Comes from cacheDataUnique and cfgVolDataWork on storageArray, tag, volser, cacheDataUnique.seconds > 0, cfgVolDataWork.manufacture = 'EMC' and cfgVolDataWork.storageGroup is not null

DB Column name Aggregation Function FROM DB Column name Configurable In GROUPBY Description
scope scope
startTime MIN cacheDataUnique X
endTime MAX cacheDataUnique
seconds MAX cacheDataUnique
volser cacheDataUnique X
storageGroup cfgVolDataWork X
storageArray cacheDataUnique X
ssid cacheDataUnique X
typeNum cfgVolDataWork X
modelNum cfgVolDataWork X
manufacture cfgVolDataWork X
plant cfgVolDataWork X
seqNum cfgVolDataWork X
tag cacheDataUnique X
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(phyWrite)

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