Help needed: db2 rollforward db issues with SQL1273N and SQL1276N Unable to complete rollforwarding

Hi All,
I need a savior, literally...I have a db2 rollforwarding issues: I successfully redirected a restore operation but now unable to complete the rollforwardiing. I am getting the following errors:

db2 rollforward db RAPMT02 to end of backup and complete
SQL1273N  An operation reading the logs on database "RAPMT02" cannot continue
because of a missing log file "S0000518.LOG" on database partition "0" and log stream "0".

db2 rollforward db RAPMT02 complete
SQL1276N  Database "RAPMT02" cannot be brought out of rollforward pending
state until roll-forward has passed a point in time greater than or equal to "2015-02-20-18.18.57.000000 UTC", because node "0" contains information later than the specified time.

Anyone know how I can resolve this issue?

 

Thanks in advance for your assistance
EnyimbaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kent OlsenData Warehouse Architect / DBACommented:
Hi Enyimba,

The restore process could not find the log file(s).  It looks like the database was successfully restored from the backup files, but the missing log file(s) prevent the restore from applying the changes that occurred after the backup was taken.

As in the other thread, use the "db2 restore database {alias} ABORT" command to end the restore.

If you don't need to apply the log files (the backup is sufficient as it exists), rerun the RESTORE command with the "WITHOUT ROLLING FORWARD" option.


Good Luck!
Kent
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
EnyimbaAuthor Commented:
kdo,

Thanks for your response. I did not try your first recommendation and the second recommendation failed because the log files where needed. Next did take a new backup with include logs which also failed because a log was missing!!  I could not understand that!
Finally, I used the db2adutl system command to recall the needed log file and that fixed my problem...
0
EnyimbaAuthor Commented:
Thanks kdo
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.