Attempting a redirected Restore:
Code:
CONNECT TO DUTDM user db2admin using db2admin;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
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\NODE0000\DUTDM\CONTAINERS\Catalog_tbsp" 640000 );
SET TABLESPACE CONTAINERS FOR 1 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2\NODE0000\DUTDM\system_tbsp" 2560000 );
SET TABLESPACE CONTAINERS FOR 2 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2\NODE0000\DUTDM\CONTAINERS\USER_TBSP" 6400000 );
SET TABLESPACE CONTAINERS FOR 3 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2\NODE0000\DUTDM\Containers\INDSP16K_tbsp" 864000 );
SET TABLESPACE CONTAINERS FOR 4 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2\NODE0000\DUTDM\Containers\INDSP32K_tbsp" 240000 );
SET TABLESPACE CONTAINERS FOR 5 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2\NODE0000\SQL00003\SYSTOOLSPACE" 8192 );
SET TABLESPACE CONTAINERS FOR 6 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2\NODE0000\DUTDM\Containers\INDSP4K_tbsp" 1920000 );
SET TABLESPACE CONTAINERS FOR 7 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2\NODE0000\DUTDM\Containers\TBLSP4K_tbsp" 256000 );
SET TABLESPACE CONTAINERS FOR 8 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2\NODE0000\DUTDM\Containers\TBLSP16K_tbsp" 4160000 );
SET TABLESPACE CONTAINERS FOR 9 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "G:\DB2\NODE0000\DUTDM\Containers\TBLSP32K_tbsp" 640000 );
SET TABLESPACE CONTAINERS FOR 10 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "G:\DB2\NODE0000\DUTDM\Containers\SYSTOOL");
SET TABLESPACE CONTAINERS FOR 11 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (PATH "G:\DB2\NODE0000\DUTDM\Containers\SYSTEMP");
RESTORE DATABASE PRODDM CONTINUE;
ROLLFORWARD DATABASE DUTDM TO END OF LOGS AND COMPLETE NORETRIEVE;
CONNECT TO DUTDM user db2admin using db2admin;
UNQUIESCE DATABASE;
It's only a 60GB database and the restore has been running about 90 mins already.
Every minute or so, I am getting this in the Diag log:
2009-02-09-10.31.55.619000-300 I7671650H460 LEVEL: Severe
PID : 4996 TID : 8064 PROC : db2syscs.exe
INSTANCE: DB2_02 NODE : 000 DB : DUTDM
APPHDL : 0-214 APPID: *LOCAL.DB2_02.090209153156
AUTHID : SYSTEM
EDUID : 8064 EDUNAME: db2agent (DUTDM)
FUNCTION: DB2 UDB, base sys utilities, sqeDBMgr:
tartUsingLocalDatabase, probe:
10
RETCODE : ZRC=0xFFFFFBA1=-1119
I've googled it but really can't get a grip on the answer.. can someone tell me what might be wrong with my restore code?
dBforums
>
redirected restore DB2 on Windows V9.5
02-09-09, 10:33
Linear Mode
