What chunks have the most I/O?

-- chkio.sql

select name[1,10] dbspace, -- truncated to fit 80 char screen line

chknum,

”Primary" chktype,

reads,

writes,

pagesread,

pageswritten

from syschktab c, sysdbstab d where c.dbsnum = d.dbsnum

union all

select name[1,10] dbspace,

chknum,

"Mirror" chktype,

reads,

writes,

pagesread,

pageswritten

from sysmchktab c, sysdbstab d where c.dbsnum = d.dbsnum

order by 1,2,3;

Previous slide

Next slide

Back to first slide

View graphic version