Re: How to tell DBSpace Available?

Posted in 1996

Kate Tomchik/IS/SSC/THD@emory.mathcs.emory.edu — 19 Aug 1996 14:43:24 -0400 — source: Informix-list mailing list archive (1991-1998)

create a clustered index and the system will be forced to rewrite the whole table and release all unused disk. PROBLEM, it will need twice the space currently used by the database to do this. Second solution, unload the file to tape drop and recreate, and reload, this reclaims the space. Third, order Platinum or some other tool to do all these things for you.