Informix V2 - fragmenting tables. Causes and cures. Advice please.

Hi, Once you have stopped laughing at the thought of someone still using Version 2 Informix can you please help me to consider the issue of table fragmentation. A potential client has had an application running on his Unix box for 6 years now. The users run 4gl programs that interact with the database. Am I right in thinking that both data and index tables do fragment? What happens to the space that becomes free when records are deleted? Given that the Version of Informix is early and less likey to have any of the newer, fancier, tools to assist me, will it be necessary to perform the following steps to help clean up the database: - dbschema to a file for recreating database - unload all tables to ascci files - drop database - recreate database from dbschema file - load all tables from ascii files What about system tables that hold details about table columns that must be invisible when used on forms, eg. for password protection? Will I mess anything up with ownership/permission issues? Any comments on the above issue would be very welcome as would any views regarding the general housekeeping of a database to help enhance performance. Cheers, Ian. -------------------------------------------------------------------------- ----------------------------- I used to be indecisive - but now I'm not so sure! -------------------------------------------------------------------------- -----------------------------