No problems.
Tim (and all others) feel free to use the scripts for building
redirected restores.
One of these days I'll get round to releasing them under the GPL <G>
Phil
On Tue, 2002-05-07 at 16:36, r x wrote:
> 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
