Tuesday, January 20, 2009

Dbspace I/O


select d.name, fname[15,25] path_name, sum(pagesread) diskreads,
sum(pageswritten) diskwrites
from syschkio c, syschunks k, sysdbspaces d
where d.dbsnum = k.dbsnum
and k.chknum = c.chknum
group by 1, 2
order by 1

The output is as follows:


name path_name diskreads diskwrites

airgen_idx_dbs uild95/ltmp 3672 7964
airgen_main_dbs uild95/ltmp 13545 32903
llog uild95/ltmp 19 51633
rootdbs uild95/ltmp 211 43117
temp1 uild95/ltmp 3015 3122
temp2 uild95/ltmp 3218 3317

We can get similar information using onstat -D, which displays disk reads and writes
for each chunk, and onstat -g ioq which displays disk I/O waiting queue information.

No comments: