SystemCopy DB2 LUW without sapinst ?

[andreas_busch]

Hi,

it is possible to perform a systemcopy [ database - db6 ] without installing sap/using sapinst ?

With Oracle it is possible - sure you have to do some work after the restore -

So I couldn't find any useful hint to perform a systemcopy without usage of sapinst...

can anybody help me?

[markus_doehr2 · Accepted solution]

> With Oracle it is possible - sure you have to do some work after the restore -

> So I couldn't find any useful hint to perform a systemcopy without usage of sapinst...

You need to adapt things the same way you do for Oracle also for DB2.

Markus

[Former Member · Accepted solution]

Hello Andreas,

The options for copying a DB2 LUW based SAP system, are either migration using R3load, or a redirected DB restore.

The are a number of notes on this subject. Search for "brdb6brt", "redirected restore".

Here are some:

628156 DB6: Cross-Platform System Copy using Backup/Restore

511323 DB6: brdb6brt -Installing the latest redirected restore tool

867914 DB6: brdb6brt - Latest patch (currently 24)

See also:

Chapter 9 of the Administration Guide:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f03d5fb8-b619-2b10-c383-c6d568728...

Followin whitepaper is is good:

http://www.ibm.com/developerworks/data/library/techarticle/0308nesiem/0308nesiem.html

You may also be interested in db2inidb

See note 594301

Best Regards,

Paul

[andreas_busch · Accepted solution]

Thanks a lot for your answer.

@Paul:

R3LOAD is not our favourit so the system copy should be performed via redirect restore.

"628156 DB6: Cross-Platform System Copy using Backup/Restore" - did not solved my problem / I've to perform this system copy with sapinst too - see below:

...

2. Start a regular homogenenous system copy on the target system using R3SETUP or SAPINST as described in the respective homogeneous system copy guide (depending on your SAP release).

...

"511323 DB6: brdb6brt -Installing the latest redirected restore tool"

"867914 DB6: brdb6brt - Latest patch (currently 24)"

=> I don't understand how this tool could help me? By the way - it's already in use

"Chapter 9 of the Administration Guide:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f03d5fb8-b619-2b10-c383-c6d568728...;

Nice to know - really good but not really usable for this issue.

If I'll perform a redirect restore I have this to do in the way of the "normal" system copy - so start sapinst => [ sapinst will install the database ] and perform the redirect restore

"http://www.ibm.com/developerworks/data/library/techarticle/0308nesiem/0308nesiem.html"

I have read this article... not helpful

"You may also be interested in db2inidb

See note 594301" => interesting note - to speed up the backup procedure!

If you use Oracle - system copy - briefly:

1) source sap system - create restore script

2) target system - shutdown sap/oracle

3) tsm - target system should connect to source tsm [ to get the right backup ]

4) restore - without sapinst

5) create db-user/rights

6) start sap system + sm59, sm28 and so on

I don't have seen this for a db2 luw database ...

here I have to use sapinst - before I execute step 1)

thanks in advance for your help.

[andreas_busch · Accepted solution]

Hi Markus,

that the reason for my message - I couldn't find anything useful that will solve this issue.

[ without installing sap I could save 2-3hours on every system copy ]

Did you have perform a system copy in this way ?

[ redirect restore without usage of sapinst - for db2 luw ]

best regards

[andreas_busch · Accepted solution]

Hello Markus,

great day - I hope so ...

I think this should be the procedure for a system copy - with db2 luw

restore db6

rename database SID

create new OS user db2<Target SID>

create new database instance DB2<Target SID>

brdb6brt = Tool => create the .scr file

db2relocatedb => copy .scr File - relocate.txt [ change dbsid / user ]

rename directories - not even necessary

execute relocate => db2relocatedb -f Path to relocate.txt

remove old instance db2<Source SID>

regards

[andreas_herzog · Accepted solution]

I'd rather check SAPnotes 122222 and 91976...everything you'll need in order to perform a redirected restore of a DB6 database will be explained

GreetZ, AH

[andreas_busch · Accepted solution]

if somebody wants to know ...

success - rough overview:

1) backup your tables/customizing via export/transport

2) stop target system

3) backup your profiles/kernel

4) delete your db-logfiles

5) create and adapt the restore script from source system

6) restore/recovery - to target system

7) start sapinst

😎 truncate tables

9) change kernel/profiles

10) start system

11) adjust your new system ...

regards