I read about ROLLFORWARD option on link http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001978.html?cp=SSEPGG_9.7.0%2F3-6-2-4-106 but I could not find answer to my issue.
I have database in Archive mode.
I am using
DISK option in
I made full ONLINE backup at Monday at 23:59
I have archive logs for Tuesday, Wednesday and Thursday. Let's say just for example one for each day: S0000001.LOG and S0000002.LOG and S0000003.LOG.
In Friday I have active log S0000004.LOG.
Let's say just for testing purpose I want to do the restore of Online backup made at Monday and all transactions committed during Tuesday, Wednesday,Thursday and Friday. So I want to restore everything from Monday to Friday
I thought by reading all manuals that I just need to perform after restore
ROLLFORWARD TO END OF LOGS
db2 rollforward db maxdb75 to end of logs and complete;
I thought that this command
to end of logs it will include
Archive Logs(S0000001.LOG + S0000002.LOG + S0000003.LOG.)+Active Logs(S0000004.LOG)
But one good database expert told me that: "When rolling forward to end of logs without specifying overflow log path only active logs will be read"
So I have 2 questions:
- What in my example will be restored in case of
"to end of logs"command
- Is this the command if after the restore I want to rollforward everything from Monday To Friday in my exampe:
db2 rollforward db maxdb75 to end of logs and complete overflow log path "(/data/archiveLogsPath)";
Thank you in advance!!!!