[Guide] SAP HANA -How To Check System Replication Status

This document shows How To Check  Replication status in Hana .

Replication Status in HANA can be checked from following ways.

  • Using console
  • Using SystemReplicationstatus.py
  • Using Sap Hana Studio
  • Using Command Line tool Hdbnsutil
  • Using sql query
  • Using Sap HANA Cockpit

 

Using console

To check the replication status on all hosts and for all services the HDB console can be used.

<sid>adm># hdbcons -e hdbindexserver “replication info”
Dumping replication statistics …
System Replication Secondary Information
========================================
System Replication Secondary Configuration

ReplicationStatus : ReplicationStatus_Active

For all services the ReplicationStatus should be ReplicationStatus_Active.

 

Using systemReplicationStatus.py

Check the overall status of the system replication using as <sid>adm OS user the script systemReplicationStatus.py (located in $DIR_INSTANCE/ /exe/python_support).
<sid>adm># python $DIR_INSTANCE/exe/python_support/systemReplicationStatus.py
| Host | Service Name | Site Name | Secondary | … | Replication |…
| | | | Host | | Status |
| —— | —————- | ——— | ——— | —– | ———– |—
| ld7805 | indexserver | WALLDORF | ld8475 | … | ACTIVE |
| ld8513 | statisticsserver | WALLDORF | ld8476 | | ACTIVE |
| ld8513 | xsengine | WALLDORF | ld8476 | | ACTIVE |
| ld8513 | nameserver | WALLDORF | ld8476 | | ACTIVE |
| ld8513 | indexserver | WALLDORF | ld8476 | | ACTIVE |
| ld8559 | indexserver | WALLDORF | NOT MAPPED | | |
overall system replication status: ACTIVE

 

 

Using SAP HANA studio

Check the overall status on the primary’s Overview tab, this should state, “All services are active and in sync”:

To check the status of replication in detail: Select Landscape tab  system replication (shows information from system view M_SERVICE_REPLICATION with a lot of columns):
For all services, the REPLICATION_STATUS should be “ACTIVE”.

 

 

 

Check via SQL query

Or directly get system replication specific information from the system view M_SERVICE_REPLICATION. On the primary execute:

select * from “SYS”.”M_SERVICE_REPLICATION”;

 

 

Using command line tool hdbnsutil

To view the system replication topology configuration status on both systems, execute hdbnsutil –sr_state on the primary and the secondary:
[email protected]:/usr/sap/TED/HDB07> hdbnsutil -sr_state
checking for active or inactive nameserver …
System Replication State
~~~~~~~~~~~~~~~~~~~~~~~~
mode: primary
site id: 1
site name: SITEA
Host Mappings:
~~~~~~~~~~~~~~
ld2131 -> [SITEA] ld2131
ld2131 -> [SITEB] ld2132
done.

Reference-sdn.sap.com

Leave a Reply