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
