Re: Informix DB Reorganisation

Posted in 1997

Art S. Kagel — Mon, 17 Nov 1997 13:47:29 -0500 — source: Informix-list mailing list archive (1991-1998)

Information Systems wrote: > > We are running Informix 5 on DGUX 4.11. What is the best way to perform a > database reorganisation or defragmentation? Unload and reload or, if you have the disks, create new tables, with larger extent and next sizes in the new dbspace, copy the data to the new table, rename old and new tables, and drop the old table after verifying the data. The original disk space is now free for more reorgs. If you go through this process one table at a time the table will only have one extent per chunk that it spans. Art S. Kagel