System copy

[Former Member]

We are implementing BI at this moment and for this we want to do a systemcopy of the R/3 PRD to the R/3 QA which of course is the source system for BI.

We are on R/3 4.72 and DB2 8.2.2 and want to perform the systemcopy from PRD to QA via an offline or online backup made with DB2 to TSM.

We tried earlier a remote cc. and a client export/import but the clients are to big for that so we ran out of resources very quickly.

Is it possible to do a systemcopy via db2 restore on QA from an online or offline DB2 backup made on PRD ? Or maybe someone knows a better way? Thanks in advance, Paul Bout

[markus_doehr2 · Accepted solution]

Yes- you can do that.

Check

http://service.sap.com/systemcopy

--

Markus

[Former Member]

Hello

you can use redirected restore method and brdb6brt tool .

There are some new options in brdb6brt like -replace .

Use the current version of brdb6brt and get help via

brdb6brt -h

-replace ReplaceDef replace strings in retrieved scripts. ReplaceDef

is the replacement definition. ReplaceDef example:

PRD=QAS,db2prd=db2qas. This definition replaces

PRD with QAS and db2prd with db2qas in the

customizable sections of the script

With -replace <Source DBSID>=<Target DBSID> you should get an useable script for your redirected restore .

If you think , note 326691 needs to be refreshed somehow , let us know .

Best regards

dirk

[Former Member]

Markus,

Thanks. So with this (4.72) version and DB2 8.2.2 note 326691 is still useable ?

You have any experience with this method? I know that we use this method on R/3 4.0B so i was a little anxious to use that today?

[markus_doehr2]

Yes - you will need to follow some steps before and after the backup/restore, check the guide, it´s pretty good

--

Markus