Re: Database Reorganisation

Any way to defrag by dbspace? That way, you could break the large job into smaller chunks and run it over multiple weekends instead of at one fell swoop. John Carlson Informix DBA WHSmith USA Vlad the Impailer wrote: > > Afternoon all !! > > I have a Baan database which needs re-organising. It has in excess of 8500 > tables, most of which are okay but about 300 or so tables are massively > fragmented and about 150 or so are wasting space. > > The database is about 14GB (so, not very big) but I only have about 400MB > free within the dbspace. I know from past experience of re-organising this > database that the dbspace the database is on will fill if I only do these > tables (plus I need to make sure there is enough space to cater for the > re-sized tables). > > My dilema is this. > I only have 36 hours (to save the earth) in order to achieve a full > re-organisation (running on a HP 9000, 3 processors, running HPUX 10.2, > Online 7.24.UC5) > > What would you say is the quickest way to do it ?? (Bearing in mind that > baan table names can not be re-created using HPL ). > > I wait with baited breath. > > TIA > > Sean