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
