By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,745 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

DB2 Rollfoward failes with error 24

P: n/a
Hi,
I have received a database online backup that was taken using the
command

db2 "backup database prdDB01 online to /udb/db2inst1/backups INCLUDE
LOGS"

I tried restoring it using the command

db2 "restore database prdDB01 taken at 20070122210640 to /db/db2inst1/
prddb01 into PRDDB01 logtarget /db/db2inst1/tmplogs redirect"

then I have set the table space containers and continued with the
restore with the command

db2 "restore database tlineprd continue"

at this point 2 logs files are created in /db/db2inst1/tmplogs

however when I try to complete the recovery process by the command

db2 "rollforward database tlinewar to end of logs and complete
overflow log path (/honda/db2inst1/tmplogs)"

it starts complaining about a third log file that it searches for.

Is there anything wrong with the process.

Regards,
V Rath

Feb 12 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
vi**********@gmail.com wrote:
Hi,
I have received a database online backup that was taken using the
command

db2 "backup database prdDB01 online to /udb/db2inst1/backups INCLUDE
LOGS"

I tried restoring it using the command

db2 "restore database prdDB01 taken at 20070122210640 to /db/db2inst1/
prddb01 into PRDDB01 logtarget /db/db2inst1/tmplogs redirect"

then I have set the table space containers and continued with the
restore with the command

db2 "restore database tlineprd continue"

at this point 2 logs files are created in /db/db2inst1/tmplogs

however when I try to complete the recovery process by the command

db2 "rollforward database tlinewar to end of logs and complete
overflow log path (/honda/db2inst1/tmplogs)"

it starts complaining about a third log file that it searches for.
Could you post the exact error message along with some details on your
environment?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Feb 12 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.