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:
owner-db2eug@l Subject: [DB2EUG] Restoring a
database to a different machine with
ugwash.org different file structures
05/06/2002
12:37 PM
Please respond
to Tim_Traxson
Hello all,
I know restoring databases gets kicked around here a lot, but I am
wondering if you can help.
I am trying to restore a backup of a database that was taken on machine A
on machine B. The
file structure on machine A is as follows : /udbd/db2/NODE0000.... and on
machine B it is as
follows : /udb/db2/NODE0000... Note the missing "d" on the second one. I
created a test database
on machine B and was trying to do a redirected restore with the replace
option specified. There are
a few tablespaces that needed to be set to a different path. I got through
the first part of the restore and
set them to the new path. My question is this, do I have to set every
tablespace to the new path of
/udb/db2/NODE0000 or should it create the structures automatically if they
were installed in the default
tablespace on machine A. Example would be tablespace RAATS1. It exists in
/udbd/db2/NODE0000
/SQL00002/RAATS1 on machine A, would I need to run the set tablespace
command for it to /udb/db2/
NODE0000/SQL00002/RAATS1?
UDB 7.2 on AIX version 4.3
Your help is appreciated.
Thanks,
Tim Traxson
[EMAIL PROTECTED]
479-820-8811
-
::: 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
-
::: 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
-
::: 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
