Preparing Microsoft Failover Cluster for Second Data Tier Installation

With the first data tier installed, in preparation for installing the second data tier, complete the configuration of the failover cluster to handle all the tasks involved in switching the two data tier nodes between active and passive states.

1. On the active cluster node, verify that all SAP Mobile Platform database services are started.
   • SAP Mobile Platform CacheDB
   • SAP Mobile Platform ClusterDB
   • SAP Mobile Platform LogDataDB
2. In Windows Explorer, navigate to the folder in which you installed the database when you installed the first data tier.
   If you did not change the default location, this folder is SMPData\CDB, where SMPData is the data folder you added to the cluster share disk.
3. Open each *errorlog.txt file and look for "Now accepting requests" as the last line.

   If instead you see error messages, there is a problem with the installation that you must fix before proceeding.

   If you do not check the error logs immediately after installing the data tier, you will see pairs of lines beginning "Starting checkpoint..." and "Finished checkpoint...". As long as these are the only lines logged after "Now accepting requests," the database is operating properly.

4. On the active cluster node, stop the SAP Mobile Platform database services.
5. In Windows Services panel, set all SAP Mobile Platform database services to be started manually.
   • SAP Mobile Platform CacheDB
   • SAP Mobile Platform ClusterDB
   • SAP Mobile Platform LogDataDB

   These services need to be set to start manually so that Microsoft Failover Cluster can have full control over starting and stopping them.

6. In the Microsoft Failover Cluster, define a failover unit so that the database services move from the current active node to the new active node when the active node fails over:
   • Windows 2003 – define a managed cluster resource group and add the database services to it.
   • Windows 2008 – add the database services to the existing file server service.

   For details, refer to the Microsoft Failover Cluster documentation.

7. Verify that all the database services stop when you take the failover unit offline, and start when you take the failover unit online.
   • Windows 2003 – failover unit is managed cluster resource group.
   • Windows 2008 – failover unit is file server service.
8. Verify that everything moves to the new active node when active and passive nodes are switched.
   1. Fail over to the other node to make it active.
   2. Verify that all SAP Mobile Platform database services shut down on the current, passive node.
   3. Go to the desktop on the other, active node and fail over that node back to the first node.
   4. Go to the desktop on the new active node and check the database log files.
      There should be no errors.