Re: informix problem about deleting records

and wrote: > > **** Post for FREE via your newsreader at post.usenet.com **** > > hi, everyone > i come across a problem using informix dynamic server 7.2 online on > SCO-UNIX. When inserting data to table, the dbspace increase(view by > onstat -d, of course this is correct). However, when deleting records from> table, the dbspace DO NOT decrease(also viewed by onstat -d). As a result, > the dbspace explose and all i can do is unload data, drop table(all dbspace > of the table is free) and load the data back again. > Does anyone know how to tackle that problem? > Thanks You are not seeing a problem, but are rather misunderstanding the way Informix allocates table space. RTFM with keyword "Extent" and you will be enlightened ... Brett Randall > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** > http://www.usenet.com > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=