Hello,
DB2 V8.2 ESE /WIN 2003

As I mentioned in my previous Thread, due to the db maintenance I stopped the HADR and did the following on the Primary node.
* Created 1 Bufferpool with 8K
* Created 2 Tablespaces with 4K and 8K and add containers (each 3) in raid.
* Then move one table using LOAD to this new TS and created indexes.

Now I am planning to backup the Primary DB and Restore to Standby server to establish the HADR.

As the Standby server doesnt have this new TS and BP and Containers, how can I restore the db?
Before the restore, do I need to create the new TS/BP and containers in same locations? or
The restore will apply this change? Please help me.

I normally use the following restore syntax:

RESTORE DATABASE mydatabase FROM D:\DB2Backup\ ,F:\DB2Backup\ ,E:\DB2Backup WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

THANKS, dgunas

I was searching in inforcentre and found some information. But I would like to get some suggestion from you.

The doc mentioned that the REDIRECT RESTORE is the only way to do this. But it only mentions about the TABLESPACE changes and not the BUFFERPOOL.

However as I have never used the REDIRECT RESTORE, is it possible me to manually create all the TS/BP and Containers (with same path) and table on the standby server, then do the normal restore? Wil this work?
Please post your suggestions.

Thanks.

They will be created during the restore and you do not need a redirected restore. I assume you have the exact same path names on both servers.

Thanks Marcus. Yes, the Standby server is having exactly same drive and other containers (D:\, E:\ and F:\ Drives.)
But when I created the TS on Primary I put the containers in a new folder called DB2INDEX04. See below.

CREATE REGULAR TABLESPACE INDEXSPACE04 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192
MANAGED BY DATABASE
USING (FILE 'D:\DB2INDEX04\INDEXCONT01'5505024,
FILE 'F:\DB2INDEX04\INDEXCONT02'5505024,
FILE 'E:\DB2INDEX04\INDEXCONT03'5505024)
EXTENTSIZE 16
PREFETCHSIZE 32
BUFFERPOOL INDEXBP04
OVERHEAD 8.300000
TRANSFERRATE 0.180000
FILE SYSTEM CACHING ;

In the SB server I dont have the DB2INDEX04 folder. So do I need to create this before the restore please?

Thanks

It should create the folder for you.