Re: TBLSPACE table extents. -Reply

[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 ? Paul.