Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!crdgw1!uunet!tiamat!jim
From: jim@tiamat.fsc.com ( IT Manager)
Newsgroups: comp.databases
Subject: resizing Informix-SQL tables
Message-ID: <841@tiamat.fsc.com>
Date: 29 May 91 11:46:53 GMT
Organization: Ahlstrom Filtration - Chattanooga,TN
Lines: 25

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
remove table
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
Ahlstrom Filtration, Inc.		615/821-4022 x. 651