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

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

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.

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