How to Check HANA Replication status

By | 01/11/2018

How to Check HANA Replication status

How to 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=1SAPCONTROL-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=1SAPCONTROL-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 acknowledgment 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 index server:

ps -ef | grep indexserver.


Click on the link below to read the following blog posts

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.