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

IanClarkUK wrote: > 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 > Its been a long time, and I can't be exact with the version (may have even been 1.10), but I remember having to rebuild data and tables on an SE database by altering the lengths of character index fields. e.g. A character index field is char(20). Altering to char(21) and then back to char(20) rebuilds the indexes and data (twice) for the table. If this works for you, then you wont need to worry about the system catalogue information. Someone wiser will likely point out what's wrong with this method, but I dont recall having any problems at the time. Good luck.... Bryan Tonnet