Skip to Content
author's profile photo Former Member
Former Member

DB2 Restore Issue

Hello all,

Iam building a new system with Backup-restore method. Source SID and target SID are different. The steps that I performed for this are as below,

1.Online backup of Source system

2.Installed a new SAP system (Now in restore backup phase)

3.I restored the DB as per the command mentioned below,

Source SID: SD1 Target SID - SD2

RESTORE DATABASE SD1 from D:\DB2backup ON D:\db2\SD2\sapdata1, D:\db2\SD2\sapdata2,D:\db2\SD2\sapdata3, D:\db2\SD2\sapdata4, D:\db2\SD2\sapdata5, D:\db2\SD2\sapdata6, D:\db2\SD2\sapdata7, D:\db2\SD2\sapdata8 INTO SD2 NEWLOGPATH D:\db2\SD2\log_dir\NODE0000\

4.After a hour, restore completed successfully

5.After this I have applied the archive logs to get the database out from Roll-forward pending state, from command,

db2 rollforward db SD2 to end of logs and complete

6.Roll forward is not yet completed, now it says,

Input Database Alias : SD2

No of nodes have returned status :1

Node number : 0

Rollforward status : DB working

Next log file to be read : S0147920.log

Log files processed : S0147842.log - S0147896.log

Last committed transaction : 2013-11-23- UTC

NOTE: Log files present in the directory are S0147842.log to S0147920.log

Also I have put the logs passed the above committed transaction time.

Kindly advise,




Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Dec 07, 2013 at 01:55 PM

    Hi Irfan,

    For the use of the rollforward command, have a look at this document:

    IBM DB2 9.7 for Linux, UNIX and Windows Information Center

    The time needed for a rollforward depends on their location (if they are on type or on disk) and the number of them. So, it could take a while.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 29, 2013 at 12:03 PM

    Hi Irfan

    As you are restoring on diffrant system

    have you used redirect restore method?



    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2013 at 04:04 AM

    Thanks all. Managed to restore with re-direct restore method:)

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.