## 11.1 M\_SERVICE\_REPLICATION System View
Provides information about replicated services.
## Structure
| Column name   | Data type    | Unit   | Description                      |
|---------------|--------------|--------|----------------------------------|
| HOST          | VARCHAR(64)  |        | Specifies the host name.         |
| PORT          | INTEGER(10)  |        | Specifies the internal port.     |
| VOLUME_ID     | INTEGER      |        | Specifies the volume ID.         |
| SITE_ID       | INTEGER      |        | Specifies the generated site ID. |
| SITE_NAME     | VARCHAR(256) |        | Specifies the logical site name. |
| Column name                  | Data type      | Description                                                                                                                                                                                                                                                    |
|------------------------------|----------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| SECONDARY_HOST               | VARCHAR(64)    | Specifies the secondary host name.                                                                                                                                                                                                                             |
| SECONDARY_PORT               | INTEGER        | Specifies the secondary port.                                                                                                                                                                                                                                  |
| SECONDARY_SITE_ID            | INTEGER        | Specifies the generated ID of the secondary site.                                                                                                                                                                                                              |
| SECONDARY_SITE_NAME          | VARCHAR(256)   | Specifies the secondary logi­ cal site name.                                                                                                                                                                                                                    |
| SECONDARY_ACTIVE_STA­ TUS     | VARCHAR(16)    | Specifies the secondary ac­ tive status.                                                                                                                                                                                                                        |
| SECONDARY_CON­ NECT_TIME      | TIMESTAMP      | Specifies the time the con­ nection was established from the secondary site.                                                                                                                                                                                    |
| SECONDARY_RECON­ NECT_COUNT   | INTEGER        | Specifies the secondary re­ connect count.                                                                                                                                                                                                                      |
| SECONDARY_FAIL­ OVER_COUNT    | INTEGER        | Specifies the secondary fail­ over count.                                                                                                                                                                                                                       |
| SECONDARY_FULLY_RE­ COVERABLE | VARCHAR(5)     | Specifies that the secondary system can be fully recov­ ered with a backup from the primary system. If this value is FALSE, then the backup history is broken. If there is a takeover at that time, then start a new data backup once the takeover is finished. |
| REPLICATION_MODE             | VARCHAR(16)    | Specifies the replication mode.                                                                                                                                                                                                                                |
| REPLICATION_STATUS           | VARCHAR(16)    | Specifies the replication sta­ tus.                                                                                                                                                                                                                             |
| REPLICATION_STATUS_DE­ TAILS  | VARCHAR(1.024) | Specifies the replication sta­ tus details.                                                                                                                                                                                                                     |
| Column name                   | Data type   | Unit   | Description                                                                                                                                                                                                                                   |
|-------------------------------|-------------|--------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| FULL_SYNC                     | VARCHAR(16) |        | Specifies the full sync status: ● DISABLED: the full sync is not configured ● ENABLED: the full sync is configured, but it is not yet active (transac­ tions do not block in this state) ● ACTIVE: the full sync mode is configured and active |
| LAST_LOG_POSITION             | BIGINT      |        | Specifies the current log po­ sition.                                                                                                                                                                                                          |
| LAST_LOG_POSITION_TIME        | TIMESTAMP   |        | Specifies the current log po­ sition timestamp.                                                                                                                                                                                                |
| LAST_SAVEPOINT_VERSION        | INTEGER     |        | Specifies the current save­ point version.                                                                                                                                                                                                     |
| LAST_SAVEPOINT_LOG_PO­ SITION  | BIGINT(19)  |        | Specifies the current save­ point log position.                                                                                                                                                                                                |
| LAST_SAVE­ POINT_START_TIME    | TIMESTAMP   |        | Specifies the current save­ point timestamp.                                                                                                                                                                                                   |
| SHIPPED_LOG_POSITION          | BIGINT      |        | Specifies the shipped log positon.                                                                                                                                                                                                            |
| SHIPPED_LOG_POSI­ TION_TIME    | TIMESTAMP   |        | Specifies the shipped log po­ sition timestamp.                                                                                                                                                                                                |
| SHIPPED_LOG_BUF­ FERS_COUNT    | BIGINT      |        | Specifies the shipped log buffers count.                                                                                                                                                                                                      |
| SHIPPED_LOG_BUF­ FERS_SIZE     | BIGINT      |        | Specifies the shipped log buffers size in bytes.                                                                                                                                                                                              |
| SHIPPED_LOG_BUF­ FERS_DURATION | BIGINT      |        | Specifies the shipped log buffer duration in microsec­ onds.                                                                                                                                                                                   |
| REPLAYED_LOG_POSITION         | BIGINT      |        | Specifies the log end position of the last known replayed log buffer on the secondary site.                                                                                                                                                   |
| Column name                             | Data type   | Description                                                                          |
|-----------------------------------------|-------------|--------------------------------------------------------------------------------------|
| REPLAYED_LOG_POSI­ TION_TIME             | TIMESTAMP   | Specifies the timestamp of the last known replayed log buffer on the secondary site. |
| SHIPPED_SAVEPOINT_VER­ SION              | INTEGER     | Specifies the shipped save­ point version.                                            |
| SHIPPED_SAVE­ POINT_LOG_POSITION         | BIGINT      | Specifies the shipped save­ point log position.                                       |
| SHIPPED_SAVE­ POINT_START_TIME           | TIMESTAMP   | Specifies the shipped save­ point start time.                                         |
| SHIPPED_FULL_REP­ LICA_COUNT             | BIGINT      | Specifies the shipped full replica count.                                            |
| SHIPPED_FULL_REP­ LICA_SIZE              | BIGINT      | Specifies the shipped full replica size in bytes.                                    |
| SHIPPED_FULL_REP­ LICA_DURATION          | BIGINT      | Specifies the shipped full replica duration in microsec­ onds.                        |
| SHIPPED_LAST_FULL_REP­ LICA_SIZE         | BIGINT      | Specifies the shipped last full replica size in bytes.                               |
| SHIPPED_LAST_FULL_REP­ LICA_START_TIME   | TIMESTAMP   | Specifies the shipped last full replica start time.                                  |
| SHIPPED_LAST_FULL_REP­ LICA_END_TIME     | TIMESTAMP   | Specifies the shipped last full replica end time.                                    |
| SHIPPED_DELTA_REP­ LICA_COUNT            | BIGINT      | Specifies the shipped delta replica count.                                           |
| SHIPPED_DELTA_REP­ LICA_SIZE             | BIGINT      | Specifies the shipped delta replica size in bytes.                                   |
| SHIPPED_DELTA_REP­ LICA_DURATION         | BIGINT      | Specifies the shipped delta replica duration in microsec­ onds.                       |
| SHIP­ PED_LAST_DELTA_REP­ LICA_SIZE       | BIGINT      | Specifies the shipped last delta replica size in bytes.                              |
| SHIP­ PED_LAST_DELTA_REP­ LICA_START_TIME | TIMESTAMP   | Specifies the shipped last delta replica start time.                                 |
| Column name                           | Data type   | Unit         | Description                                                                                                                              |
|---------------------------------------|-------------|--------------|------------------------------------------------------------------------------------------------------------------------------------------|
| SHIP­ PED_LAST_DELTA_REP­ LICA_END_TIME | TIMESTAMP   |              | Specifies the shipped last delta replica end time.                                                                                       |
| ASYNC_BUF­ FER_FULL_COUNT              | BIGINT      |              | Specifies the number of times the asynchronous rep­ lication buffer was full.                                                             |
| BACKLOG_SIZE                          | BIGINT      |              | Specifies the current replica­ tion backlog in bytes.                                                                                     |
| MAX_BACKLOG_SIZE                      | BIGINT      |              | Specifies the maximum repli­ cation backlog in bytes.                                                                                     |
| BACKLOG_TIME                          | BIGINT      |              | Specifies the current replica­ tion backlog in microsec­ onds.                                                                             |
| MAX_BACKLOG_TIME                      | BIGINT      |              | Specifies the maximum repli­ cation backlog in microsec­ onds.                                                                             |
| REPLAY_BACKLOG_SIZE                   | BIGINT      | Byte         | Specifies the size of all log buffers that have been ship­ ped to the secondary site but have not yet been replayed on the scondary site. |
| REPLAY_BACKLOG_TIME                   | BIGINT      | Microseconds | Specifies the time difference between the time of the last shipped log buffer and the last replayed log buffer on the secondary site.    |
| MAX_REPLAY_BACK­ LOG_SIZE              | BIGINT      | Byte         | Specifies the maximum value of the REPLAY_BACK­ LOG_SIZE since the system startup.                                                        |
| MAX_REPLAY_BACK­ LOG_TIME              | BIGINT      | Microseconds | Specifies the maximum value of REPLAY_BACKLOG_TIME since the system startup.                                                             |