IBM DB2 9.7 Backup Data Size

nothing to be worried about
ibm probably changed internal structures that got the file a bit bigger
if you wish to save space on your backups, you can use the compress parameter

hi Momi,

We are already using the Compression on Table level.

Regards,

Iqtedar

db2 have a feature that allows you to compress the backups (not related to table compression)
so in your backup command, you can use the compress keyword

The expansion is most likely due to the increase in size of the System Tables in V9 and the additional system objects that did not exist in V8.  

You may not realize it, but 90% of the time spent during the upgrade was the creation of the V9 System Tables (SYSIBM schema, etc) and the conversion/load of the old V8 system table data into the new Tables.

8-9 MEGA Bytes is nothing to be concerned about.

I observe that  my database size almost  8 to 9 Mb increased on IBM DB2 9.7.

Is that an observation against database size or the size of a resulting backup?


After no any changes in the data, every time when I take backup, the backup size increase 8MB to 9MB almost...

To me, that means that the second backup is 8-9 MB larger than the first, and the third backup is 16-18 MB larger than the first, and the fourth is 24-27 MB larger, etc.

The increasing size of the backup does not seem to be caused by addition of data to the database.

Is that a fair description of your problem?

Tom

Solved My Prob.