Hi,
I've a question regarding Snap Creator (3.5) and DB2 Luw.
We have implemented a DB2 database containing SAP system data.
We have three volumes data (data files) / log (online logs) / software (db2 instance/software/archive logs, sap binaries).
We snapshot these volumes via Snap Creator DB2 plugin. That works without any problems.
But I have questions regarding the db2 restore case:
If there are problems with the data volume or if I have to restore the database because of logical errors, I do a vol restore for the data volume.
Because the data in the snapshot is consistent (db2 plugin) I could start the database after the date volume restore, but of course I'd like to recover the database
to the latest available log information or point in time.
When I try to rollforward the database is checking the latest log entry in the file SQLOGCTL.LFH. But of course this file contains log entries which are too new.
So the rollforward process starts with the wrong archive log file.
I could solve this issue via single file restore of that file manually from the Soft volume snapshot which has the same timestamp like the data Volume snapshot.
After that I put the database in rollfoward pending mode via db2rfpen on <SID> . Then I can rollforward the database to the latest log or point in time.
Is this really the correct way? Are there other recommendations regarding the rollfoward process?
Thanks a lot for your responses.
Best Regards,
Andreas