Beyond Basics

Onstat and sysmaster

onstat -d

Total pages, free pages, dbspace type, & blob pagesize:

select d.name, d.is_temp, d.is_blobspace, t.prtpage/1024 pagesize

sum(chksize) dbs_pages, sun(nfree) dbs_free

from sysdbspaces d, syschunks c, sysdbstab t

where d.dbsnum = c.dbsnum

and c.dbsnum = t.dbsnum

group by 1,2,3,4

order by 6;