467,882 Members | 1,212 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,882 developers. It's quick & easy.

Database Size Problem

Dear All,

I have a database whose backup size (without compression) is 756Mb.
The i emptied all data from the tables and took the backup which is again 756Mb.

Can anyone guide me why this happen and how to correct it to bring database size to a reasonable size?

Regard

SaadAli
Aug 11 '07 #1
  • viewed: 956
Share:
3 Replies
docdiesel
Expert 100+
Hi,

when you delete the content, DB2 invalidates the rows inside the tables, but keeps the tables' files as big as they are.

Try a "reorg table" after deleting the data. This should help. Furthermore, as fars as I remember, starting with some version 8.2.x DB2s backup command offers a compression flag.

Regards,

Bernd
Aug 11 '07 #2
Hi Bernd,

Thanks for the reply.

Using the "reorg table" really helped alot.

Now the backup size has reduced to 136Mb.

Regard

SaadAli
Aug 11 '07 #3
I think that this case results from 他和 “high water mark(HWM)”,the size is based on the HWM。
Aug 12 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

19 posts views Thread by dchow | last post: by
9 posts views Thread by Pam Ammond | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.