rootdbs space.

Posted in 2000

howard.jones — Mon, 17 Apr 2000 21:20:31 +0100 — source: Informix-list mailing list archive (1991-1998)

The rootdbs on one of our servers has become dangerously full, is there anybody out there who would know the reason for this sudden increase in size... Cheers, Howard Jones

↪ replying to howard.jones

Yuri Dovgart — Tue, 18 Apr 2000 11:46:49 +0400 — source: Informix-list mailing list archive (1991-1998)

howard.jones <howard.jones@iclway.co.uk> wrote in message news:38fb72cc_3@news2.vip.uk.com... > The rootdbs on one of our servers has become dangerously full, is there > anybody out there who would know the reason for this sudden increase in > size... Looks like someone has created tables without specifying database name - in this case such table will be placed in rootdbs. To find tables like this use 'oncheck -pe' - this will print extents for your tables. Then remove tables from rootdbs to othere dbspace using 'ALTER FRAGMENT INIT ...' or any other tool. -- ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > Cheers, > > Howard Jones > >