RE: does delete records free up dbspace?
Hello. it's me again.
I think this is to do with fragmentation. The data you deleted leaves
behind 'holes' in the dbspace.
To get the space back you need to unload the data, drop/recreate the
table and load the data back in.
I'm sure there is a better hi-tech answer but that's the way its been
explained to me.
Regards
Rekaish Bhardwaj
Computer Answers International Limited
9 The Courtyard
Warwick Road
Solihull
West Midlands B91 3DA
United Kingdom
Tel: +44 (0) 121 703 0300
Fax +44 (0) 121 703 0399
Mobile: +44 (0) 498 765424
Email: rekaishb@compans.com
> -----Original Message-----
> From: Yan Zhu [SMTP:yan.zhu@infinity-insurance.com]
> Sent: Wednesday, February 10, 1999 12:34 AM
> To: informix-list@iiug.org
> Subject: does delete records free up dbspace?
>
> hi all:
> I deleted a bunch of records from my database, around 1/3, but
> when
> I do a onstat -d, the dbspace usage remain the same, how could that
> be?
> if that's the case, how could I tell how full my database is at a
> given
> time?
> thanks a lot. btw, i am running 7.22 with solaris 2.6
> yan
>