473,569 Members | 2,759 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

reclaim disk space

does a command like,
db2 drop table tabschema.tabna me when run from the Aix prompt reclaim
the disk space? Are there any other options? How can we make sure the
disk space is reclaimed?
Thanks,
Yasaswi
Nov 12 '05 #1
5 7542
ya*****@encfor. com (Yasaswi Pulavarti) wrote in message news:<aa******* *************** ****@posting.go ogle.com>...
does a command like,
db2 drop table tabschema.tabna me when run from the Aix prompt reclaim
the disk space? Are there any other options? How can we make sure the
disk space is reclaimed?
Thanks,
Yasaswi


Do you mean reclaim within the tablespace? or do you mean reclaim
within the file system?

If the tablespace is SMS you will reclaim space within the file
system.

If it is DMS it will reclaim space within the tablespace for other
tables/indexes to be created within the same tablespace, but it will
not reclaim space for the file system.
Nov 12 '05 #2
I think it will reclaim the space, you can have a look at the
tablespace and find out if the number of free pages (DMS) increases or
not. However, the OS/filesystem will not report any reduction in
comsumed space, as in DMS the space is preallocated to them.

db2 "list tablespaces show detail"

Used pages = 171115
Free pages = 21035

Incase of SMS, you should simply see a decrease in the number of used
pages. I think the OS/filesystem will reflect this reduction.

Probably, someone else can further point out on this one.

hth,
dotyet

ya*****@encfor. com (Yasaswi Pulavarti) wrote in message news:<aa******* *************** ****@posting.go ogle.com>...
does a command like,
db2 drop table tabschema.tabna me when run from the Aix prompt reclaim
the disk space? Are there any other options? How can we make sure the
disk space is reclaimed?
Thanks,
Yasaswi

Nov 12 '05 #3
Hi Mark:
So it there a command to force DMS to reclaim space on the OS as well?
Or by very definition that space is preallocated to DMS tablespaces, I
can never reclaim OS space on filesystem or specifically in the
"container" .
Thanks,
Yasaswi

-------------------------

m0****@yahoo.co m (Mark) wrote in message news:<a5******* *************** ****@posting.go ogle.com>...
ya*****@encfor. com (Yasaswi Pulavarti) wrote in message news:<aa******* *************** ****@posting.go ogle.com>...
does a command like,
db2 drop table tabschema.tabna me when run from the Aix prompt reclaim
the disk space? Are there any other options? How can we make sure the
disk space is reclaimed?
Thanks,
Yasaswi


Do you mean reclaim within the tablespace? or do you mean reclaim
within the file system?

If the tablespace is SMS you will reclaim space within the file
system.

If it is DMS it will reclaim space within the tablespace for other
tables/indexes to be created within the same tablespace, but it will
not reclaim space for the file system.

Nov 12 '05 #4
I think you got it wrongly interpreted.
SMS -
As you drop a table, the table is actually a file in the SMS drirectory
container and the file is erased and the space is immediately reclaimed
at the file system level.
DMS-
Since the container is either a file or a raw device, the space WITHIN
that file is immediately reclaimed and made available but only to the
objects that have been created using that tablespace.
Since the file system space is allocated at creat tablespace time and
remains fixed unless you alter tablespace, then the sdpace NOT reclaimed
at the file system level.

To reclaim DMS dropped tables space from the file system in a DMS
container, you will have to "play" with the High Water Mark of the
containers and with the alter tablespace option of reduce or drop.
HTH, Pierre.

Yasaswi Pulavarti wrote:
Hi Mark:
So it there a command to force DMS to reclaim space on the OS as well?
Or by very definition that space is preallocated to DMS tablespaces, I
can never reclaim OS space on filesystem or specifically in the
"container" .
Thanks,
Yasaswi

-------------------------

m0****@yahoo.co m (Mark) wrote in message news:<a5******* *************** ****@posting.go ogle.com>...
ya*****@encfo r.com (Yasaswi Pulavarti) wrote in message news:<aa******* *************** ****@posting.go ogle.com>...
does a command like,
db2 drop table tabschema.tabna me when run from the Aix prompt reclaim
the disk space? Are there any other options? How can we make sure the
disk space is reclaimed?
Thanks,
Yasaswi


Do you mean reclaim within the tablespace? or do you mean reclaim
within the file system?

If the tablespace is SMS you will reclaim space within the file
system.

If it is DMS it will reclaim space within the tablespace for other
tables/indexes to be created within the same tablespace, but it will
not reclaim space for the file system.


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #5
ya*****@encfor. com (Yasaswi Pulavarti) wrote in message news:<aa******* *************** ****@posting.go ogle.com>...
Hi Mark:
So it there a command to force DMS to reclaim space on the OS as well?
Or by very definition that space is preallocated to DMS tablespaces, I
can never reclaim OS space on filesystem or specifically in the
"container" .
Thanks,
Yasaswi

The containers in a DMS tablespace are pre-allocated to the OS.
However, you can reduce the size of containers in V8 (see "alter
tablespace" SQL statement). If you need to reduce the size of
containers to below the high-water mark, you may need to run db2dart
command (see the /LHWM option).
Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
6291
by: Jas Shultz | last post by:
I'm using Win2K3 Enterprise edition with the latest .NET framework installed. I have this problem with getting "out of disk space" errors. It doesn't happen all the time but it does happen. When I installed Sharepoint Services I got the error and had to reboot and then everything was fine. I get it sometime when running aspx pages. It's...
1
4469
by: Paul | last post by:
Hi: I am totally new in Sun Solaris. I am not sure someone would like to tell me how to rellocate Sun Solaris disk space where oracle installed? I installed Oracle 8i in Sun Solaris and set Oracle main table space called TABLES in unix disk space /dpp/live01. From the following, it's quite easy to see that the disk space of /dpp/live01...
2
3210
by: Sagar Choudhary | last post by:
Is there any exception related to disk space ? If not how else can we check the availability of the disk space in a c++ program. I know ostream helps a bit. When we try to open a file when there's no disk space ostream::rdstate() returns badbit.
6
2071
by: Anthony Robinson | last post by:
I am trying to instal FixPak 4 for V8 on XP. I kept getting an error. During the install, I kept getting the "low disk space on c:" message. My C; drive has 1.4 GB of free space. I can't believe that installing a fixpak (temp files and all) would take up over aGB of space - but it is!!! How can I get this installed? All the programs that...
12
10991
by: New World Order Pigs | last post by:
Is there no way in .net to get disk space remaining for a given drive??? I can't believe it and yet is seems to be so. If someone knows of a way to do this in the .net libraries I'd be very much appreciative. Thanks, LT.
0
2480
by: Jas Shultz | last post by:
I'm using Win2K3 Enterprise edition with the latest .NET framework installed. I have this problem with getting "out of disk space" errors. It doesn't happen all the time but it does happen. When I installed Sharepoint Services I got the error and had to reboot and then everything was fine. I get it sometime when running aspx pages. It's...
3
1881
by: A P | last post by:
Hi, I am loosing disk space and wanting to install .Net Framework on my W2KSP4 Server. I only have 400MB available, is this enough for me to install .Net Framework? Me
5
2526
by: Nacho | last post by:
Hello, I tried to make what one reply advice to recover the disk space after DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table but nothing changes. Any other solution? Ignacio
0
3896
by: DannielHS | last post by:
- Windows created the low disk space warning to alert computer users when their hard drive is running low on available disk space. Then you will see on a fairly regular basis as your hard drive fills up is the Low Disk Space warning in SBS Server: "You are running out of disk space on Local Disk . To free space on this drive by deleting old or...
0
7698
marktang
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...
0
7612
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...
0
7924
Oralloy
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. ...
1
7673
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...
0
7970
tracyyun
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...
1
5513
isladogs
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...
0
3640
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1213
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
937
bsmnconsultancy
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...

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.