Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Posts
    4

    Unanswered: Free up more dbspaces

    Hi,

    Just wondering when you delete records, does it free up the dbspaces. Do I need to follow up with some other syntax after I did a DELETE FROM statement.

    Currently my rootdbs is around 99% full and I am concern about adding new chunk to the rootdbs.

    I am using Informix 5.02 on HP-UX.

  2. #2
    Join Date
    Aug 2005
    Posts
    140
    Hi...I dont know how it works with version 5, but
    in IDS 9 and 10 once the database server allocates disk space to a tblspace as part of an extent, that space remains dedicated to the tblspace. Even if all extent pages become empty after you delete data, the disk space remains unavailable for use by other tables.
    So...when you delete rows in this table, the database server reuses that space to insert new rows into the same table BUT not into other tables !

    You have to rebuild the table use any of the following:
    ALTER INDEX(with the TO CLUSTER clause) if the table includes an index
    UNLOAD and LOAD
    ALTER FRAGMENT

    See Informix SQL manuals for details.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •