Re: Record deleted but space still not freed.
Posted in 2003
Topics: Performance & Tuning, Storage & Space Management, Migration, Import/Export & Data Conversion, Clustering, Grid & MACH11
Do an alter index to cluster to release the unused
space from the tablespace or fix the extents that
means have a new copy of the table with fixed extents
and drop the old one.
--- kh teoh <khteoh2001@yahoo.com> 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) ?
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
sending to informix-list