Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Problem reducing container size.

  
   Database Help (Home) -> DB2 RSS
Next:  wait for send event  
Author Message
db2dude

External


Since: Jul 23, 2008
Posts: 4



(Msg. 1) Posted: Thu Dec 18, 2008 6:50 am
Post subject: Problem reducing container size.
Archived from groups: comp>databases>ibm-db2 (more info?)
I was hoping that someone might be able to help me with this problem..

We have a filesystem on AIX which contains a bunch of containers for
various tablespaces in our database.

The size of this filesystem as reported by the "df" command shows that
it has 310 GB allocated and 60 GB free..

$ df -gt /db2/SID/data1/NODE0000
Filesystem GB blocks Used Free %Used Mounted on
/dev/vx/dsk/SIDpr/data1 310.00 249.58 60.42 81% /db2/SID/
data1

Now the problem is that several containers inside this filesystem were
reduced and the "actual" sum of all container sizes in this filesystem
is around 199 GB. (There is nothing else inside this filesystem)

So theoretically this filesystem should have 310 GB (allocated) - 199
GB (used) - approx 7% overhead ~ 90 GB of free space.

My question is that where is this additional 30 GB gone?

Is the filesystem fragmented and do we need to do something special to
release this space?

We tried remounting the filesystem but did not get any space back.

The environment is AIX 5.3 TL 6 , DB2 9.5 FP1 ESE.

Thanks in advance for your help.

- SA

 >> Stay informed about: Problem reducing container size. 
Back to top
Login to vote
Ian7

External


Since: Sep 15, 2003
Posts: 228



(Msg. 2) Posted: Mon Dec 22, 2008 11:21 am
Post subject: Re: Problem reducing container size. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
db2dude wrote:

> The size of this filesystem as reported by the "df" command shows that
> it has 310 GB allocated and 60 GB free..
>
> $ df -gt /db2/SID/data1/NODE0000
> Filesystem GB blocks Used Free %Used Mounted on
> /dev/vx/dsk/SIDpr/data1 310.00 249.58 60.42 81% /db2/SID/
> data1
>
> Now the problem is that several containers inside this filesystem were
> reduced and the "actual" sum of all container sizes in this filesystem
> is around 199 GB. (There is nothing else inside this filesystem)

Maybe a dumb question, but did you look in the file system to see if
there are other files taking up space?

 >> Stay informed about: Problem reducing container size. 
Back to top
Login to vote
db2dude

External


Since: Jul 23, 2008
Posts: 4



(Msg. 3) Posted: Wed Jan 07, 2009 9:05 am
Post subject: Re: Problem reducing container size. [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Dec 22 2008, 1:21 pm, Ian wrote:
> db2dudewrote:
> > The size of this filesystem as reported by the "df" command shows that
> > it has 310 GB allocated and 60 GB free..
>
> > $ df -gt /db2/SID/data1/NODE0000
> > Filesystem    GB blocks      Used      Free %Used Mounted on
> > /dev/vx/dsk/SIDpr/data1    310.00    249.58     60.42   81% /db2/SID/
> > data1
>
> > Now the problem is that several containers inside this filesystem were
> > reduced and the "actual" sum of all container sizes in this filesystem
> > is around 199 GB. (There is nothing else inside this filesystem)
>
> Maybe a dumb question, but did you look in the file system to see if
> there are other files taking up space?

No but it looks like veritas filesystem manager (vxfs) pre-allocates
space (causing the disconnect between the ouputs of ls and du). This
space can be reclaimed by issuing setext -r to release the pre-
allocate space...

-SA
 >> Stay informed about: Problem reducing container size. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
db2 size and performance - Hi: We have a database made with Java. The format of the database is the same to DB2. We are concerned about the performance when the database size growing. Our computer configuration is: windows XP, 512M RAM, Intel P3. Could anybody tell how big a..

Table size in bytes - Hi! How can I see the actual size of a table is bytes? I could to a count on table and multiply by page size, but we are using VARCHARs and I'm affraid that is not the correct value. I could also find the file that a table is stored in, but I don't know...

Size of a DB2 database - Hi all, Is there any way to determine the size of a DB2 database without using list tablespaces? I am working on db2 udb 8.2 fp12 on LUW Thanks

size of numeric data - My DBA says that a column defined, for instance, as DECIMAL(11,2) and containing a value of 1.00 takes up no more space on the database disk than a column defined as DECIMAL(7,2) and containing a value of 1.00. I am honestly having a hard time believing...

Getting memory size for an application - Hello, I am running DB2 V8.2 on AIX. I am looking for a way to get the memory size of a specific db2 agent. I have found the db2mtrk tool that gives me a list of all the applications and heap sizes. Also there is "DB2 Snapshot for Application&quot...
   Database Help (Home) -> DB2 All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]