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:
here are the errors from the diaglog
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