SAP System Copy (Test-System) - Sybase/SAP ASE

[Private_Member_19084]

Hi experts,

we want to make a system copy from our Live-System to Qualiy-System.

I've heared from a copy function, which can copy the system from a backup and is already doing all important steps (changing SID, un-scheduling jobs, ...).

Does anybody know a guide, which guides me through a system copy of ECC-System (ehp 6) on Sybase ASE 15.7?

Kind regards

[Private_Member_19084 · Accepted solution]

I've found this documentation (see at the end), so it seems that the Copy is pretty simple on ASE.

If I understand correctly, I can make the copy simple from an ASE dump.

But my question is now, does it really change the DB-SID in target system, or it is it just a 1:1 copy?

Hopefully not.

Second question, do I only have to copy the <sid>-DB, right? Not saptools, and others....

https://websmp103.sap-ag.de/~sapidb/011000358700001323962012E

[Sriram2009 · Accepted solution]

Hi Christian

1.  I am not sure about the SAP on ASE, After copied from live to Qas with help SWPM you can rename / change the SID.

2. Normally we have to follow the homogeneous system copy guide for  QA refresh( from live to QAS system).

BR

SS

[Private_Member_19084 · Accepted solution]

Hello Sriram,

thx a lot for this.

I will have a try.

Kind regards

[Private_Member_19084 · Accepted solution]

Hello Sriram,

I've tested yesterday and works really, really good.

But just one thing.

In SWPM I define the database-devices durring the copy/installation.
I tried to setup the same structure like in source-system.

Normally with have splitted the data-files (001, 002, ...).
Is there also a possibility, to do this durring copy-process with SWPM?

Or how can this be handled?

Kind regards

[Private_Member_19084 · Accepted solution]

I've also got this now.

In SWPM-Setup just enter the size of the 1st Data-Device.

Durring step "Configure Database components" you get the error, "Unable to load database".

Now the other device have to be created via ISQL and they have to be altered with "FOR LOAD".

Works pretty good