(DI-2302) Collector for SLT Replication
The technical name of the collector is /DVD/MON_CL_COL_SLT.
This collector focuses on the monitoring of statuses for the tables that are defined in SAP Landscape Transformation (SLT) replication to the HANA system. More details about SLT replication can be found on the SAP help portal page for SAP Landscape Transformation Replication Server.
Default KPIs delivered with this collector
The following default KPIs are delivered with this collector:
KPI name | Description | Unit | Detail table |
---|---|---|---|
SLT_REPLICATION_ALL_CNT | Number of all tables set for replication | Count | Yes |
SLT_REPLICATION_FAILED_CNT | Number of tables with errors in replication | Count | Yes |
SLT_REPLICATION_INIT_CNT | Number of tables in the initial (load) replication phase | Count | Yes |
SLT_REPLICATION_REPL_CNT | Number of tables in the replication phase | Count | Yes |
SLT_REPLICATION_STOP_CNT | Number of tables with stopped/suspended replication | Count | Yes |
Input table
This collector uses input table /DVD/MON_SLT_I where the user can specify which mass transfer IDs (queues) and tables for the specific queues should be included in the monitoring, where only activated replications are monitored.
If the input table /DVD/MON_SLT_I does not provide any record, the collector’s logic is skipped and nothing is monitored.
Input table supports also wildcards for the following fields:
MT_ID
SCHEMA_NAME
TABLE_NAME
These fields reflect the same functionality for defining inputs as transaction LTRC.
Technical name | Description |
---|---|
MT_ID | Mass Transfer ID |
SCHEMA_NAME | Schema name |
TABLE_NAME | Table name |
ACTIVE | Is this rule active for monitoring? |
Parameters
The following parameter is used for this collector:
Parameter name | Description |
---|---|
REPORT_ONLY_FAILED_TABLES | By default, this parameter is disabled (has an empty value) and the collector selects all matching tables according to the defined records in the input table. If this parameter is enabled (set to X), the collector selects only tables where any error occurred and these tables match the rules defined in the input table. |
Detail table
The collector reports the replication details for all matching tables into detail table SLT Replication table details. The technical name of the detail table is /DVD/MON_S_SLT_DETAILS and contains the following fields:
Technical name | Description |
---|---|
TIMESTAMP | Time when the records are saved into the detail table |
SID | System ID |
MT_ID | Mass Transfer ID (reflects LTRC) |
SCHEMA_NAME | Schema Name (reflects LTRC) |
CONFIG_GUID | Config GUID (technical ID for mapping) |
TABNAME | Table Name |
ACTION | Last executed action for this particular table (example: Started Replication) |
ACTION_TSP | Timestamp of last executed action |
STATUS | Status of last executed action (example: In Progress) |
FAILED | Flag that signalizes error in the last executed action |
ERROR_MSG | Only fill out if the Failed flag is true. Error log messages can be found here separated by |. |
ERROR_TSP | Timestamp of last error in replication |