informix resizing

>Date: 29 May 91 11:46:53 GMT >Organization: Ahlstrom Filtration - Chattanooga,TN > >Under Informix 3.3, if I wanted to re-size the physical files in which >Informix table data was stored (e.g. table.dat and table.idx), I could >run > >$ dbbuild -r schemafile> >and during the rebuild process file space would only be used for the >records which were actually in the table (i.e. file space used by >"deleted" records would be freed). > >Is there a similarly simple process under Informix-SQL 4.0? I realize that >the process > >unload data >create table >load data > >should do the job, but if there's any "one step" method, I'd love to >know. > >Thanks. >------------- >James B. O'Connor jim@tiamat.fsc.com Jim, I have been using the ALTER tablename MODIFY columnname. Where the MODIFY is actually not changing the column definition. It is just forcing a rebuild with NO changes to the table. Pick a column in the table and enter it in the MODIFY section of the command, but do not change the definition. My understanding of the ALTER index CLUTER command is that it does work, but it also takes longer than the ALTER/MODIFY. If your table is relatively static this might be better. But if the table is dynamic, the order of your table is going to be messed up thereby needing to be maintained more frequently. I hope this is useful.