Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008

    Unanswered: Incremental Image Copy Vs Full Image Copy

    I realise the difference as it is pretty straight forward. To start off, you take a full image copy, and there after keep it going with incremental. My question is, could there be a situation where in you have to prefer Full Image Copy to Incremental?

  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    Yes, of course: If you restore a backup, you probably want to do that as fast as possible. Restoring incremental backups is slower because you first have to restore the full backup image and then all incremental backups based on that full backup. (Cumulative backups make this even more interesting.)

    So it is a trade-off between backup overhead and restore time: if restore time is of utmost importance, you probably don't want to use incremental backups.

    Another issue is if you change lots of things between backups. If the incremental backup contains pretty much the complete database, you can take a full backup as well and potentially turn of the TRACKMOD switch. Again, it depends on your situation...
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jun 2008

    Makes sense. Thanks much for the reply.


Posting Permissions

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