Hi, I have a DB2 database with database managed (DMS) tablespaces. One
of the tables that I have contains BLOB data. Recently I noticed that
75% of the tablespace for this table was being used up. So I deleted 50
records from the table freeing about 50 to 100 GB of space. But even
after deleting the records I found that the %age of tablespace used
still remains the same at 75%. What will I need to do to reclaim the
deleted space so that the % of tablespace used is reduced? Thank you
very much.
3  2059 
If you deleted BLOBs, you will need to run a classic REORG with
LONGLOBDATA to free up the space from the deleted BLOBS. Unfortunately,
the table will be locked from updates while the classic REORG runs,
which, given the data size you mentioned, could take a while.
Good luck,
Fred
Thank you very much for the quick reply -- a classic reorg would mean,
go to the DB2 control panel, select the table, right click on it and on
the menu that shows up select "reorganize "? Also is it a good idea to
select the option "use existing index"? Also online or offline for
better results? Thank you again. fr**********@gm ail.com wrote: If you deleted BLOBs, you will need to run a classic REORG with
LONGLOBDATA to free up the space from the deleted BLOBS. Unfortunately,
the table will be locked from updates while the classic REORG runs,
which, given the data size you mentioned, could take a while.
Good luck,
Fred
You want to do an offline reorg.
On line requires more time and more log space. Ofline, you can still
specify ALLOW READ
It is the only way that you will BOTH reclaim empty space and resequence
data using the index you name.
It may not be necessary to resequence the data, it depends what the output
of the reorgchk command recommends.
The classic reorg by default does not reorganize and reclaim empty space for
lob data. That's why Sue recoomends using the LOLOBDATA parameter.
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Sue" <se*****@hotmai l.com> a écrit dans le message de news: 11************* *********@f14g2 00...legr oups.com... Thank you very much for the quick reply -- a classic reorg would mean,
go to the DB2 control panel, select the table, right click on it and on
the menu that shows up select "reorganize "? Also is it a good idea to
select the option "use existing index"? Also online or offline for
better results? Thank you again.
fr**********@gm ail.com wrote: If you deleted BLOBs, you will need to run a classic REORG with
LONGLOBDATA to free up the space from the deleted BLOBS. Unfortunately,
the table will be locked from updates while the classic REORG runs,
which, given the data size you mentioned, could take a while.
Good luck,
Fred This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: sandeep G |
last post by:
I've a table which has a number & a blob column, both of which are NOT
NULL type. This table is composite partitioned using range & hash on
the same column.
Each partition is sub partitioned into two.
Now if I try to move the partitions to a different tablespace I get an
oracle error sayiing that ERROR: ORA_14257 cannot move partition other
than a Range or Hash partition
Now is there any other way to move the partition to another
|
by: Jens H. Hamann |
last post by:
Hi, I am having a strange problem with the storage parameters in Oracle
9.2.0.1 database.
I create a tablespace with some default storage parameters but when i am
adding a table to the tablespace i can not override the NEXT statement?
No matter what i set the NEXT storage parameters to, it is always the same
as the tablespace default, the INITIAL is overriden just fine.
I have included my script below, can someone please point out what...
|
by: tracy |
last post by:
hi,
i need advise and guidance from experts.
Today, I discovered about 1464 tables created in SYSTEM tablespace and
the owner is dev_user.
As, i read from ORACLE 101 DBA's it said :'System tablespace is a
tablespace user to stored objects belong to user SYS only. if, we do
not ensure this, the SYSTEM tablespace will :
• Tend to get very fragmented
• Have potentially severe contention against it and affect performance
|
by: maricel |
last post by:
Could someone confirm which tablespace is being used when running ALTER &
CREATE INDEX.
Is it the tempspace or the tablespace where the table resides?
Many thanks,
maricel
|
by: robert |
last post by:
just got out of a "class" on EXPLAIN, from a 390/v6 maven. was told
that ACCESSTYPE = 'R' in the plan_table meant a TableSpace scan.
hmmmm. next step up (or down, depending on your outlook) wasn't a
Table Scan.
thought this might be a MainFrame thing; but a look at DB2Info on my
UDB 7.2 server showed the same thing.
this is truly puzzling. is there an explanation of EXPLAIN which
describes how to get a Table Scan???? or are we...
| | |
by: Raghava |
last post by:
hi all,
i was working on DB2 and came across an issue. i.e. can a tablespace be
rollforwarded to POINT-IN-TIME?
the scenario is as follows:
i created a data base and a tablespace in it.
i have enabled archival logging (enabled userexit and logretain) and
changed log path to a different location.
as the log path and logging method was changed, the database was in
backup pending state. so, i took a complete offline backup of the
|
by: Asphalt Blazer |
last post by:
How can you reduce high water mark of a DMS tablespace? I have
tablespace quite huge, but I dont need it thatt size anymore. There is
no way though to reduce the ts size as the highwater mark is close to
the max TS size. If nybody knows how let me know. Thanks
|
by: Reshmi Jacob |
last post by:
Hello..........
My user tablespace which I used before for all transactions is now about 8 GB of my Harddisk. I have dropped users & objects but still the same size. I went to DBA studio and tried to decrease the size, but it is saying the size is too small to contain data. I am sure that this tablespace has not much data now. Does oracle have some way to COMPACT this.
I am a beginner hence, pls explain the solution....
Thanks &...
|
by: rajdb2 |
last post by:
How to reduce the highwatermark for a DMS tablespace in V8.2? I have
tried doing classic reorg on the table in the tablespace twice, but
the highwatermark is lowered. Any ideas?
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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...
| |
