resizing Informix-SQL tables

Posted in 1991

Walt Hultgren {rmy} — Wed, 29 May 91 11:16:29 EDT — source: Informix-list mailing list archive (1991-1998)

Path: emory!wuarchive!uunet!tiamat!jim From: jim@tiamat.fsc.com ( IT Manager) Newsgroups: comp.databases Message-ID: <841@tiamat.fsc.com> 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 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