471,897 Members | 2,156 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,897 software developers and data experts.

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 4896
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 YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.