Are the tablespaces declared as SMS or DMS? It makes a difference, in
that DMS space is allocated as "taken" to the OS. If it is DMS, you can
do an ALTER TABLESPACE TS1 RESIZE (ALL 2000 ) to resize the containers
to a specific size. You can also do an ALTER TABLESPACE TS1 REDUCE (ALL
5000) or some such value.
You need to know (in the case of DMS tablespaces) how many pages have
been allocated to the tablespace. To find this out, you can use the
DB2LOOK utility. Remember to use the -l switch.
If the tablespaces are SMS, a reorg should do the trick.
Mairhtin
"Sue" <se*****@hotmail.com> wrote in news:1105741692.708174.180410
@z14g2000cwz.googlegroups.com:
I have a large database currently using up 30GB of space -- problem is,
I am running out of space on my harddrive and so have to do some
cleanup. One of the tables has a blob field and I find that I can
safely delete some of this blob data because I will not be needing it
in the database anymore.
So the question is, if I delete some of the blob data from this table
will the database size decrease? Is there anything else I can do to
reduce the size of the database?
Thank you so very much for any help with this!