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 problem

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-27-04, 10:22
ashaq ashaq is offline
Registered User
 
Join Date: Dec 2003
Posts: 39
redirected restore problem

I am using db2v7.2 on AIX 5.1

I am trying to define the directory type container while redirected restore ,I am getting the following error

set tablespace containers for 13 using ('/db2/db200001/temp8kts/ts8k','/db2/db200001/temp8kts/ts8k_1')
SQL0104N An unexpected token "'/db2/db200001/temp8kts/ts8k'" was found
following "(". Expected tokens may include: "PATH". SQLSTATE=42601

can someone tell me what is the syntax of defining directories while redirected restore


also all the conatiners wre defined in the script (eg:- set container for ...),the output of which directed to outfile
the script is still running and it seems it got hung ,this was the last container which
gave me the error ,other container were set without error.I want to rollback the whole process
and correct the scrip and start from scratch ,please let me know is it possible
or how should I solve this problem

with regards
ashaq
Reply With Quote
  #2 (permalink)  
Old 04-27-04, 10:28
bmujeeb bmujeeb is offline
Registered User
 
Join Date: Mar 2004
Posts: 448
For redirected restore in SMS tablespace use that

set tablespace containers for 13 using (PATH '/db2/db200001/temp8kts/ts8k','/db2/db200001/temp8kts/ts8k_1')

Regards,

Mujeeb
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