Skip to Content
author's profile photo Former Member
Former Member

DATABASE REFRESH ACTVITY FROM EP PRD TO QAS

Hi Experts, I am planning to db refresh from PRD to QAS on Enterprise portal systems.My environment is Windows/DB2/Unicode/SR2. Is db refresh process is same for ECC and EP or diifer? please provide me information for db fresh and is quite urgnet....is my first exp to perform this activity on EP systems.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 10, 2009 at 06:05 PM

    The actual DB refresh is the same as the ABAP stack, the only difference is that you also have to get an export of the CI. This is because there is data in the database that needs to change given the new instance name or hardware as well as an install has to be done again to update registry (windows) and the software: /usr/sap/<SID>

    You get a backup of the source, do the export of the CI. Restore the DB and do the DB and CI import. The DB part changes the schema if you change and resets all the DB authorities- very quick. The CI takes the longest- it essentailly does and install again, makes changes for the hardware/instance change and deploys all the applications/configuration again that gets reflected in the CI export files.

    There's a nice guide SAP has out there that describes the steps and such and now sapinst has options for the system copy which makes if straight forward. There are lots of post steps that need to be done as well that are in the guide- we found a few others that are minor and will be found with testing.

    RTFM.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2009 at 08:06 AM

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.