PPT Slide

The daily grind

The System Catalog tables

Tracking the pieces of a fragmented table:

select *

from systables st, sysfragments sf

where st.tabid = sf.tabid and sf.fragtype = ‘T’

order by tabid, evalpos;