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!
2  5245 
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
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*****@hotmai l.com> wrote in news:1105741692 .708174.180410
@z14g2000cwz.go oglegroups.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! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 sql statement). Using
the same program, when i insert 20000 records from 1 process, time is
about 100 seconds. However, when i insert 1000 records from 20
process, time is about 1000 seconds, which is 10 times.
Since i am developing a OLTP system...
|
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 ibdata1 remained same even after the tables were
dropped. Funny thing is that as new entries are added into the newly
created tables, the size of ibdata1 increases. And eventually exhausts
the disk space.
|
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 one fills the remaining part of the screen.
When you resize the window (smaller, or with a smaller resolution) I
|
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 a function from a source-files that defines 3 others, the
linkers includes the code of all the 4 functions, even if the on we call
doesn't rely on the others!
What do you people think about this?
|
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 agent could not be started to service a request,
or was
terminated as a result of a database system shutdown or a force
command.
| | |
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 task manager showing a 40 MB memory
allocation . Yes, the program allocates memory dynamicaly, but no where near
this amout of memory. Of cause I expect some .net stuff is probably also
contained in this allocation. However, if reinstantiating the...
|
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 problem.
i found the code with probloem why the cpu usage increased by debug..
|
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
|
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 and repair. The tables are all linked so I wouldn't think they should affect the size of the database. How do I make it so if I delete an object the size of the database decreases accordingly?
Thanks
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
