## 8.3.5  Checking the Status with the HDB Console
Use the HDB console to check the system replication status on all hosts and for all services.
Using the HDB console for a status check can be especially useful in an ASYNC replication. Yon can see additional information currently not shown by the system view, because in this mode the primary systen does not wait for acknowledgement upon arrival of the shipped redo log buffer. In this case, you have to check the current log position on the secondary system on each node and for each persistency relevant service. The command is to be executed per service using the hdbcons -p &lt;servicePID&gt; "replication into" parameter.
In the following example, you can get information about the used replication and operation modes (mode, operation\_mode). You can also see which IP address is used for data and log transfer (Log connection and Data connection) and - since this system replication example is running with operation mode logreplay - you can see how far the log replay is hanging behind the shipped log on this secondary (the delta between shippedLogPos and replayFinishLogPos ). For all services the replication status should be ReplicationStatus\_Active .
```
<sid>adm># hdbcons -p 54321 "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 'M19', instance '19' SAP HANA DB Management Server Console (type 'help' to get help for server commands) Executable: hdbindexserver (PID: 66110) [OK] --listing default statistics for volume 3 System Replication Secondary Information ======================================== System Replication Secondary Configuration [system_replication] site_id = 2 [system_replication] site_name = SiteA [system_replication] mode = sync [system_replication] operation_mode = logreplay [system_replication] datashipping_min_logsize_threshold = 5368709120 [system_replication] datashipping_min_time_interval = 600 [system_replication] reconnect_time_interval = 30 [system_replication] enable_log_compression = false [system_replication] preload_column_tables = true [system_replication] ensure_backup_history = true [system_replication] enable_ssl = off [system_replication] keep_old_style_alert = false [system_replication] enable_log_retention = 1 [system_replication] logshipping_max_retention_size = 1048576 Last Primary Host: ld2133 Last Primary Port: 32003 Log Connection - ptr : 0x00007fd58931a400 - channel : NetworkChannel FD 25 [0x00007fd5ad064a98] {refCnt=3, idx=2} 10.96.4.20/65117_tcp->10.96.4.22/32003_tcp Connected,[r---] - mode : ReplicationMode_Synchronous - logSinceLastBackup : 663552 bytes - timeSinceLastBackup : 67431655 microseconds Data Connection - ptr : 0x00007fd589315000
```
```
- channel : NetworkChannel FD 31 [0x00007fd5ad064c58] {refCnt=2, idx=3} 10.96.4.20/65118_tcp->10.96.4.22/32003_tcp Connected,[----] Secondary Statistics - Creation Timestamp : 08.12.2015-14.25.27 (1449584727282603) - Last Reset Timestamp : 08.12.2015-14.25.27 (1449584727282603) - Statistic Reset Count : 0 - ReplicationMode : sync - OperationMode : logreplay - ReplicationStatus : ReplicationStatus_Active - ReplicationStatusDetails : - ReplicationFullSync : DISABLED - shippedLogPos : 0x641cbb00 - shippedLogPosTimestamp : 08.12.2015-14.59.17 (1449586757965706) - sentLogPos : 0x0 - sentLogPosTimestamp : 01.01.1970-00.00.00 (0) - shippedLogBuffersCount : 11241 - shippedLogBuffersSize : 8335585280 bytes - shippedLogBuffersSizeUsed : 8309875456 bytes (99.69%) - shippedLogBuffersSizeNet : 8309875456 bytes (99.69%) - shippedLogBufferDuration : 0 microseconds - shippedLogBufferDurationMin : 0 microseconds - shippedLogBufferDurationMax : 0 microseconds - shippedLogBufferDurationSend : 0 microseconds - shippedLogBufferDurationComp : 0 microseconds - shippedLogBufferThroughput : 0.00 bytes/s - replayFinishLogPos : 0x641cbb00 - replayFinishLogPosTimestamp : 08.12.2015-14.59.17 (1449586757965706) - replayStartLogPos : 0x641cbb00 - replayPushLogPos : 0x641cbb00 - replayRetentionLogPos : 0x62a66fcb - replayStepCount : 61709 - replayLogSize : 8335581056 bytes - replayDuration : 111608005 microseconds - shippedSavepointVersion : 2252 - shippedSavepointLogPos : 0x5c595f82 - shippedSavepointTimestamp : 08.12.2015-14.25.28 (1449584728678668) - shippedFullBackupCount : 1 - shippedFullBackupSize : 17884512256 bytes - shippedFullBackupSizeNet : 17884512256 bytes (100.00%) - shippedFullBackupDuration : 81098893 microseconds - shippedFullBackupDurationComp : 0 microseconds - shippedFullBackupThroughput : 220527205.67 bytes/s - shippedLastFullBackupSize : 17884512256 bytes - shippedLastFullBackupSizeNet : 17884512256 bytes (100.00%) - shippedLastFullBackupStart : 08.12.2015-14.25.28 (1449584728678668) - shippedLastFullBackupEnd : 08.12.2015-14.26.49 (1449584809777561) - shippedLastFullBackupDuration : 81098893 microseconds - shippedDeltaBackupCount : 0 - shippedDeltaBackupSize : 0 bytes - shippedDeltaBackupSizeNet : 0 bytes (-nan%) - shippedDeltaBackupDuration : 0 microseconds - shippedDeltaBackupDurationComp : 0 microsecond - 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 - Secondary Backup History : complete - shippedMissingLogCount : 0 - shippedMissingLogSize : 0 bytes - backlogSize : 0 bytes - backlogTime : 0 microseconds - backlogSizeMax : 0 bytes - backlogTimeMax : 0 microseconds
```
```
- Secondary Log Connect time : 08.12.2015-14.25.27 (1449584727296916) - Secondary Data Connect time : 08.12.2015-14.25.27 (1449584727491743) - Secondary Log Close time : not set - Secondary Data Close time : not set - Secondary Log Reconnect Count : 0 - Secondary Log Failover Count : 0 - Secondary Data Reconnect Count : 0 - Secondary Data Failover Count : 0 [OK] --[EXIT] --[BYE]
```
## Related Information
<!-- image -->