AW: Root Space Full

Ben wrote: > > We are having trouble with one of our instances - the root > database space > 'rootdbs' keeps filling up. The problem coincides with > adding two tables to > other dbspaces and then loading data (about 8m rows each) > into the new > tables. The problem appears to be a few objects beginning > with the ' ' > character (see "prod_db:'root'. 3004_3466" below). What are > these objects? > My suspician is that the database 'prod_db' was created in > the root space > and this is metadata related to that database. > These strange objects with space in their name are indexes that implement unique constraints for fragmented tables. These get created in the dbspace where the DB was created . To control the location of these drop the unique constarints. Then create equivalent unique indexes with the storage option of your choice . Then recreate the unique constraints . Now the unique constraints will use the already existinf indexes instead of creating systzem indexes. Apart from that - yes it is a good idea to create all databases in a dbspace which is not the rootdbs. HTH Tilman