Record deleted but space still not freed.

Before I do record purging for a table, I keep a copy of "oncheck -pe" result. After I purged the records. I keep another copy of "oncheck -pe". Although there has been many records being deleted from the table. Why there is no different on the output(free size column) from "oncheck -pe"(before purge and after purge) for that particular table ? The space will only be released when I do a dbexport, drop the table then dbimport the table. Is there a command to release the deleted record's space back to the dbspace pool ? Rather then doing the dbexport/dbimport task. And also there are many free gaps in between the tables in the "oncheck -pe" output. Will it affect the performance ? How to get rib of the gaps(defragment) ?

kh teoh wrote: > Before I do record purging for a table, I keep a copy of > "oncheck -pe" > result. After I purged the records. I keep another copy of "oncheck > -pe". Although there has been many records being deleted from the > table. Why there is no different on the output(free size column) from > "oncheck -pe"(before purge and after purge) for that particular table > ? The space will only be released when I do a dbexport, > drop the table > then dbimport the table. Is there a command to release the deleted > record's space back to the dbspace pool ? Rather then doing the > dbexport/dbimport task. > > And also there are many free gaps in between the tables in the > "oncheck -pe" output. Will it affect the performance ? How to get rib > of the gaps(defragment) ? There is no way other than doing unload/drop table/create again/reload of data or dbexport/dbimport. Performance- In OLTP it is good to have gaps but in dataware housing it is not good. So depends. --Ganesan. --Ganesan. -- Direct access to this group with http://web2news.com http://web2news.com/?comp.databases.informix To contact in private, remove n-5o+sp1p3amm