reduce % of used DMS tablespace

[Sue]

Hi, I have a DB2 database with database managed (DMS) tablespaces. One
of the tables that I have contains BLOB data. Recently I noticed that
75% of the tablespace for this table was being used up. So I deleted 50
records from the table freeing about 50 to 100 GB of space. But even
after deleting the records I found that the %age of tablespace used
still remains the same at 75%. What will I need to do to reclaim the
deleted space so that the % of tablespace used is reduced? Thank you
very much.

[fred.sobotka]

If you deleted BLOBs, you will need to run a classic REORG with
LONGLOBDATA to free up the space from the deleted BLOBS. Unfortunately,
the table will be locked from updates while the classic REORG runs,
which, given the data size you mentioned, could take a while.

Good luck,

Fred

[Sue]

Thank you very much for the quick reply -- a classic reorg would mean,
go to the DB2 control panel, select the table, right click on it and on
the menu that shows up select "reorganize"? Also is it a good idea to
select the option "use existing index"? Also online or offline for
better results? Thank you again.

fr**********@gmail.com wrote:

If you deleted BLOBs, you will need to run a classic REORG with
LONGLOBDATA to free up the space from the deleted BLOBS. Unfortunately,
the table will be locked from updates while the classic REORG runs,
which, given the data size you mentioned, could take a while.

Good luck,

Fred

[Pierre Saint-Jacques]

You want to do an offline reorg.
On line requires more time and more log space. Ofline, you can still
specify ALLOW READ
It is the only way that you will BOTH reclaim empty space and resequence
data using the index you name.
It may not be necessary to resequence the data, it depends what the output
of the reorgchk command recommends.

The classic reorg by default does not reorganize and reclaim empty space for
lob data. That's why Sue recoomends using the LOLOBDATA parameter.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Sue" <se*****@hotmail.com> a écrit dans le message de news:
11**********************@f14g2000cwb.googlegroups. com...

Thank you very much for the quick reply -- a classic reorg would mean,
go to the DB2 control panel, select the table, right click on it and on
the menu that shows up select "reorganize"? Also is it a good idea to
select the option "use existing index"? Also online or offline for
better results? Thank you again.

fr**********@gmail.com wrote:

If you deleted BLOBs, you will need to run a classic REORG with
LONGLOBDATA to free up the space from the deleted BLOBS. Unfortunately,
the table will be locked from updates while the classic REORG runs,
which, given the data size you mentioned, could take a while.

Good luck,

Fred