Skip to Content

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

DB2 redirected restore hangs...

Hello All,

We are trying to move an SAP 45B system on DB2 Version 8 fixed pack 14 from one datacenter to another.

In the process, I have taken an online backup and then trying to do a redirected restore. The script is generated succesfully and when I try to run the restore on the target server...for some reason the restore hangs.

**********************************

SET TABLESPACE CONTAINERS FOR 42 USING ( FILE L:\db2\NQ1\sapdata1\ZSAPBTAB8

I.container000 640000 ,FILE N:\db2\NQ1\sapdata2\ZSAPBTAB8I.

container001 640000 ,FILE P:\db2\NQ1\sapdata3\ZSAPBTAB8I.co

ntainer002 640000 ,FILE R:\db2\NQ1\sapdata4\ZSAPBTAB8I.cont

ainer003 640000 ,FILE T:\db2\NQ1\sapdata5\ZSAPBTAB8I.contai

ner004 640000 ,FILE U:\db2\NQ1\sapdata6\ZSAPBTAB8I.containe

r005 640000 )

DB20000I The SET TABLESPACE CONTAINERS command completed successfully.

RESTORE DATABASE NQ1 CONTINUE

*****************************************************

This is where it hangs. I have tried to kill this and rerun the restore but the same problem.

the db2diag.log has following entries:

******************************************

2007-10-19-06.10.06.137000+000 I79285H352 LEVEL: Severe

PID : 4424 TID : 5048 PROC : db2syscs.exe

INSTANCE: DB2 NODE : 000 DB : NQ1

APPHDL : 0-51 APPID: *LOCAL.DB2.071019061006

FUNCTION: DB2 UDB, base sys utilities, sqleserl, probe:10

RETCODE : ZRC=0xFFFFFBA1=-1119

2007-10-19-06.10.06.231000+000 I79639H370 LEVEL: Warning

PID : 4424 TID : 5048 PROC : db2syscs.exe

INSTANCE: DB2 NODE : 000 DB : NQ1

APPHDL : 0-52 APPID: *LOCAL.DB2.071019061007

FUNCTION: DB2 UDB, base sys utilities, sqleCheckForBackupRestore, probe:10

RETCODE : ZRC=0xFFFFFBA1=-1119

2007-10-19-06.10.06.231000+000 I80011H371 LEVEL: Severe

PID : 4424 TID : 5048 PROC : db2syscs.exe

INSTANCE: DB2 NODE : 000 DB : NQ1

APPHDL : 0-52 APPID: *LOCAL.DB2.071019061007

FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForSerialization, probe:20

RETCODE : ZRC=0xFFFFFBA1=-1119

2007-10-19-06.10.06.231000+000 I80384H352 LEVEL: Severe

PID : 4424 TID : 5048 PROC : db2syscs.exe

INSTANCE: DB2 NODE : 000 DB : NQ1

APPHDL : 0-52 APPID: *LOCAL.DB2.071019061007

FUNCTION: DB2 UDB, base sys utilities, sqleserl, probe:10

RETCODE : ZRC=0xFFFFFBA1=-1119

***********************************************************

Hope someone could help.

-Madhu

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