Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2002
    Posts
    86

    Unanswered: incremental backup question?

    Hi All,
    I am working with db2 v7.2 on AIX. we have a database with 26 GIG backup image, I decided to use incremental delta backup.
    1- I change TRACKMOD=on
    2-I took full offline backup size was 26 GIG
    3- I deleted 4 rows from a table
    4- I took incremental delta backup, I expected I would have backup image with at most 10 MB, but I had 15 GIG backup image (WHY???).
    5- I deleted one row and I took incremental delta backup for second time, I had exactly the same size in first incremental backup (WHY???)

    does incremental backup save the PAGES that have been changed? WHY for deletion of 4 rows I should have 15 GIG the size of backup.
    could somebody tell me why.
    Thanks
    ,

  2. #2
    Join Date
    Jul 2002
    Posts
    86

    Re: incremental backup question?

    Originally posted by David2002
    Hi All,
    I am working with db2 v7.2 on AIX. we have a database with 26 GIG backup image, I decided to use incremental delta backup.
    1- I change TRACKMOD=on
    2-I took full offline backup size was 26 GIG
    3- I deleted 4 rows from a table
    4- I took incremental delta backup, I expected I would have backup image with at most 10 MB, but I had 15 GIG backup image (WHY???).
    5- I deleted one row and I took incremental delta backup for second time, I had exactly the same size in first incremental backup (WHY???)

    does incremental backup save the PAGES that have been changed? WHY for deletion of 4 rows I should have 15 GIG the size of backup.
    could somebody tell me why.
    Thanks
    ,
    PLEASE SOMEBODY HELP ME

  3. #3
    Join Date
    Aug 2002
    Posts
    76

    Re: incremental backup question?

    You answered it yourself: Incremental Backups saves pages that change.

    Check this link out

    http://www7b.software.ibm.com/dmdd/l...5adamache.html

  4. #4
    Join Date
    Jul 2002
    Posts
    86

    Re: incremental backup question?

    Originally posted by akratz
    You answered it yourself: Incremental Backups saves pages that change.

    Check this link out

    http://www7b.software.ibm.com/dmdd/l...5adamache.html
    Thank you for your responce,
    but deletion 4 rows have 15 gig page changes?

  5. #5
    Join Date
    Jan 2005
    Posts
    2

    For David2002

    David,

    I have the same problem and just found this entry in dbForum. Did you ever get an answer to the incremental/delta size problem?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •