Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111

    Unanswered: DB Restore to setup HADR again.

    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

  2. #2
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111
    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.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Dec 2008
    Location
    Chennai
    Posts
    111
    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

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It should create the folder for you.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •