If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Re-directed restore tanking too long

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-16-09, 09:28
itsonlyme44 itsonlyme44 is offline
Registered User
 
Join Date: Dec 2007
Posts: 261
Re-directed restore tanking too long

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???


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
Here is 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;
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On