One way you might want to investigate. Use db2move to move out all objects in DEVT_TB, restore redirect, then db2move back in. Once you done this once, you'd only bring back the prod tblsps with redirect and never the DEV_TB unless you needed that too.
Also, as mentionned by Dale in a different note, you may want to investigate the folloowing product/services at: http://www-3.ibm.com/software/main/img/titles/products/db2rev11-title.gif HTH, Pierre. Pierre Saint-Jacques IBM Certified Solutions Expert - Administration SES Consultants Inc. [EMAIL PROTECTED] ----- Original Message ----- From: "Savin, Mark(euler:eti)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 12:43 PM Subject: [DB2EUG] Redirected restores and tablespace restores > 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 - ::: 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
