redirect restore - not all tablespaces?

[drotz]

i have a situation where i want to refresh production data to my test system however i want to skip the restore for 2 specific tablespaces and use the current tablespace data.

this is because those 2 tablespaces (1 - data and 1-index) is "tools" or application configuration data, separate and non-related to the reset of the actual business data.

i was thinking of setting container paths /dev/null for the 2 I want to ignore and then reset those 2 paths to the existing (before redirected restore) after the restore is complete.

 

[drotz]

i thought of another option .......

1) i can backup the 2 tablespaces which is are file type

2) execute redirected restore - with the 2 tablespaces i wan to replace going to a container location i will remove later

3) restore the 2 file that are the tablespaces

can i change the container paths as they are different from produciton to test db2?

or

i think if i add a new container path, that is the one where the file restore (step 3) will place it, and then drop the other container path that was from redirected restore (step 2)

 

[drotz]

i looked for a way to edit that last post ..... i think i made it more complicated that it is ...


thought of another option .......

1) i can backup the 2 tablespaces which is are file type

2) execute redirected restore

3) restore the 2 files that are the tablespaces overtop (same path)

 

[sathyarams]

That is possible (though NOT supported). But rememeber, all the table defintions (in the two tablespaces in question) should be the same in both the databases. Otherwise, it will lead to database corruption.

HTH

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp