Reputation
254
Top tag
Next privilege 300 Rep.
Create tags
Badges
1 4 12
Newest
 Yearling
Impact
~36k people reached

  • 0 posts edited
  • 0 helpful flags
  • 27 votes cast
Apr
6
asked DB2 - what happens when SQL archive log file reches its maximum value (S9999999.LOG)
Mar
12
awarded  Yearling
Mar
6
accepted DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
Mar
6
comment DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
Thank you @Chris for your great kindness as always and good explanations. But Ian who is also great expert confirmed my doubts "to end of logs" will do the rollforward of all archive logs and I do not need to specify "overflow". I am using DISK option of course for logarchmeth1. Thank you once again
Mar
6
revised DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
added 40 characters in body
Mar
6
comment DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
Thank you Ian!!!! So please just confirm me this: after I do backup restore and I perform "db2 rollforward db maxdb75 to end of logs and complete;" this will include all Archive Logs(S0000001.LOG + S0000002.LOG + S0000003.LOG.)+Active Logs(S0000004.LOG) right??? I am using DISK option in LOGARCHMETH1. That was how I understand it all the time but I was confused with that sentence of another db admin
Mar
5
comment DB2 PURGE (old Online Backups and Archive logs) - some of the archive logs are not removed
Hi Chris, can you maybe help me with this question, link is below, it is very unclear for me and answers are not understandable: dba.stackexchange.com/questions/94455/… thank you in advance
Mar
5
accepted DB2 PURGE (old Online Backups and Archive logs) - some of the archive logs are not removed
Mar
5
comment DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
@@hi mustaccio how can archive logs exist in the active log directory?? if it is in the active log directory than it is not the archive log, it is active log... If you can I would appreciate answers on two questions above, as I mentioned when I perform "to end of logs" my rollforward is sucessfull it does not fail
Mar
5
revised DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
added 18 characters in body
Mar
5
comment DB2 ROLLFORWARD ERROR when doing “TO A POINT IN TIME” option
I understand the difference between restore and rollforward. You mentioned it will failed. But it did not for this real use case, I really had backup from yesterday at 19:20 and I had 10 archive log files after that till this morning... I had also active log files and my command "to end of logs" was successful, I performed it today at 11:00. That is why I am still confused. You said it will fail but it did not fail and I did not user "overflow" when using "to end of logs". In almost every example I saw on the web "to end of logs" option is not used with "overflow" option
Mar
5
revised DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
deleted 7 characters in body
Mar
5
asked DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?
Mar
5
comment DB2 ROLLFORWARD ERROR when doing “TO A POINT IN TIME” option
@@mustaccio can you please comment my last post? thank you very much
Mar
4
comment DB2 ROLLFORWARD ERROR when doing “TO A POINT IN TIME” option
@@mustaccio If my backup is at Monday 23:00 and archive logs are covering Tuesday, Wednesday and Thursday, and active logs are from Friday, if I do "to end of logs" without specifying overflow log path what will be restored? Data from Monday and Friday but not and from Tuesday, Wednesday and Thursday??? I am really confused I read a lot I think I figured it out but now I am totally confused. This does not make sense to me. What data will be restored in this simple use case when using END OF LOGS? Thank you!!!
Mar
4
comment DB2 ROLLFORWARD ERROR when doing “TO A POINT IN TIME” option
just to summarize FINAL QUESTION: why in case of POINT IN TIME db does not automatically reads ARCHIVE LOG folder (overflow must be specified) while in the case of END OF LOGS it is "smart" enough to look for ARCHIVE FOLDER on which after that it do the rollforward of archive logs until the end of them???
Mar
4
accepted DB2 ROLLFORWARD ERROR when doing “TO A POINT IN TIME” option
Mar
4
comment DB2 ROLLFORWARD ERROR when doing “TO A POINT IN TIME” option
I succeeded to do the rollforward I added additional double quotes db2 rollforward db maxdb71 to 2015-03-03-21.05.00.000000 using local time and stop overflow log path "(/data/archive/)"; so thank you for help... but I am really confused when doing "end of logs" then database is smart enough to find all necessary archive logs, right? why is then not smart enough to find all necessary archive logs in case when doing the "point-in-time"??? I am confused why overflow must be mentioned because when doing rollforward END OF LOGS it is not necessary to do that
Mar
4
revised DB2 ROLLFORWARD ERROR when doing “TO A POINT IN TIME” option
edited body
Mar
4
revised DB2 ROLLFORWARD ERROR when doing “TO A POINT IN TIME” option
added 1 character in body