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>