CLOB and reclaiming disk space (v9 LUW)

hg777 · #1 (**permalink**) 03-04-09, 08:43

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

hg777 · #2 (**permalink**) 03-09-09, 11:01

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

stolze · #3 (**permalink**) 03-10-09, 04:52

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.

n_i · #4 (**permalink**) 03-10-09, 11:52

...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.