Re: Cutting the Database file size

vanhornk@rintintin.Colorado.EDU (Leif Van Horn) writes: > I have some database files that have been accumulating data >for about two years and I would like to make them smaller. I have >deletet items from before last year and did a re-indexing but the >file is still 38Megs. I can't find a way to make the size smaller. You'll need to UNLOAD the tables, drop them, and them LOAD from the unload files. It appears that Informix does not reduce the file size when a deletion happens. Instead, it keeps the freespace to speed insertions. This is fine until you delete a sizable portion of your data and want the space back. -- ************************Fight the Clipper (wiretap) chip*********************** Jim Holthaus james-holthaus@uiowa.edu --------PGP 2.2 public key available via finger or from public keyserver-------