Path: utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!uunet!mcsun!ukc!slxsys!ibmpcug!jasper
From: jasper@ibmpcug.co.uk (Jasper May)
Newsgroups: comp.databases,connect.audit
Subject: Query: Contracting Informix SQL files to free up wasted space.
Keywords: Informix SQL
Message-ID: <1991May27.200227.19625@ibmpcug.co.uk>
Date: 27 May 91 20:02:27 GMT
Organization: The IBM PC User Group, UK.
Lines: 22



	I am looking for a way to contract Informix SQL (C-ISAM ?) files that 
have empty space in them where many records have been deleted. To date the only
way I have found is to unload the table, drop it, recreate it and then 
reload the data. However, as the majority of the data that I am using
is maintained within a 4GL manufacturing package using Informix compatible
files that are linked (UNIX ln) with a namesake in an Informix .dbs directory,
this is to say the least a major pain.
	For background info, in case it matters, I am running UNIX SVR3.2d on 
an Altos 2000, with free disk space up to about 10 times the largest file to be
contracted. The Informix version I forget - purchased 1991 - 2.01.03b ?
	Any help that anyone can offer would be greatly appreciated,
                     Thank You,  Jasper.
-- 
Automatic Disclaimer:
The views expressed above are those of the author alone and may not
represent the views of the IBM PC User Group.
-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|   Jasper May  -  jasper@ibmpcug.co.uk  | ...!uunet!ukc!ibmpcug!jasper  |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~