Re: Moving sysmaster table extents

Martyn Hodgson wrote: > > We have a database that uses 24 chunks split across 16 dbspaces. The first > dbspace has two chunks. This dbspace contains the catalog tables for the > database. I have moved most of the data tables out from this dbspace so the > first chunk could easily hold the catalog tables. However, in the past 5 > catalogue tables have extended into the second chunk. There is only one 8 > page extent per table in the second chunk so the space usage in it is > minimal. Is it possible to move these extents to free up the second chunk as > I would like to use the space in another dbspace? The database is so large > that unloading it to drop and recreate the catalog from scratch is not an > option. No it is not safe to reorganize the system catalog tables. You will have to drop and reload. BTW next time create the database in a dbspace other than the rootdb space (dbs 1) for performance and management reasons. Art S. Kagel