Skip to Content
avatar image
Former Member

DB2 v9.1fp4 on suse linux 10sp2 - redirect restor PRD to DEV

Hi All,

First of all thank you, for valuable TIME.

issue:

My development server got crashed due to failure of dedicated SAN. in simple lost every thing. since, even DB2 backups happening to SAN.

requirement:

As we lost all the developments and configuration of development server, we need build a DEV from PRD.

Steps taken:

a. we have installed Suse 10sp2 followed by db2 v9.1 fp4 and SAP ERP6.0 sr2.

b. taken backup of db2 & sap kernel backup by tar command followed by SAP db13 backup along with logs - for newly installed Development server.

hostname - development

SID - DEV

c. I need to restore development server with sid DEV from the backup of production with sid PRD.

To get all the data {development data, transaction data & configuration etc..}

Problem

Till now i haven't worked on DB2 restore, and the current requirement is to dump data from PRD in to DEV.

i.e.. db2 redirect restore

current landscape status:

Both production and development {freshly installed} are up and working fine.

PRD with all the live data, DEV freshly installed and without data.

Need to restore data from PRD to DEV.

Database: DB2 v9.1 fp4

OS: SUSE linux 10 sp2

SAP solution: ERP 6.0 sr2

Backup of PRD: in to SAN box {backup folder}, backup triggered by DB13 with include logs option.

I request you to guide me in understanding and performing the restoration.

i.e.. the steps to be performed along with the necessary precautions to be take to avoid problems.

PRD data to DEV.

Thank you very much your time.

by

Harika

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 06, 2011 at 04:08 AM

    Best thing to do is just follows SAP's system copy guide, using the database restore method for DB2.

    Copy guide's can be found here [https://service.sap.com/instguidesNW70|https://service.sap.com/instguidesNW70], look under the 'installation' link on the left hand side. You most likely need the NW7 EpH1 ABAP guide, direct link to it is [here.|https://websmp208.sap-ag.de/~sapidb/011000358700000171822011E]

    Since you already have the DEV system running and just need the database refreshed, at a very high level the process will be a little like this;

    - Stop DEV system & drop DEV database

    - Do re-directed restore of your PRD backup into DEV

    - Complete post processing tasks as described in SAP's system copy guide

    Helpful tip -> set you number of batch processes (rdisp/wp_no_btc) to zero on the DEV system the first time you start it after doing the PRD restore. This will stop any batch jobs starting which might send emails or process interfaces, you can then goto SM37 and disable all your batch jobs, then restart DEV with some batch processes defined.

    Daniel

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      dscdb6up syntax is wrong, simply provide the two passwords, no need to give usernames, these are determined from your environment settings.

      dscdb6up -create <sapprd password> <sidadm password>

      Might also want to move the current dscdb6.conf file so that a new one is created, might help highlight any other problems

      mv /sapmnt/DEV/global/dscdb6.conf /sapmnt/DEV/global/dscdb6.conf.old

      Edited by: Daniel Parker on May 18, 2011 10:04 AM