473,232 Members | 1,546 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,232 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 5085
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: and | last post by:
hi everyone, i am using oracle 9.2.0 and i have written a simple jdbc java program to insert a record within a for loop to a table using jdbc thin driver(refer to the bottom of this email for the...
0
by: Pyung Yoon | last post by:
Hi, I have a strange problem with innodb tables. I have about 10 innodb tables, a few of which can have tens of thousands of entries. These huge tables are clean up regularly. But the size of...
1
by: S.J. te Winkel | last post by:
Hi all, I have the following challenge: I want a table with 3 columns, in which -the left one has a maximum width of 470px -the middle one always has a fixed width of 180 px, -and the right...
17
by: Filipe Martins | last post by:
Hello. I've read somewhere that the executable is smaller if we use a source file for each function! So, I tested this with gcc and it seams to confirm! What seams to happen is that if we call...
6
by: Marvin Libson | last post by:
Hi All: I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I have created a java UDF and trigger. When I update my database I get the following error: SQL1224N A database...
3
by: Jesper, Denmark | last post by:
Hi, I've written a somewhat large program over the years (70.000 lines of code). When compiling the program I get a 2MB exe file. When running this program I get an corresponding image in the...
6
by: =?Utf-8?B?bGlnaHRkb2xs?= | last post by:
Hello everyone. i want to know how to decrease the cpu usage in my program. i have to update quickly many data on gui, so i tried to decrease the cpu usage on gui but i couldn't solve the...
3
by: veer | last post by:
hi i have a database in sql server of size 30gb how i decrease the database size but data should not be loos please send some idea varinder
3
by: iheartvba | last post by:
Hi, I have an access mdb file where I have deleted all the queries and forms, but the size of the database is still the same it was 50Mb before and it is still 50Mb now, even after doing a compact...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.