IBM DB2 9.7 Backup Data Size

I have successfully migrated IBM DB2 ESE 8.2 database to IBM DB2 9.7 Fixpack 3a. I observe that  my database size almost  8 to 9 Mb increased on IBM DB2 9.7.
After no any changes in the data, every time when I take backup, the backup size increase 8MB to 9MB almost [IBM DB2 9.7].

I am very worry about that please advise me.

Regards
Iqtedar
sgoganAsked:
Who is Participating?
 
sgoganConnect With a Mentor Author Commented:
Hi All,

Problem resolved!

I missed the one of my table index to compress, After that there is no change in the database backp size in my scenario.

Thanks,
Iqtedar
0
 
momi_sabagCommented:
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
0
 
sgoganAuthor Commented:
hi Momi,

We are already using the Compression on Table level.

Regards,

Iqtedar
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
momi_sabagCommented:
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

0
 
gmarinoCommented:
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.
0
 
tliottaCommented:
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
0
 
sgoganAuthor Commented:
Solved My Prob.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.