Re: Defrag Tablespaces ? How ?

...
> > >
> > > but 24*7 availability?
> > >
> > > Asko Tiidumaa

We use DFRAG from Noetix (ARIS). It gets around the 24x7 problem by offering an online dfrag option. This works by creating a temporary table in the same tablespace as the original one, renaming the original to hide it, then renaming the copy as the original. It then defragments the original in the usual way, renames everything back and drops the copy. Users get continuous access, disregarding the fraction of a second between renames. Disadvantage is that it needs a lot of contiguous freespace if you have big tables compared to the size of your tablespaces, but then DASD is cheap. There is also an offline defragmentation option which uses external files to hold the data.

DFRAG deals in tablespaces, taking care of finding out what objects are in them, etc. for you. DFRAG also looks for fragmented objects and feeds them to the defragmentation process on its own. Platinum told me that you have to pair up TSREORG with another product of theirs (Analyzer?) to get this kind of automated janitorial service.

• Paul de Anguera, City of Seattle / ESD

  ---

  My real address is: | Please adjust my address if Paul.Deanguera<at> | you e-mail me. The header ci.seattle.wa.us | address is anti-spammed.