on 05-02-2013 6:52 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bruno,
Asuming that you use DB2 v9.7, the following IBM documentation may help you:
Regards,
Hugo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.