## 11.2 M\_SYSTEM\_REPLICATION System View
Monitors system replication information.
## Structure
| Column name         | Data type    | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
|---------------------|--------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| SITE_ID             | INTEGER      | Specifies the generated site ID.                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| SITE_NAME           | VARCHAR(256) | Specifies the site name.                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| SECONDARY_SITE_ID   | INTEGER      | Specifies the generated site ID of the secondary site.                                                                                                                                                                                                                                                                                                                                                                                                                        |
| SECONDARY_SITE_NAME | VARCHAR(256) | Specifies the secondary logical site name.                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| REPLICATION_MODE    | VARCHAR(7)   | Specifies the configured replication mode. This can be specified as: ● SYNC: the synchronous replication that acknowledges when a buffer has been written to a disk. ● SYNCMEM: the synchronous repli­ cation that acknowledges when a buffer has arrived in the memory. ● ASYNC: the asynchronous replica­ tion. ● UNKNOWN:set if the replication mode cannot be determined (for example, if there is a communica­ tion error when getting status in­ formation from a service). |
| REPLICATION_STATUS  | VARCHAR(12)  | Specifies the replication status.                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| OPERATION_MODE      | VARCHAR(32)  | Specifies the operation mode.                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| Column name                  | Data type   | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
|------------------------------|-------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| SECONDARY_READ_ACCESS_STATUS | VARCHAR(16) | Indicates whether the secondary sys­ tem is read-enabled and whether read access is activated. This column can have the following values: ● NOTCONFIGURED: specifies that an operation mode is used that does not allow read access. ● STOPPED: specifies that the sec­ ondary is running in operation mode logreplay_readaccess, but it is currently stopped. ● VERSION MISMATCH: specifies that the secondary system is run­ ning in operation mode logre­ play_readaccess but read access is internally disabled on the secon­ dary system because it is on a dif­ ferent SAP HANAversion than the primary system. ● INITIALIZING: specifies that the secondary site is running in opera­ tion mode logreplay_readaccess but read access is not yet com­ pletely initialized. SQL connections to the secondary system fail in this state. ● ACTIVE: specifies that the secon­ dary system is running in operation mode logreplay_readaccess and is initialized for read access. SQL connections are possible in this state. |
| TIER                         | INTEGER     | Specifies the tier on which the source site is located.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |