Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

redirected restore hanging

Status
Not open for further replies.

jpotucek

Technical User
Jan 26, 2005
144
US
DB2 V9.1 on Windows. Doing a redirected restore and I get the following errors and warnings scrolling over and over... can anyone help me figure out what's going on???

Here are my restore code:

Code:
ATTACH TO KOCDEVU2;
CONNECT TO DUTDM user db2admin using db2admin;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
RESTORE DATABASE PRODDM FROM "F:\ProdDMBackup" TO "G:" INTO DUTDM WITH 2 BUFFERS BUFFER 1024 REDIRECT PARALLELISM 1 WITHOUT PROMPTING;
SET TABLESPACE CONTAINERS FOR 0 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2_02\NODE0000\DUTDM\CONTAINERS\Catalog_tbsp" 640000 );
SET TABLESPACE CONTAINERS FOR 1 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2_02\NODE0000\DUTDM\system_tbsp" 2560000 );
SET TABLESPACE CONTAINERS FOR 2 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2_02\NODE0000\DUTDM\CONTAINERS\USER_TBSP" 6400000 );
SET TABLESPACE CONTAINERS FOR 3 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2_02\NODE0000\DUTDM\Containers\INDSP16K_tbsp" 864000 );
SET TABLESPACE CONTAINERS FOR 4 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2_02\NODE0000\DUTDM\Containers\INDSP32K_tbsp" 240000 );
SET TABLESPACE CONTAINERS FOR 5 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2_02\NODE0000\SQL00003\SYSTOOLSPACE" 8192 );
SET TABLESPACE CONTAINERS FOR 6 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2_02\NODE0000\DUTDM\Containers\INDSP4K_tbsp" 1920000 );
SET TABLESPACE CONTAINERS FOR 7 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2_02\NODE0000\DUTDM\Containers\TBLSP4K_tbsp" 256000 );
SET TABLESPACE CONTAINERS FOR 8 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2_02\NODE0000\DUTDM\Containers\TBLSP16K_tbsp" 6320000 );
SET TABLESPACE CONTAINERS FOR 9 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2_02\NODE0000\DUTDM\Containers\TBLSP32K_tbsp" 640000 );
SET TABLESPACE CONTAINERS FOR 10 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "G:\DB2_02\NODE0000\DUTDM\Containers\SYSTOOL");
SET TABLESPACE CONTAINERS FOR 11 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "G:\DB2_02\NODE0000\DUTDM\Containers\SYSTEMP");
RESTORE DATABASE PRODDM CONTINUE;
ROLLFORWARD DATABASE DUTDM TO END OF LOGS AND COMPLETE NORETRIEVE;


here are the errors from the diaglog

Code:
2009-03-16-09.20.13.134000-240 I20998910H447      LEVEL: Warning
PID     : 4216                 TID  : 4880        PROC : db2syscs.exe
INSTANCE: DB2_02               NODE : 000         DB   : DUTDM
APPHDL  : 0-48903              APPID: *LOCAL.DB2_02.090316234625
AUTHID  : ISJXR18 
EDUID   : 4880                 EDUNAME: db2agent (DUTDM)
FUNCTION: DB2 UDB, base sys utilities, sqleCheckForRestore, probe:10
RETCODE : ZRC=0xFFFFFBA1=-1119

2009-03-16-09.20.13.134000-240 I20999359H455      LEVEL: Warning
PID     : 4216                 TID  : 4880        PROC : db2syscs.exe
INSTANCE: DB2_02               NODE : 000         DB   : DUTDM
APPHDL  : 0-48903              APPID: *LOCAL.DB2_02.090316234625
AUTHID  : ISJXR18 
EDUID   : 4880                 EDUNAME: db2agent (DUTDM)
FUNCTION: DB2 UDB, base sys utilities, sqlePrepareForSerialization, probe:20
RETCODE : ZRC=0xFFFFFBA1=-1119

2009-03-16-09.20.13.134000-240 I20999816H460      LEVEL: Severe
PID     : 4216                 TID  : 4880        PROC : db2syscs.exe
INSTANCE: DB2_02               NODE : 000         DB   : DUTDM
APPHDL  : 0-48903              APPID: *LOCAL.DB2_02.090316234625
AUTHID  : ISJXR18 
EDUID   : 4880                 EDUNAME: db2agent (DUTDM)
FUNCTION: DB2 UDB, base sys utilities, sqeDBMgr::StartUsingLocalDatabase, probe:10
RETCODE : ZRC=0xFFFFFBA1=-1119

 
Did you drop the DUTDM (target database) before issuing the restore command ?

If not you might try that ...

Regards
Thomas
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top