Hi Tim,
There are some very good scripts for redirect restore
and stuff like that.
There scripts were given to be by Mr.Philip Nelson
whos also the member of this group.
Iam sending the scripts attached to this mail .
Philip,
If you are out there, i hope you dont mind me sending
these scripts to our fellow DB2 chaps.
Thanks,
Ravi.
--- [EMAIL PROTECTED] wrote:
> Thanks for the input Kelly, Robert and Mark.
>
> I tried to do the restore database abort and got the
> same callerac error.
> So I dropped the target database and started from
> the beginning and got
> through the whole thing successfully.
>
> Now another question regarding restoring a DMS
> defined database from a
> backup on the same server. I guess I have to do the
> same redirected
> restore and set all of the tablespaces to a
> different directory. I have
> DatabaseA and want to create DatabaseB on the same
> Windows 2000 server.
> DatabaseA is defined with lots of DMS tablespaces
> and when I try to restore
> it to DatabaseB I get container is already in use.
> Nothing else to do but
> to alter all of the tablespaces with a redirected
> restore correct? If so,
> any tips on setting a bunch of tablespaces with some
> sort of script file as
> opposed to typing in all of the commands
> individually? I did a list
> tablespaces on DatabaseA and was hoping to create a
> set tablespace script
> with it.
>
> Thanks again for all of the help.
>
> Tim Traxson
> [EMAIL PROTECTED]
> 479-820-8811
>
>
> ----- Forwarded by Tim Traxson/Corporate/JBHunt on
> 05/07/2002 07:43 AM
> -----
>
>
>
> [EMAIL PROTECTED]
>
>
> m.com To:
> [EMAIL PROTECTED]
>
> cc:
> [EMAIL PROTECTED], [EMAIL PROTECTED]
>
> 05/06/2002 Subject:
> Re: [DB2EUG] Restoring a database to a different
>
> 03:41 PM machine
> with different file structures
>
>
>
>
>
>
>
>
>
>
>
> Hi Tim,
>
> What steps did you take to restart the redirected
> restore? Did you do a
> "RESTORE DATABASE <BLAH> ABORT"? You may have to do
> this. Once that is
> complete, you have to restart the restore from the
> beginning ("RESTORE
> DATABASE <BLAH> REDIRECT", "SET TABLESPACE
> CONTAINERS", etc.).
>
> Kelly
>
> Kelly Schlamb
> DB2 Universal Database Development, IBM Toronto Lab,
> Canada
> Email: [EMAIL PROTECTED]
> Phone: 905-413-2469
>
> DB2 Online Support Website:
>
http://www.ibm.com/software/data/db2/udb/winos2unix/support
>
>
>
> Tim_Traxson@jb
>
> hunt.com To:
> [EMAIL PROTECTED]
>
> Sent by: cc:
>
> owner-db2eug@l Subject:
> Re: [DB2EUG]
> Restoring a database to a different machine
> ugwash.org with
> different file structures
>
>
>
> 05/06/2002
>
> 03:17 PM
>
> Please respond
>
> to Tim_Traxson
>
>
>
>
>
>
>
> Thanks for the input. I got through the set
> tablespace stuff and did a
> restore....continue and it took off. It then
> errored out with a "SQL2544N
> The directory where the database is being restored
> has become full." I
> freed up some space and tried to restart the restore
> again and now I get
> the following error "SQL2008N The callerac
> parameter is not within valid
> range or the requested action is out of sequence."
> It says to consult the
> Application Development Guide. I did a search of it
> online and found no
> match. Any ideas?
>
> Tim
>
>
>
> [EMAIL PROTECTED]
>
> m.com To:
> [EMAIL PROTECTED]
>
> cc:
> [EMAIL PROTECTED],
> [EMAIL PROTECTED]
> 05/06/2002 Subject:
> Re: [DB2EUG]
> Restoring a database to a different
> 01:12 PM machine
> with different file
> structures
>
>
>
>
>
>
> Hi Tim,
>
> You only need to do a "SET TABLESPACE CONTAINERS"
> command for any
> tablespace that has containers that do NOT reside
> directly under the
> database directory (the database directory being
> .../NODE0000/SQL#####).
>
> The container names in these cases are just stored
> as a relative path under
> your database directory so a change in the database
> directory won't affect
> them during the subsequent restore.
>
> So, for your example, you would NOT need to do a SET
> TABLESPACE CONTAINERS
> command for tablespace RAATS1, it will be done
> automatically.
>
> Kelly
>
> Kelly Schlamb
> DB2 Universal Database Development, IBM Toronto Lab,
> Canada
> Email: [EMAIL PROTECTED]
> Phone: 905-413-2469
>
> DB2 Online Support Website:
>
http://www.ibm.com/software/data/db2/udb/winos2unix/support
>
>
>
> Tim_Traxson@jb
>
> hunt.com To:
> [EMAIL PROTECTED]
>
> Sent by: cc:
>
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
