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

db2 Incremental backup

P: n/a
Hi all.

Yesterday we decided to switch from full online nightly backups to the
following schema:
sun: full online
mon-sat: incremental online.

Important to note; we don't use deltas.

Well it seems to work.
But one thing amazes me. Normally, our nightly backups are about 65GB of
size... But the first increment since the last full backup (we started
with a full backup on wednesday morning) was 45GB of size.

I'm kinda puzzled by the fact that on a 66GB database the increment is
45GB over a 24hour timespan.

I'm not sure if our applications would generate that much inserts and
alterations, but before I start pulling apart our software, I'd like to
know some extra info about the internal workings of incremental backups.

My question:
Is an incremental backup an overview of differences compared to the last
full backup (so unaware of the transactions, but just a blueprint of the
differences of the last full backup and this backup), or is an
incremental backup a collection of changes since the last backup (so a
restore is just a replay of transactions since the last full backup)?

Btw. Any ideas on why our increment COULD be this size is also appreciated.

Kind regards.

-R-
Sep 27 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Jurgen Haan wrote:
... nightly backups are about 65GB of
size...

... the fact that on a 66GB database the increment ...
Please ignore minor fluctuations in backups size in my previous story :P
~65-66GB. I have not yet met my daily coffee quota.

-R-
Sep 27 '07 #2

P: n/a
Hmm.. in addition to my previous question;

Is all LOB data included in incr. backups, regardless of changed of
LOBs? Because the database DOES have a lot of large objects.
Sep 27 '07 #3

P: n/a
On Sep 27, 11:27 am, Jurgen Haan <jur...@fake.domwrote:
Hmm.. in addition to my previous question;

Is all LOB data included in incr. backups, regardless of changed of
LOBs? Because the database DOES have a lot of large objects.
Hi,

If any changes happened to the LOB data, then it will also be included
in the incremental backup image.

Thanks,
vj_dba

Sep 27 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.