IDS Forum

RE: Space Recalamation

Posted By: Support Informix
Date: Monday, 21 November 2005, at 4:02 a.m.

In Response To: RE: Space Recalamation (Jack Parker)

From IDS9.40 use the SQL statement "TRUNCATE table".
Other idea is to cluster the table :
"alter fragment on table <tabname> init on <dbspace>"

mvg,
yves

-----Original Message-----
From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org]
Sent: 20 November 2005 19:41
To: ids@iiug.org
Subject: RE: Space Recalamation [6015]

That's what I hate about getting older and losing my eyesight. I missed the
phrase 'ALL THE ROWS'. Esteban is quite correct.

- sigh -
j.

-----Original Message-----
From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On
Behalf Of Esteban Cas....
Sent: Sunday, November 20, 2005 1:02 PM
To: ids@iiug.org
Subject: Re: Space Recalamation [6014]


Dejan,

delete will delete all rows but the extent for that table will still be
there and that is why you see the same onstat -d output.

oncheck -pt to see partition info ( table info )

if you wan to reclaim the space you have to drop the table.

Additionally, you will see that is cheaper and faster to drop the table
with all the rows than 1) delete the rows and then drop the table.

regards
esteban.-

DEJAN STOJC.... wrote:
> Here is one beginer's question:
> For example when I delete all the rows from a table residing in a dbspace,
space "freed" with the deletion of those rows is not reclaimed to dbspace
but continue to be table's "ownership". Consecuently, there is no change in
onstat -d output for free space in this particular dbspace.Free space in
this dbspace is just the same as it was before.
> What statement should I use in order to give free space in table's segment
to dbspace?
> Thanks.
>
>





___________________________________________________________
1GB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar
*****DISCLAIMER*****
Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde en
vertrouwelijk. Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en
de verzender te verwittigen. Openbaring, vermenigvuldiging, verspreiding en verstrekking aan
derden is niet toegestaan, tenzij anders vermeld. Aangezien internet de integriteit van dit
bericht niet kan verzekeren, kan de Dienst Vreemdelingenzaken niet verantwoordelijk gesteld
worden indien dit bericht gewijzigd is.
Bezoek onze website: http://www.dofi.fgov.be
----------------------------------------
*****DISCLAIMER*****
Ce message et toutes les pieces jointes sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le
detruire et d'en avertir l'expediteur. Toute utilisation de ce message non conforme a sa
destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message,
l'Office des Etrangers decline toute responsabilite au titre de ce message, dans l'hypothese
ou il aurait ete modifie.
Visitez notre site web: http://www.dofi.fgov.be

Messages In This Thread

• Space Recalamation
  DEJAN STOJCEVSKI -- Sunday, 20 November 2005, at 12:08 p.m.
  • Re: Space Recalamation
    Esteban Casuscelli -- Sunday, 20 November 2005, at 1:01 p.m.
    • RE: Space Recalamation
      Jack Parker -- Sunday, 20 November 2005, at 1:40 p.m.
      • RE: Space Recalamation
        Support Informix -- Monday, 21 November 2005, at 4:02 a.m.
        • RE: Space Recalamation
          Hamilton, Jerry -- Monday, 21 November 2005, at 10:45 a.m.
          • Fwd: RE: Space Recalamation
            ART KAGEL, BLOOMBERG/ 731 LEXIN -- Monday, 21 November 2005, at 11:50 a.m.
            • Re: Fwd: RE: Space Recalamation
              Esteban Casuscelli -- Monday, 21 November 2005, at 1:29 p.m.
  • Re: Space Recalamation
    ART KAGEL, BLOOMBERG/ 731 LEXIN -- Monday, 21 November 2005, at 10:04 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.