Database Size Problem

SaadAli

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

docdiesel

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

SaadAli

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

myprotein

I think that this case results from 他和 “high water mark（HWM）”，the size is based on the HWM。

Aug 12 '07 #4