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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sgoganAuthor Commented:
Solved My Prob.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.