Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Location
    New York
    Posts
    248

    Unanswered: data in Informix SE

    Guy's please help

    Never had to deal with SE. I client is running out of space on the file system that holds the tables, I deleted about 300,000 records from one of the tables and the file size of the file that is specified in the dirpath of systables did not change a bit. Neither is df -k output

    Is there a command I need to issue after I delete rows from a table to reclaim the space?

    Please help, have no Idea about SE

  2. #2
    Join Date
    Jun 2006
    Posts
    3
    you will either have to unload, drop, recreate the table and load to recover the space. I think if you alter an index to cluster it will also force the table to be rewritten. Rows are just marked as deleted, not physically rewritten - would be a bit hectic to re-write a million record for one deletion!

  3. #3
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    Thank you for the responce

Posting Permissions

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