469,609 Members | 1,666 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

Decrease database size

Sue
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!

Nov 12 '05 #1
2 4712
Sue:

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?


Reorganize after the delete. After delete, the space will not be released,
it is just available for new records.

Joachim
Nov 12 '05 #2
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!


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by S.J. te Winkel | last post: by
17 posts views Thread by Filipe Martins | last post: by
3 posts views Thread by Jesper, Denmark | last post: by
6 posts views Thread by =?Utf-8?B?bGlnaHRkb2xs?= | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.