By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

Excessive physical space usage, DB2 9 on Linux

P: n/a
The filestore is filling up rapidly, I'm not archiving logs.

It appears that the data files for the database are just growing.

This is some output from list tablespaces show detail:

Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table
space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 2971200
Useable pages = 2971168
Used pages = 2971168
Free pages = 0
High water mark (pages) = 2971168
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1

So that's 12GB right there. There's no way there's 12GB of data in this
database, as an example, were I to import this data into Oracle, it
would occupy < 2GB.

The data in most of the big tables has been deleted and re-inserted many
times over the last couple of weeks and I suspect this is the cause.

Some extra data points:

db2 =select sum(npages) from sysibm.systables where creator='DB2' and
name like 'T%'

1
--------------------
70419

db2 =select sum(nleaf) from sysibm.sysindexes where creator='DB2'

1
--------------------
55467

How can I reduce the ammount of space allocated on disk? Currently the
disk is 100% full, and there's no more to add from the LVM so that's
about that for now!
Oct 15 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Gary wrote:
The filestore is filling up rapidly, I'm not archiving logs.
D'oh. It appears that some event logging tables are huge in that TS and
they don't correspond with my table naming convention (obviously) so I
never noticed them.

I dropped the tables (couldn't issue delete statements as DB/2 reported
that the disk was full so it couldn't delete the rows :-| )

Just need to shrink the container file now...
Oct 15 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.