Beyond Basics

Disk structures and how to examine them

extents

select dbsname, tabname, pe_extnum extnum, pe_size size, pb_bitmap bitval,

count(pb.pagenum) count

from systabnames st, sysptnext se, sysptnbit sb

where st.partnum = se.partnum and se.partnum = sb.partnum

and sb.pagenum >= se.phys and sb.pagenum < (se.phys + se.size)

group by 1,2,3,4,5

order by 1,2,3,4,5;