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

Nils Myklebust wrote: > > ianclarkuk@aol.com (IanClarkUK) wrote: > > :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. <snip> > :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 > > I assume this is SE, (was Turbo/Online avaliable as version 2?) and > debexport/dbimport wasn't available this early? <snip> dbexport and dbimport were definitely available with Informix SE 2.10. This would be the fastest alternative.