Administration and troubleshooting - SAP HANA on Amazon
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Administration and troubleshooting

Monitor the status of cluster

You can check the status of the cluster with the following command as root user:

root@prihana ~] pcs status
Cluster name: rhelhanaha
Stack: corosync
Current DC: sechana (version 1.1.19-8.el7_6.5-c3c624ea3d) - partition with quorum
Last updated: Thu Nov 12 09:44:08 2020
Last change: Thu Nov 12 09:43:20 2020 by root via crm_attribute on sechana

2 nodes configured
6 resources configured

Online: [ prihana sechana ]

Full list of resources:

 clusterfence   (stonith:fence_aws):    Started prihana
 Clone Set: SAPHanaTopology_HDB_00-clone [SAPHanaTopology_HDB_00]
     Started: [ prihana sechana ]
 Master/Slave Set: SAPHana_HDB_00-master [SAPHana_HDB_00]
     Masters: [ prihana ]
     Slaves: [ sechana ]
 hana-oip       (ocf::heartbeat:aws-vpc-move-ip):       Started prihana

Daemon Status:
  corosync: active/enabled
  pacemaker: active/enabled
  pcsd: active/enabled
[root@prihana ~]

You can check the SAP HANA replication status with the following command as a <sid>adm user:

hdbadm@prihana:/usr/sap/HDB/HDB00> python
/usr/sap/HDB/HDB00/exe/python_support/systemReplicationStatus.py
| Database | Host       | Port  | Service Name | Volume ID | Site
ID | Site Name  | Secondary  | Secondary | Secondary | Secondary
| Secondary     | Replication | Replication | Replication    |
|          |            |       |              |           |
|            | Host       | Port      | Site ID   | Site Name    |
Active Status | Mode        | Status      | Status Details |
| -------- | ---------- | ----- | ------------ | --------- | -------
| ---------- | ---------- | --------- | --------- | ------------
| ------------- | ----------- | ----------- | -------------- |
| SYSTEMDB | prihana | 30001 | nameserver   |         1 |       1 |
HDBPrimary | sechana |     30001 |         2 | HDBSecondary | YES
| SYNCMEM     | ACTIVE      |           |
| HDB      | prihana | 30007 | xsengine     |         2 |       1 |
HDBPrimary | sechana |     30007 |         2 | HDBSecondary | YES
| SYNCMEM     | ACTIVE      |           |
| HDB      | prihana | 30003 | indexserver  |         3 |       1 |
HDBPrimary | sechana |     30003 |         2 | HDBSecondary | YES
| SYNCMEM     | ACTIVE      |           |

status system replication site "2": ACTIVE
overall system replication status: ACTIVE

Local System Replication State
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

mode: PRIMARY
site id: 1
site name: HDBPrimary
hdbadm@prihana:/usr/sap/HDB/HDB00>