Reputation
264
Top tag
Next privilege 300 Rep.
Create new tags
Badges
2 6 20
Impact
~64k people reached

  • 0 posts edited
  • 0 helpful flags
  • 27 votes cast
Apr
28
awarded  Popular Question
Apr
18
awarded  Popular Question
Apr
11
awarded  Popular Question
Feb
22
awarded  Notable Question
Feb
18
awarded  Popular Question
Feb
11
awarded  Popular Question
Jan
18
awarded  Famous Question
Dec
26
awarded  Notable Question
Aug
7
awarded  Caucus
Aug
1
awarded  Popular Question
May
27
awarded  Popular Question
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