(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

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

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

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

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