Re: TBLSPACE table extents. -Reply

In article <4q5vg1$6om@cssun.mathcs.emory.edu>, Paul Daniels <paul.daniells@lovellwhitedurrant.com> wrote: >[Snip] >> the TBLSPACE tables have developed many extents >> and been fragmented throughout the dbspace(s) >....... >> Does anybody have suggestion or ideas on how to prevent it >happening ? >[Snip] > >>>Jack Parker Wrote: >>>[Snip] >>>ALTER INDEX foo TO CLUSTER;>>>Where foo is some index (your primary would be good) of the table. >>>[Snip] > >Jack's suggestion works fine on database tables, unfortunately I did not >make myself clear, the TBLSPACE TBLSPACE I was referring to is the >internal one which holds information on table location within a dbspace, >and shows up best when using "oncheck -pe". > >This has become badly extended on all three of our systems which run >different applications. This did not happen on version 5. > >Any further ideas ? or maybe I should not worry about it ? > Informix does support setting the NEXT EXTENT size for system tables, so you could try that. dan. -- -- dan jatnieks Siemens Rolm Communications Inc. dan.jatnieks@siemensrolm.com http://www.siemensrolm.com/