Hi list, Got a question regarding redirected restores and how we can fit tablespace backups into that, I hope someone can help.
We're running DB2 v7.2 on AIX 4.3.3. We have a database "A" which houses a copy of all our production tables, plus a development tablespace DEVT_TB which houses tables used for a separate project. We have been exporting and loading production tables into this database, but this is a long-winded process. What we want to do is a redirected restore of the production database into database "A". However, this will overwrite the development tablespace. As far as I can see, there are 2 options: 1) Export table definitions and table data from database A before the restore, then manually recreate the tables and data once the restore completes 2) Take a tablespace backup of DEVT_TB before doing any work. Then do the redirected restore. Then restore the tablespace backup afterwards. Option 2 is much cleaner, but I don't know if it's possible. There is the option of splitting the development tablespace into a separate database, but I'd like to avoid that complication. Does anyone have any ideas? Thanks in advance, Mark Savin DBA Euler Trade Indemnity - ::: 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
