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

SAP:ECC 5.0

Target System

SID:P5J(Newly developed QAS)

OS:Windows 2003

DB:DB2 8.2 FixPack12

SAP:ECC 5.0

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

P5J=K5J

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.

Regards,

Shion

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