Moving sysmaster table extents

Posted in 1998

Martyn Hodgson — Wed, 16 Dec 1998 09:38:51 -0000 — source: Informix-list mailing list archive (1991-1998)

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. Thanks in advance Martyn martyn.hodgson@eaglestar.co.uk