RE: identify free space

Sounds like you want not so much to identify free space as to recover it. To do that, the ONLY way is to rebuild the table. What commands you choose to issue to accomplish this is for you to decide - unload/reload, alter index to cluster whatever. Perhaps the thing to do is look at your data purging process and determine if you can fragment the table, so that instead of deleting rows you wind up detaching/dropping fragments instead. cheers j. > -----Original Message----- > From: Tham Huei Hwan [mailto:hhtham@apis.dhl.com] > Sent: Tuesday, January 16, 2001 3:45 AM > To: informix-list > Subject: identify free space > > > hi all, > > I would like to know how to find out the free space on dbspaces after > the data purging ? Because this doesn't show on "onstat -d" > and "oncheck > -pe". > > Others than rebuild table (load/unload) and alter index to cluster to > free up the space (very time consuming for large tables). Is there any > other command to check free space on chunks/dbspaces ? > > > Thanks and regards, > > Tham >