Can a tablespace level online backup be restored to another new database in DPF environment?
Example: I have a database with tablespaces syscatspace, tempsapce, userspace1, userspace2, userpace3. I only wanted to restore userspace 1 to another new database using a tablespace level backup. Here the new database should only have the restored tablespace. All the other existing data is not required on the new database.
Thank you all for your suggestions, however, I'm still having issues.
I'm on a partitioned environment (2 nodes).
Node 0: Catalog Node
Node 1 and Node 2 with data etc.
I'm attempting to run a redirect restore for just one tablespace for now. The restore is from an online tablespace backup image on a different instance.
Here is the command I ran followed by the error:
RESTORE DATABASE DB1_DB REBUILD WITH TABLESPACE ( TEMPSPACE2 , MYTABLESPACE, WRAPPER1 , TEMPSPACE16K_2 ) USE TSM OPEN 1 SESSIONS OPTIONS '-fromowner=Instance_1' TAKEN AT 20111128
122156 INTO DB2_DB NEWLOGPATH '/DB2_DBlog_dir/DB2_DB/NODE0002/' REDIRECT WITHOUT ROLLING FORWARD WITHOUT PROMPTING
It doesn't allow be to perform the restore as it states the following error message:
SQL2537N Roll-forward is required following the Restore.
I specifically stated the WITHOUT ROLLING FORWARD option as I will need to ROLLFORWARD to a specific point in time.