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

Enque replication SErver

EXPERT!!

I am Preparing the pre-requistes for the Installlation of Production on HA server. the document what i downloaded from the OSS about the Installation of HA. the quoted that "if required, you install an enqure replication server"

some one please explain me, if we leave this option on HA server, what will be affect on the HA ?

IS CI + Dialogue Instance should install on Local Disk or Shared disk for the HA ?

Regards

Anwer Waseem

SAP BASIS

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2007 at 10:15 AM

    Hi Anwer,

    ├Źn my opinion it is very helpful to have enque replication service. In case enque service fails and is started on the other cluster node then lock entries are rebuild from the replica table created as a result of this service and hence no roll back is done.

    Also it is better to have CI and DI on a shared disk from HA perspective.

    Please award points if you found the answer useful.

    Regards.

    Ruchit.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Ruchit

      I am using the SQL 2005 sp1 on windows server 2003 IA64

      Thanks very much for your expert opinion that enque replication service is necessary for the HA. does roll back exist in sql 2005 as in oracle ?

      SAP has mentioned in the installation guide that CI & DI should be on local disk, do not enter the shared disk A(SCS) instances. also the diagram is complete self explanatory that CI on Node A and DI should be on Node B.

      Can I use the CI & DI instance on the new shared disk instead of local and A(SCS) disk. ?

      If do i use the CI & DI instance on local disk then how the failover will switch to Node B where the CI not exist ?

      Regards

      Anwer Waseem

      SAP BASIS

  • author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2007 at 05:03 PM

    Hi Anwer,

    Sorry I misunderstood the word shared here? I though you were talking of sharing in terms of windows share or NFS mount. I was talking in terms of logical sharing. Yes of course in your context both CI and DI should be on different nodes which means different physical disks. This logical can be extended for DB instance as well. So yes different phsical disks are needed.

    Regarding roll backs yes it exists in MS SQL 2005 as well just as oracle. A roll back will occur if a transaction gets terminated without commit been done in order to avoid database inconsisstency. It is has a feature of all database management systems.

    I hope this is clearer now.

    Regards.

    Ruchit.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Ruchit!

      So, I should have to follow the instruction as written in the installation guide, that CI on Node A (local disk c:\ - e:\) and DI on Node B (local disk c:\ - e:\).

      What about the Failover switch to Node B where CI does not exist ?

      Does failover kill the session while switching to Node (a/b) ?

      Does session remain active while switching to Node (a/b) ?

      What about the size of database disk , its fine to 600GB with ECC component with double stack ?

      Regards

      Anwer Waseem

      SAP BASIS

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.