Collector for SLT Replication

The technical name of the Collector for SLT Replication is /DVD/MON_CL_COL_SLT.

This collector focuses on the monitoring of statuses for the tables that are defined in the SAP Landscape Transformation (SLT) replication to the HANA system. For more information about SLT replication, see the SAP Help Portal page 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	Total number of tables set for the replication	Count	Yes
SLT_REPLICATION_FAILED_CNT	Number of tables with errors in the 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 a stopped/suspended replication	Count	Yes

Input Table

This collector uses the input table /DVD/MON_SLT_I, where you can specify which mass transfer IDs (queues) and tables for the specific queues you want to include in the monitoring. Note that only activated replications are monitored.

If the input table /DVD/MON_SLT_I does not provide any record, the collector logic is skipped and nothing is monitored.

The input table also supports wildcards for the following fields:

MT_ID
SCHEMA_NAME
TABLE_NAME

These fields reflect the same function for defining inputs as transaction LTRC.

Technical name	Description
MT_ID	Mass transfer ID
SCHEMA_NAME	Schema name
TABLE_NAME	Table name
ACTIVE	Whether this rule is 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 with the value <empty>. In this case, the collector selects all matching tables according to the defined records in the input table. If this parameter is enabled with the value X, the collector only selects tables in cases where an error occurred and where these tables match the rules defined in the input table.
MAX_PROCESS_RECS_TO_DETTAB	Specifies the maximum number of records that can be reported in the detail table.

Parameter name

Description

REPORT_ONLY_FAILED_TABLES

By default, this parameter is disabled with the value <empty>. In this case, the collector selects all matching tables according to the defined records in the input table.

If this parameter is enabled with the value X, the collector only selects tables in cases where an error occurred and where these tables match the rules defined in the input table.

MAX_PROCESS_RECS_TO_DETTAB

Specifies the maximum number of records that can be reported in the detail table.

Detail Table

The collector reports the replication details for all matching tables into the detail table SLT replication table details. The technical name of the detail table is /DVD/MON_S_SLT_DETAILS. It contains the following fields:

Technical name	Description
TIMESTAMP	Time when the records are saved to 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 the last executed action
STATUS	Status of the last executed action. Example: In Progress
FAILED	Flag that indicates an error in the last executed action
ERROR_MSG	Contains error log messages separated by the pipe symbol \|. This field is only filled out if the Failed flag is selected.
ERROR_TSP	Timestamp of the last error in the replication