Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: CLOB and reclaiming disk space (v9 LUW)

    Hi,

    i got a huge table with a CLOB column, each CLOB contains about 1MB of data.
    I now have the ability to clear out the CLOB data, ie set the clob column to null. However i still need to preserve the other data in the row, so i can't delete the actual row.

    If i set the CLOB column to null, will the diskspace that the CLOB data occupied be reclaimed automatically or do i need to reorg etc?


    Best Regars from a DB2 Newbie

  2. #2
    Join Date
    Mar 2009
    Posts
    2

    Anyone?

    Can anyone plese point out were to find information about this?
    (Assuming the question was to basic,"go RTFM" yourself..
    )

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    What is the most natural answer to you? This is what DB2 will do. The space is freed and can be used for other data.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ...unless, of course, the table is in a DMS tablespace, in which case the space _within_ the container(s) will be marked free, but the disk space will not be released automatically. And this is not specific to CLOBs.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    The question is what you imply by "reclaim". ;-)
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by hg777
    Can anyone plese point out were to find information about this?
    (Assuming the question was to basic,"go RTFM" yourself..
    )
    In the sense that you mean it, you need to do a reorg. But even then, you may not be completely satisfied, depending on your expectations.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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