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

Database Size Problem

P: 3
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
Share this Question
Share on Google+
3 Replies


docdiesel
Expert 100+
P: 297
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

P: 3
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

P: 7
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.