cancel
Showing results for 
Search instead for 
Did you mean: 

db2 restore redirect with tablespace in automatic storage

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member189725
Active Contributor
0 Kudos

The redirected restore script has 3 sections ,

1. the restore command with options including redirect

Eg

-- *****************************************************************************

-- ** automatically created redirect restore script

-- *****************************************************************************

RESTORE DATABASE SAMPLE

-- options

FROM '/db2/db2n4s/SAMPLE/backup'

TAKEN AT 20070906070005

-- options

INTO SAMPLE

-- options

REDIRECT;

-- options

*****************************************************************************

You need to make changes to this section .

2. The set tablespace container section .

  This is not required for automatic storage tablespaces as you do not control over the containers in auto storage feature . Infact if you want to convert a non auto storage database to auto storage you can do via this method . you do not have to modify this section. For both types , SMS and DMS , the database manager would ensure that tablespace containers of both types are striped across the available storage paths. You do not have to worry or make changes.

3. The restore command with continue section

Just check if the command is correct . No major changes required.

Hope this helps.

Regards

Ratnajit

hugo_amo
Employee
Employee
0 Kudos