extent usage and fragmentation
Posted in 1997
My normal report for dbspaces which gives me : ____________________________________________________________________ object extents space_allocated space_used_data space_used_index ____________________________________________________________________ no longer works when I run it using fragmented database spaces. Obviously this is since the partnum usually associated with a table in the systabinfo table is set to 0 to indicate it is a fragmented table, and the overhead is in sysfragments, etc. Has anyone got a convenient way to view this information without getting to intimate with the fragmentation system tables? Thanks. Rob. -- _________________________________ | Robert Donat | | rdonat@sigg.com | | http://sashimi.wwa.com/~donat | |_______________________________|