Re: table extents cleanup

}-- Mark Blum (markb@raysfood.com) Wrote: } }>> We use Informix Online 5.05. Does anyone know of 3rd party software or }>> another way of doing table extents cleanup. We are currently using }>> dbschema and unloading to a file, re-creating the table with larger }>> numbers then re-loading the table. } }I don't know if this works for Online 5, but creating a clustered index }(or altering an existing index TO CLUSTER) will reconstruct the table }into a single extent, if possible. This is a nice trick, since it even }works on the system tables. Just drop the index (or alter to NOT CLUSTER) }when done. }Paul Kapp ----> PLKapp@aol.com -OR- plk@interactive.visa.com } The problem with the cluster index approach is: you have to have a lot of free space in your dbspace in order to accomplish that. Why don't Informix provide us DBAs an utility to reorganize tables (or dbspaces) ? I've got to deal with this stuff often in volatile tables. Roberto Trevisol rtrevisol@bamerindus.com.br