Skip to Content
Former Member
May 02, 2013 at 05:52 AM

db2 restore redirect with tablespace in automatic storage


Dear ALL,

I need you help to understand the feature of "db2 restore redirect" in connection with tablespaces in automatic storage.

I have to recreate the system DEV to a new host. So the restore will be from DEV (old host) to DEV (new host).

The DEV in the new host will be created with HSC using sapinst and the backup/restore script. The dafault for new installation is to put "automatic storage" for automatic grow.

I will create the restore script. My question is about what do I have to modify in the restore. For what I read around I have to put the

"set tablespace container" command into the script only for the temporary tablespaces the usual are of SMS type. The other DMS tablespaces does not need to have a "set container" declared.

Is it my assumption correct?

Is there any further action I have to consider?

please let me know.

Any help would be really appreciated.