Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2010
    Posts
    335

    Unanswered: DB2 Snapshot Backups

    Hi,

    is anybody using Snapshot-Backups with DB2? I'ld like to get some feedback concerning the usability of it.

    Are you using DB2 ACS or Write Suspend?
    How does it work with Point-In-Time Recovery? Do i have to consider special treatment for Logs/ArchiveLogs?

    Cheers
    nvk

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    We use the write suspend as part of a DR solution. It works OK (luckily we have not had to actually use it in an actual live DR situation). The database can only be recovered to the point at which the write suspend was issued.

    Andy

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    After you restore your snapshot copy, you can use the db2inidb command to intialize the database in roll-forward pending state (use the STANDBY option even if you are not creating a standby database), which enables you to roll the logs forward. See the Command Reference manual for more info.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Feb 2010
    Posts
    3
    In my case my system hanged, what should I do?

  5. #5
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by nancy86 View Post
    In my case my system hanged, what should I do?
    First, please start a new thread. Adding to a different thread will not get you the best results.

    Second, you need to be more specific.

    Andy

Posting Permissions

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