Re: Optimizing SE databases.

Edmund Nigel Gall (ngall@stratis-caribbean.com) wrote: : - Unload data, drop table, reload data to solve fragmentation : (How is this different from backing off to tape using cpio/tar and : dropping the entire database and then restoring from tape? Can I : use cpio/tar to solve fragmentation problems? Would I have to re- : build indexes after doing this? Any other methods to solve : fragmentation in UNIX?) tar/cpio only affect the external allocation of the file block within the file system. They do not do anything to the internal structure of the files. BCHECK (or if you want to do a more complete job and a lot faster ISAMATION) will reorganize the internal structure of the files. Unloading and reloading will accomplish the same thing as BCHECK (secheck) but it will take longer and require more handholding. The b-tree blocks will generally be about 70% full after either of these rebuilds. Glen Johnson