Skip to Content

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

db2 restor error help


I am trying to restor sap sysytem with same SID, same OS

at the time of ofline backup

1-create dir in e:/db2/SID/log_archive

2-db2 update db cfg for AXI using LOGARCHMETH1 DISK:E:\db2\SID\log_archive\

3-db2stop force


5-db2 backup database dbname to E:\backup with 3 buffers buffer 1024 parallelism 6 compress without prompting

at the tme of restore

1- login as db2<SID>

2- db2start

3- db2 restore database <SID>    from /<taken backup location>

4- db2 rollforward db  <SID>  to end of logs

5- db2 rollforward db <SID> COMPLETE

6- db2 connect to SIDADM user

for the restoration purpose I used offline backup image

i used system copy target system export method

All above commands are successful but, after restoration when I continu to installation I am facing the error on phase no 15 (grant db privilages)

I using same os & same db2 databse.

please help me to troubleshoot {which step I am missing}

Former Member

Helpful Answer

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