Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    288

    Unanswered: redirected restore DB2 on Windows V9.5

    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?

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    don't worry about the errors as long as the restore is progressing. You can use "db2 list utilities show detail" to check the progress. Also, check if the tablespaces are using automatic storage, if they're - redirected restore is not allowed for them.

  3. #3
    Join Date
    Dec 2007
    Posts
    288
    Thank you!!! It did finally finish!!! The "db2 list utilities show detail" to check the progress in the future will be very helpfull!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •