Check HANA Replication Status
There are some ways to gather information about the overall status of the sites and of the system replication.
One is via HANA Studio. We can go inside Landscape and then go to System Replication.
Using landscapeHostConfiguration.py
Check the overall status of the primary system using as <sid>adm OS user the script landscapeHostConfiguration.py
At OS level, go to the path:
/hana/shared/HBP/exe/linuxx86_64/HDB_2.00.031.00.1528768600_0d29bcd47c52b9ec46d38c93a44d168fdac79164/python_support
| Execute command | python systemReplicationStatus.py |
| hbpadm@BPCPRDSHD:/hana/shared/HBP/exe/linuxx86_64/HDB_2.00.031.00.1528768600_0d29bcd47c52b9ec46d38c93a44d168fdac79164/python_support> python 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 | bpcprdshd | 30201 | nameserver | 1 | 1 | NodeB | bpcprd | 30201 | 2 | NodeA | YES | SYNC | ACTIVE | | | HBP | bpcprdshd | 30207 | xsengine | 2 | 1 | NodeB | bpcprd | 30207 | 2 | NodeA | YES | SYNC | ACTIVE | | | HBP | bpcprdshd | 30203 | indexserver | 3 | 1 | NodeB | bpcprd | 30203 | 2 | NodeA | YES | SYNC | ACTIVE | |
status system replication site “2”: ACTIVE overall system replication status: ACTIVE
Local System Replication State ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
mode: PRIMARY site id: 1 site name: NodeB hbpadm@BPCPRDSHD:/hana/shared/HBP/exe/linuxx86_64/HDB_2.00.031.00.1528768600_0d29bcd47c52b9ec46d38c93a44d168fdac79164/python_support>
|
The script provides the following return codes.
- 10: No System Replication
- 11: Error
- 12: Unknown
- 13: Initializing
- 14: Syncing
- 15: Active
If we execute command:
python systemReplicationStatus.py –sapcontrol=1
We get below output:
| hbpadm@BPCPRDSHD:/hana/shared/HBP/exe/linuxx86_64/HDB_2.00.031.00.1528768600_0d29bcd47c52b9ec46d38c93a44d168fdac79164/python_support> python systemReplicationStatus.py –sapcontrol=1 SAPCONTROL-OK: <begin> service/bpcprdshd/30201/SHIPPED_LOG_POSITION_TIME=2018-08-23 18:34:54.181691 service/bpcprdshd/30201/LAST_LOG_POSITION_TIME=2018-08-23 18:34:54.181691 service/bpcprdshd/30201/SHIPPED_FULL_REPLICA_DURATION=2217757 service/bpcprdshd/30201/SHIPPED_LAST_DELTA_REPLICA_START_TIME=- service/bpcprdshd/30201/SHIPPED_FULL_REPLICA_SIZE=1627389952 service/bpcprdshd/30201/SITE_ID=1 service/bpcprdshd/30201/LAST_LOG_POSITION=291902528 service/bpcprdshd/30201/SECONDARY_ACTIVE_STATUS=YES service/bpcprdshd/30201/LAST_SAVEPOINT_LOG_POSITION=291902466 service/bpcprdshd/30201/FULL_SYNC=DISABLED service/bpcprdshd/30201/OPERATION_MODE=logreplay service/bpcprdshd/30201/SHIPPED_LAST_FULL_REPLICA_START_TIME=2018-08-06 13:09:58.664023 service/bpcprdshd/30201/LAST_SAVEPOINT_VERSION=65360 service/bpcprdshd/30201/LAST_SAVEPOINT_START_TIME=2018-08-23 18:35:01.151693 service/bpcprdshd/30201/SERVICE_NAME=nameserver service/bpcprdshd/30201/PORT=30201 service/bpcprdshd/30201/SHIPPED_DELTA_REPLICA_COUNT=0 service/bpcprdshd/30201/LAST_RESET_TIME=2018-08-06 13:09:53.701448 service/bpcprdshd/30201/SECONDARY_FAILOVER_COUNT=0 service/bpcprdshd/30201/SHIPPED_FULL_REPLICA_COUNT=1 service/bpcprdshd/30201/SHIPPED_LOG_BUFFERS_DURATION=1115171665 service/bpcprdshd/30201/REPLICATION_STATUS_DETAILS= service/bpcprdshd/30201/SHIPPED_DELTA_REPLICA_SIZE=0 service/bpcprdshd/30201/SHIPPED_LOG_POSITION=291902528 service/bpcprdshd/30201/SHIPPED_DELTA_REPLICA_DURATION=0 service/bpcprdshd/30201/RESET_COUNT=0 service/bpcprdshd/30201/SHIPPED_LAST_DELTA_REPLICA_SIZE=0 service/bpcprdshd/30201/SHIPPED_LAST_DELTA_REPLICA_END_TIME=- service/bpcprdshd/30201/SITE_NAME=NodeB service/bpcprdshd/30201/SECONDARY_SITE_NAME=NodeA service/bpcprdshd/30201/REPLAYED_LOG_POSITION_TIME=2018-08-23 18:34:54.181691 service/bpcprdshd/30201/SHIPPED_LAST_FULL_REPLICA_END_TIME=2018-08-06 13:10:00.881780 service/bpcprdshd/30201/CREATION_TIME=2018-08-06 13:09:53.701448 service/bpcprdshd/30201/HOST=bpcprdshd service/bpcprdshd/30201/SHIPPED_SAVEPOINT_VERSION=58735 service/bpcprdshd/30201/SECONDARY_HOST=bpcprd service/bpcprdshd/30201/VOLUME_ID=1 service/bpcprdshd/30201/SHIPPED_LAST_FULL_REPLICA_SIZE=1627389952 service/bpcprdshd/30201/SHIPPED_LOG_BUFFERS_SIZE=11004272640 service/bpcprdshd/30201/REPLICATION_MODE=SYNC service/bpcprdshd/30201/DATABASE=SYSTEMDB service/bpcprdshd/30201/REPLAYED_LOG_POSITION=291902528 service/bpcprdshd/30201/SECONDARY_RECONNECT_COUNT=0 service/bpcprdshd/30201/SHIPPED_SAVEPOINT_START_TIME=2018-08-06 13:09:58.664023 service/bpcprdshd/30201/SECONDARY_PORT=30201 service/bpcprdshd/30201/SHIPPED_SAVEPOINT_LOG_POSITION=119961090 service/bpcprdshd/30201/REPLICATION_STATUS=ACTIVE service/bpcprdshd/30201/SECONDARY_CONNECT_TIME=2018-08-06 13:09:58.647808 service/bpcprdshd/30201/SHIPPED_LOG_BUFFERS_COUNT=2450602 service/bpcprdshd/30201/SECONDARY_SITE_ID=2 service/bpcprdshd/30207/SHIPPED_LOG_POSITION_TIME=2018-08-23 18:34:41.806727 service/bpcprdshd/30207/LAST_LOG_POSITION_TIME=2018-08-23 18:34:41.806727 service/bpcprdshd/30207/SHIPPED_FULL_REPLICA_DURATION=398873 service/bpcprdshd/30207/SHIPPED_LAST_DELTA_REPLICA_START_TIME=- service/bpcprdshd/30207/SHIPPED_FULL_REPLICA_SIZE=150994944 service/bpcprdshd/30207/SITE_ID=1 service/bpcprdshd/30207/LAST_LOG_POSITION=187605376 service/bpcprdshd/30207/SECONDARY_ACTIVE_STATUS=YES service/bpcprdshd/30207/LAST_SAVEPOINT_LOG_POSITION=187605251 service/bpcprdshd/30207/FULL_SYNC=DISABLED service/bpcprdshd/30207/OPERATION_MODE=logreplay service/bpcprdshd/30207/SHIPPED_LAST_FULL_REPLICA_START_TIME=2018-08-06 13:10:04.141921 service/bpcprdshd/30207/LAST_SAVEPOINT_VERSION=74120 service/bpcprdshd/30207/LAST_SAVEPOINT_START_TIME=2018-08-23 18:34:27.230205 service/bpcprdshd/30207/SERVICE_NAME=xsengine service/bpcprdshd/30207/PORT=30207 service/bpcprdshd/30207/SHIPPED_DELTA_REPLICA_COUNT=0 service/bpcprdshd/30207/LAST_RESET_TIME=2018-08-06 13:09:53.682546 service/bpcprdshd/30207/SECONDARY_FAILOVER_COUNT=0 service/bpcprdshd/30207/SHIPPED_FULL_REPLICA_COUNT=1 service/bpcprdshd/30207/SHIPPED_LOG_BUFFERS_DURATION=86875089 service/bpcprdshd/30207/REPLICATION_STATUS_DETAILS= service/bpcprdshd/30207/SHIPPED_DELTA_REPLICA_SIZE=0 service/bpcprdshd/30207/SHIPPED_LOG_POSITION=187605376 service/bpcprdshd/30207/SHIPPED_DELTA_REPLICA_DURATION=0 service/bpcprdshd/30207/RESET_COUNT=0 service/bpcprdshd/30207/SHIPPED_LAST_DELTA_REPLICA_SIZE=0 service/bpcprdshd/30207/SHIPPED_LAST_DELTA_REPLICA_END_TIME=- service/bpcprdshd/30207/SITE_NAME=NodeB service/bpcprdshd/30207/SECONDARY_SITE_NAME=NodeA service/bpcprdshd/30207/REPLAYED_LOG_POSITION_TIME=2018-08-23 18:34:41.806727 service/bpcprdshd/30207/SHIPPED_LAST_FULL_REPLICA_END_TIME=2018-08-06 13:10:04.540794 service/bpcprdshd/30207/CREATION_TIME=2018-08-06 13:09:53.682546 service/bpcprdshd/30207/HOST=bpcprdshd service/bpcprdshd/30207/SHIPPED_SAVEPOINT_VERSION=67467 service/bpcprdshd/30207/SECONDARY_HOST=bpcprd service/bpcprdshd/30207/VOLUME_ID=2 service/bpcprdshd/30207/SHIPPED_LAST_FULL_REPLICA_SIZE=150994944 service/bpcprdshd/30207/SHIPPED_LOG_BUFFERS_SIZE=759889920 service/bpcprdshd/30207/REPLICATION_MODE=SYNC service/bpcprdshd/30207/DATABASE=HBP service/bpcprdshd/30207/REPLAYED_LOG_POSITION=187605316 service/bpcprdshd/30207/SECONDARY_RECONNECT_COUNT=0 service/bpcprdshd/30207/SHIPPED_SAVEPOINT_START_TIME=2018-08-06 13:10:04.141921 service/bpcprdshd/30207/SECONDARY_PORT=30207 service/bpcprdshd/30207/SHIPPED_SAVEPOINT_LOG_POSITION=175732226 service/bpcprdshd/30207/REPLICATION_STATUS=ACTIVE service/bpcprdshd/30207/SECONDARY_CONNECT_TIME=2018-08-06 13:10:04.123118 service/bpcprdshd/30207/SHIPPED_LOG_BUFFERS_COUNT=185520 service/bpcprdshd/30207/SECONDARY_SITE_ID=2 service/bpcprdshd/30203/SHIPPED_LOG_POSITION_TIME=2018-08-23 18:34:47.725031 service/bpcprdshd/30203/LAST_LOG_POSITION_TIME=2018-08-23 18:34:47.725031 service/bpcprdshd/30203/SHIPPED_FULL_REPLICA_DURATION=26587594 service/bpcprdshd/30203/SHIPPED_LAST_DELTA_REPLICA_START_TIME=- service/bpcprdshd/30203/SHIPPED_FULL_REPLICA_SIZE=22062039040 service/bpcprdshd/30203/SITE_ID=1 service/bpcprdshd/30203/LAST_LOG_POSITION=5000518400 service/bpcprdshd/30203/SECONDARY_ACTIVE_STATUS=YES service/bpcprdshd/30203/LAST_SAVEPOINT_LOG_POSITION=5000496322 service/bpcprdshd/30203/FULL_SYNC=DISABLED service/bpcprdshd/30203/OPERATION_MODE=logreplay service/bpcprdshd/30203/SHIPPED_LAST_FULL_REPLICA_START_TIME=2018-08-06 13:10:03.648789 service/bpcprdshd/30203/LAST_SAVEPOINT_VERSION=68005 service/bpcprdshd/30203/LAST_SAVEPOINT_START_TIME=2018-08-23 18:31:06.984925 service/bpcprdshd/30203/SERVICE_NAME=indexserver service/bpcprdshd/30203/PORT=30203 service/bpcprdshd/30203/SHIPPED_DELTA_REPLICA_COUNT=0 service/bpcprdshd/30203/LAST_RESET_TIME=2018-08-06 13:09:53.701272 service/bpcprdshd/30203/SECONDARY_FAILOVER_COUNT=0 service/bpcprdshd/30203/SHIPPED_FULL_REPLICA_COUNT=1 service/bpcprdshd/30203/SHIPPED_LOG_BUFFERS_DURATION=1328160121 service/bpcprdshd/30203/REPLICATION_STATUS_DETAILS= service/bpcprdshd/30203/SHIPPED_DELTA_REPLICA_SIZE=0 service/bpcprdshd/30203/SHIPPED_LOG_POSITION=5000518400 service/bpcprdshd/30203/SHIPPED_DELTA_REPLICA_DURATION=0 service/bpcprdshd/30203/RESET_COUNT=0 service/bpcprdshd/30203/SHIPPED_LAST_DELTA_REPLICA_SIZE=0 service/bpcprdshd/30203/SHIPPED_LAST_DELTA_REPLICA_END_TIME=- service/bpcprdshd/30203/SITE_NAME=NodeB service/bpcprdshd/30203/SECONDARY_SITE_NAME=NodeA service/bpcprdshd/30203/REPLAYED_LOG_POSITION_TIME=2018-08-23 18:34:47.725031 service/bpcprdshd/30203/SHIPPED_LAST_FULL_REPLICA_END_TIME=2018-08-06 13:10:30.236383 service/bpcprdshd/30203/CREATION_TIME=2018-08-06 13:09:53.701272 service/bpcprdshd/30203/HOST=bpcprdshd service/bpcprdshd/30203/SHIPPED_SAVEPOINT_VERSION=61379 service/bpcprdshd/30203/SECONDARY_HOST=bpcprd service/bpcprdshd/30203/VOLUME_ID=3 service/bpcprdshd/30203/SHIPPED_LAST_FULL_REPLICA_SIZE=22062039040 service/bpcprdshd/30203/SHIPPED_LOG_BUFFERS_SIZE=20998443008 service/bpcprdshd/30203/REPLICATION_MODE=SYNC service/bpcprdshd/30203/DATABASE=HBP service/bpcprdshd/30203/REPLAYED_LOG_POSITION=5000518400 service/bpcprdshd/30203/SECONDARY_RECONNECT_COUNT=0 service/bpcprdshd/30203/SHIPPED_SAVEPOINT_START_TIME=2018-08-06 13:10:03.648789 service/bpcprdshd/30203/SECONDARY_PORT=30203 service/bpcprdshd/30203/SHIPPED_SAVEPOINT_LOG_POSITION=4672418050 service/bpcprdshd/30203/REPLICATION_STATUS=ACTIVE service/bpcprdshd/30203/SECONDARY_CONNECT_TIME=2018-08-06 13:10:03.630591 service/bpcprdshd/30203/SHIPPED_LOG_BUFFERS_COUNT=3025533 service/bpcprdshd/30203/SECONDARY_SITE_ID=2 site/2/SITE_NAME=NodeA site/2/SOURCE_SITE_ID=1 site/2/REPLICATION_MODE=SYNC site/2/REPLICATION_STATUS=ACTIVE overall_replication_status=ACTIVE site/1/REPLICATION_MODE=PRIMARY site/1/SITE_NAME=NodeB local_site_id=1 SAPCONTROL-OK: <end> hbpadm@BPCPRDSHD:/hana/shared/HBP/exe/linuxx86_64/HDB_2.00.031.00.1528768600_0d29bcd47c52b9ec46d38c93a44d168fdac79164/python_support> |
Using landscapeHostConfiguration.py
At OS level, go to the path:
/hana/shared/HBP/exe/linuxx86_64/HDB_2.00.031.00.1528768600_0d29bcd47c52b9ec46d38c93a44d168fdac79164/python_support
| Execute command | python landscapeHostConfiguration.py |
| hbpadm@BPCPRDSHD:/hana/shared/HBP/exe/linuxx86_64/HDB_2.00.031.00.1528768600_0d29bcd47c52b9ec46d38c93a44d168fdac79164/python_support> python landscapeHostConfiguration.py | Host | Host | Host | Failover | Remove | Storage | Storage | Failover | Failover | NameServer | NameServer | IndexServer | IndexServer | Host | Host | Worker | Worker | | | Active | Status | Status | Status | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | Config | Actual | | | | | | | Partition | Partition | Group | Group | Role | Role | Role | Role | Roles | Roles | Groups | Groups | | ——— | —— | —— | ——– | —— | ——— | ——— | ——– | ——– | ———- | ———- | ———– | ———– | —— | —— | ——- | ——- | | bpcprdshd | yes | ok | | | 1 | 1 | default | default | master 1 | master | worker | master | worker | worker | default | default |
overall host status: ok hbpadm@BPCPRDSHD:/hana/shared/HBP/exe/linuxx86_64/HDB_2.00.031.00.1528768600_0d29bcd47c52b9ec46d38c93a44d168fdac79164/python_support> |
The following host states are possible:
- OK: System is OK.
- WARNING: A host auto-failover to a standby host is taking place.
- INFORMATION: The landscape is completely functional, but the current (actual) role of the host differs from the configured role.
- ERROR: There are not enough active hosts.
Please use the parameter “–sapcontrol=1”, if you require a reliable and parsable output
| hbpadm@BPCPRDSHD:/hana/shared/HBP/exe/linuxx86_64/HDB_2.00.031.00.1528768600_0d29bcd47c52b9ec46d38c93a44d168fdac79164/python_support> python landscapeHostConfiguration.py –sapcontrol=1 SAPCONTROL-OK: <begin> hostActualRoles=worker removeStatus= nameServerConfigRole=master 1 failoverStatus= hostConfigRoles=worker failoverActualGroup=default storageConfigPartition=1 host=bpcprdshd indexServerConfigRole=worker failoverConfigGroup=default storageActualPartition=1 indexServerActualRole=master nameServerActualRole=master hostActive=yes workerActualGroups=default workerConfigGroups=default hostStatus=ok storagePartition=1 SAPCONTROL-OK: <end> hbpadm@BPCPRDSHD:/hana/shared/HBP/exe/linuxx86_64/HDB_2.00.031.00.1528768600_0d29bcd47c52b9ec46d38c93a44d168fdac79164/python_support> |
Monitoring the connection
The connection between the primary and the secondary system should be available for replication. If this is not the case for a certain time, an internal event is generated which is visible as an internal event alert in the SAP HANA studio and in the system view M_EVENTS (if the old statistics server is used). With SPS09 system replication a specific alert was introduced.
Additionally, the replication connection can be checked using the HDB console:
hdbcons -e hdbindexserver “replication info”
| hbpadm@BPCPRDSHD:/hana/shared> hdbcons -e hdbindexserver “replication info” SAP HANA DB Management Client Console (type ‘?’ to get help for client commands) Try to open connection to server process ‘hdbindexserver’ on system ‘HBP’, instance ’02’ SAP HANA DB Management Server Console (type ‘help’ to get help for server commands) Executable: hdbindexserver (PID: 5051) [OK] — ## Start command at: 2018-08-23 17:58:29.428 listing default statistics for volume 3 System Replication Primary Information ====================================== System Replication Primary Configuration [system_replication] logshipping_timeout = 30 [system_replication] enable_full_sync = false [system_replication] preload_column_tables = true [system_replication] ensure_backup_history = true [system_replication_communication] enable_ssl = off [system_replication] keep_old_style_alert = false [system_replication] enable_log_retention = on [system_replication] logshipping_max_retention_size = 1048576 [system_replication] datashipping_snapshot_max_retention_time = 18000000000 [system_replication] async_logshipping_buffer_size = 268435456
– lastLogPos : 0x12a09d480 – lastLogPosTimestamp : 23.08.2018-12.28.27 (1535027307468179) – lastSavepointVersion : 67996 – lastSavepointLogPos : 0x12a099602 – lastSavepointTimestamp : 23.08.2018-12.26.06 (1535027166963608)
1 session registered.
Session index 0 – SiteID : 2 – RemoteHost : 10.34.85.135
Log Connection – ptr : 0x00007f4374ebb400 – channel : {<NetworkChannelSSLFilter>={<NetworkChannelBase>={this=139927701112856, fd=347, refCnt=2, idx=4, local=10.34.85.136/30303_tcp, remote=10.34.85.135/46893_tcp, state=Connected, pending=[r—]}}} – SSLActive : false – mode : ReplicationMode_Synchronous – lastShippingStart : 23.08.2018-12.28.27 (1535027307468196) – lastShippingEnd : 23.08.2018-12.28.27 (1535027307468783)
Data Connection – ptr : 0x00007f4194910800 – channel : {<NetworkChannelSSLFilter>={<NetworkChannelBase>={this=139919642131480, fd=348, refCnt=2, idx=5, local=10.34.85.136/30303_tcp, remote=10.34.85.135/46905_tcp, state=Connected, pending=[r—]}}} – SSLActive : false Primary Statistics – Creation Timestamp : 06.08.2018-07.39.53 (1533541193701272) – Last Reset Timestamp : 06.08.2018-07.39.53 (1533541193701272) – Statistic Reset Count : 0
– ReplicationMode : sync – OperationMode : logreplay
– ReplicationStatus : ReplicationStatus_Active – ReplicationStatusDetails : – ReplicationFullSync : DISABLED – shippedLogPos : 0x12a09d480 – shippedLogPosTimestamp : 23.08.2018-12.28.27 (1535027307468179) – sentLogPos : 0x12a09d480 – sentLogPosTimestamp : 23.08.2018-12.28.27 (1535027307468179) – shippedLogBuffersCount : 3021785 – shippedLogBuffersSize : 20981559296 bytes – shippedLogBuffersSizeUsed : 11739607296 bytes (55.95%) – shippedLogBuffersSizeNet : 11739600896 bytes (55.95%) – shippedLogBufferDuration : 1326782486 microseconds – shippedLogBufferDurationMin : 68 microseconds – shippedLogBufferDurationMax : 440177 microseconds – shippedLogBufferDurationSend : 68203730 microseconds – shippedLogBufferDurationComp : 0 microseconds – shippedLogBufferThroughput : 15823197.06 bytes/s – shippedLogBufferPendingDuration : 1106998733 microseconds – shippedLogBufferRealThrougput : 18970668.44 bytes/s
– replayLogPos : 0x12a09d480 – replayLogPosTimestamp : 23.08.2018-12.28.27 (1535027307468179) – replayBacklog : 0 microseconds – replayBacklogSize : 0 bytes – replayBacklogMax : 19997024 microseconds – replayBacklogSizeMax : 70254592 bytes
– shippedSavepointVersion : 61379 – shippedSavepointLogPos : 0x1167f7102 – shippedSavepointTimestamp : 06.08.2018-07.40.03 (1533541203648789)
– shippedFullBackupCount : 1 – shippedFullBackupSize : 22062039040 bytes – shippedFullBackupSizeNet : 22062039040 bytes (100.00%) – shippedFullBackupDuration : 26587594 microseconds – shippedFullBackupDurationComp : 0 microseconds – shippedFullBackupThroughput : 829786969.07 bytes/s
– shippedLastFullBackupSize : 22062039040 bytes – shippedLastFullBackupSizeNet : 22062039040 bytes (100.00%) – shippedLastFullBackupStart : 06.08.2018-07.40.03 (1533541203648789) – shippedLastFullBackupEnd : 06.08.2018-07.40.30 (1533541230236383) – shippedLastFullBackupDuration : 26587594 microseconds
– shippedDeltaBackupCount : 0 – shippedDeltaBackupSize : 0 bytes – shippedDeltaBackupSizeNet : 0 bytes (-nan%) – shippedDeltaBackupDuration : 0 microseconds – shippedDeltaBackupDurationComp : 0 microseconds – shippedDeltaBackupThroughput : 0.00 bytes/s
– shippedLastDeltaBackupSize : 0 bytes – shippedLastDeltaBackupSizeNet : 0 bytes (-nan%) – shippedLastDeltaBackupStart : not set – shippedLastDeltaBackupEnd : not set – shippedLastDeltaBackupDuration : 0 microseconds
– Secondary sync’ed via Log Count : 0 – syncLogCount : 0 – syncLogSize : 0 bytes – backupHistoryComplete : 1 – backupLogPosition : 0x12a068b80 – backupLogPositionUpdTimestamp : 23.08.2018-12.20.10 (0x5741947bf3446) – shippedMissingLogCount : 0 – shippedMissingLogSize : 0 bytes
– backlogSize : 0 bytes – backlogTime : 0 microseconds – backlogSizeMax : 7340032 bytes – backlogTimeMax : 2959196 microseconds
– Secondary Log Connect time : 06.08.2018-07.40.03 (1533541203630591) – Secondary Data Connect time : 06.08.2018-07.40.03 (1533541203643953) – Secondary Log Close time : not set – Secondary Data Close time : 06.08.2018-07.40.30 (1533541230293354) – Secondary Log Reconnect Count : 0 – Secondary Log Failover Count : 0 – Secondary Data Reconnect Count : 0 – Secondary Data Failover Count : 0
—————————————————————-
[OK] ## Finish command at: 2018-08-23 17:58:29.429 command took: 678.000 usec — [EXIT] — [BYE] hbpadm@BPCPRDSHD:/hana/shared> |
We should check for Replication status. It should be active and Replication Mode should be in sync
The output delivers “Log Connection” information for the connection used by the provided service. It also shows errors if the connection cannot be resolved properly:
| … Log Connection – ptr : 0x00007fdb6e8e3410 – channel : NetworkChannel FD 158 [0x00007fdb6f1bbc90] {refCnt=3, idx=1} 10.68.91.226/3 0103_tcp->10.68.92.13/49537_tcp Connected,[r—] … |
Using console
To check the replication status on all hosts and for all services the HDB console can be used. Especially in case of ASYNC replication this will provide some additional information currently not shown by the system view, because in this mode no acknowledgement is shipped and documented in the system view.
In this case an option is to check the current log position on the secondary using hdbcons on the secondary side – where currently no SQL is possible – on each node and for each persistency relevant service:
<sid>adm># hdbcons -e hdbindexserver “replication info”
Use the OS command
| lsof –n –p <indexserver-pid> |
to check, if the configured connection is actually used. The output delivers “Log Connection” information for the connection used by the provided service.
Following bash commands to determine the process ID of the indexserver:
ps -ef | grep indexserver
