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
