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

    Unanswered: redirected restore

    Db2 on Windows Enterprise edition v9.5 fixpack 2

    Trying to do a redirected restore - here is my script:

    Code:
    RESTORE DATABASE UATDM FROM "G:" TAKEN AT 20081020193705 TO "E:" INTO WFREPORT NEWLOGPATH F:\DB2\NODE0000\WFREPORT\NODE0000\
    WITH 2 BUFFERS BUFFER 1024 REDIRECT PARALLELISM 1 WITHOUT PROMPTING;
    
    SET TABLESPACE CONTAINERS FOR 0 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\T0000000\C0000000.CAT" 128000 );
    SET TABLESPACE CONTAINERS FOR 1 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\T0000001\C0000000.TMP" 256000 );
    SET TABLESPACE CONTAINERS FOR 2 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\T0000002\C0000000.LRG" 6400000 );
    SET TABLESPACE CONTAINERS FOR 3 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\Containers\INDSP4K_tbsp" 1920000 );
    SET TABLESPACE CONTAINERS FOR 4 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\Containers\INDSP16K_tbsp" 864000 );
    SET TABLESPACE CONTAINERS FOR 5 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\Containers\INDSP32K_tbsp" 240000 );
    SET TABLESPACE CONTAINERS FOR 6 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\Containers\TBLSP4K_tbsp" 256000 );
    SET TABLESPACE CONTAINERS FOR 7 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\Containers\TBLSP16K_tbsp" 4160000 );
    SET TABLESPACE CONTAINERS FOR 8 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\Containers\TBLSP32K_tbsp" 64000 );
    SET TABLESPACE CONTAINERS FOR 9 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\T0000003\C0000000.LRG" 8192 );
    SET TABLESPACE CONTAINERS FOR 10 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\T0000011\C0000000.UTM" 1 );
    SET TABLESPACE CONTAINERS FOR 11 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (FILE "E:\DB2\NODE0000\WFREPORT\T0000004\C0000000.TMP" 16384 );
    
    RESTORE DATABASE UATDM CONTINUE;
    Code:
    Getting this error..  
    RESTORE DATABASE UATDM FROM "G:" TAKEN AT 20081020193705 TO "E:" INTO WFREPORT NEWLOGPATH F:\DB2\NODE0000\WFREPORT\NODE0000\ WITH 2 BUFFERS BUFFER 1024 REDIRECT PARALLELISM 1 WITHOUT PROMPTING
    DB21018E  A system error occurred. The command line processor could not 
    continue processing
    and seeing this in the diag log:

    Code:
    2008-10-21-05.37.02.987000-240 E3385739H822       LEVEL: Severe
    PID     : 7896                 TID  : 2792        PROC : db2bp.exe
    INSTANCE: DB2                  NODE : 000
    EDUID   : 2792
    FUNCTION: DB2 UDB, database utilities, sqludValidateParameters, probe:2129
    MESSAGE : SQL2008N  The callerac parameter is not within valid range or the
              requested action is out of sequence.
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
     sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -2008   sqlerrml: 0
     sqlerrmc:
     sqlerrp : sqludVal
     sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
               (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
     sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
     sqlstate:
    Can anyone help?????

  2. #2
    Join Date
    Oct 2008
    Posts
    11
    Hello

    usually this problem occurs if there any spelling mistake or syntax problem..
    Make sure there is no such problems then do a "db2 terminate and try to restore again".

    Thnx,
    Eldho

  3. #3
    Join Date
    Dec 2007
    Posts
    288
    Thanks. that worked.

  4. #4
    Join Date
    Apr 2008
    Posts
    39
    Instead of manually doing all the above steps, you can use GENERATE SCRIPT option of RESTORE command.

    RESTORE DATABASE UATDM FROM "G:" TAKEN AT 20081020193705 TO "E:" INTO WFREPORT NEWLOGPATH F:\DB2\NODE0000\WFREPORT\NODE0000\
    WITH 2 BUFFERS BUFFER 1024 REDIRECT GENERATE SCRIPT test.clp PARALLELISM 1 WITHOUT PROMPTING;

    When you use this option, the restore utility extracts container information from the backup image and generates a clp script that contains all the detailed container information.

    you can change the container paths and tablespace ID numbers in the test.clp script and run the script as

    db2 -tvf test.clp

    Thanks,
    Madhavi.

  5. #5
    Join Date
    Oct 2008
    Posts
    11
    cool..!
    I think this is available only on V9.5

Posting Permissions

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