Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


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 > redirected restore

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-21-08, 07:31
itsonlyme44 itsonlyme44 is offline
Registered User
  
Join Date: Dec 2007
Posts: 261
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?????
Reply With Quote
  #2 (permalink)  
Old 10-21-08, 13:25
eldho_mathewk eldho_mathewk is offline
Registered User
  
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
Reply With Quote
  #3 (permalink)  
Old 10-21-08, 14:00
itsonlyme44 itsonlyme44 is offline
Registered User
  
Join Date: Dec 2007
Posts: 261
Thanks. that worked.
Reply With Quote
  #4 (permalink)  
Old 10-21-08, 15:05
madhu_kaza madhu_kaza is offline
Registered User
  
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.
Reply With Quote
  #5 (permalink)  
Old 10-22-08, 03:16
eldho_mathewk eldho_mathewk is offline
Registered User
  
Join Date: Oct 2008
Posts: 11
cool..!
I think this is available only on V9.5
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.