Re: TBLSPACE table extents. -Reply

In article <4q5vg1$6om@cssun.mathcs.emory.edu>, Paul Daniels <paul.danie lls@lovellwhitedurrant.com> writes >[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 ? >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. > There is not a lot you cab do about it since you cannot directly control the placement of the extents for the TBLSPAC TBLSPACE. dbexporting ALL the databases on your OnLine instances, dropping them and reimporting them may help and certianly would give you the best layout you can expect. Otherwise there is not much that you can do. -- David Williams