Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DB2 Backup/Restore

Hi All,

I am new to DB2. I need your help for taking backup

Currently we are doing Backup/Restore from R/3PRD(existing system) to R/3QAS(new system).

Source System

OS:Windows 2003 (exsiting PRD)

DB:DB2 8.2 FixPack12


Target System

SID:P5J(Newly developed QAS)

OS:Windows 2003

DB:DB2 8.2 FixPack12


We proceed steps as followings;

1.In source system, DB online back up

>db2 backup db P5J online to z:\temp compress

2. In source system, create script to restore

>E:\usr\sap\P5J\SYS\exe\run-640\brd6brt -s P5J -bm RETRIEVE -replace


3. In target system, install SAP(CI/DB)

4. DB restore from script

5. DB rollforward

>db2 rollforward db k5j to end of logs

error: SQL4970 An error occurred while accessing object "0".

An error keeps me telling "Node 0 dosent contain log file.

Rollforward recovery of DB"K5J" is failed. "

We got an error at No.5...

Something worng with these steps?

Please let me know where to put log files.

Maybe it is not correct...

Please, Please somebody help me.



Edited by: Shion Kubota on Apr 8, 2011 8:09 AM

Not what you were looking for? View more on this topic or Ask a question