cancel
Showing results for 
Search instead for 
Did you mean: 

How to clone a UDB 9 and change the SID at the same time?

Former Member
0 Kudos

I get the document for cloning a UDB on another box.

However the new DB is of the same SID as the source.

How to re-SID during the redirected restore?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

you just have to use the option "REDIRECT GENERATE SCRIPT" at the end of your RESTORE-Command:

RESTORE DATABASE <db> FROM <source> REDIRECT GENERATE SCRIPT <location/scriptname.clp>

The command will generate a script, that must be customized regarding the DBSID. After that, the script must be executed.

[Have a look here for the complete syntax|http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0001976.html].

(before restoring, create the respective SAPDATA-directories in your target file system - also don't forget to adapt the SAPDATAs to the new SID within the redirect-script)

Another possibility for getting this done is to use SAPs heterogenous System Copy which is load based and can be done via SAPinst easily without generating scripts. In both cases I would recommend to read the respective System Copy Guides.

I hope this answers your question.

Best regards,

Marcel

Answers (0)