Check the Schema Mappings Defined in SAP Replication Server

Use check schema map to view all primary and replicate schema maps defined in SAP Replication Server.

Syntax

check schema map [[from <primary_data_server>.<primary_database>.[<from_schema>|NULL]]|
[to <replicate_data_server>.<replicate_database>.[<to_schema>|NULL]]]

Parameters

<primary_data_server>. <primary_database>: The name of the primary data server and database.
<from_schema>: The schema of the primary database.
<replicate_data_server>.<replicate_database>: The name of the replicate data server and database.
<to_schema>: The schema of the replicate database.
<NULL>: Specifies all primary schemas or all replicate schemas. Use NULL instead of <from_schema> and <to_schema>.

Examples

Example 1

Displays the schema map of the primary Oracle or Adaptive Server database.

check schema map from <PDS>.<PDB>.<SAPSR3>

Example 2

Displays the schema map of the primary IBM DB2 UDB database.

check schema map from <PDS>.<PDB>.<SAP<SID>

Example 3

Displays all the schema maps of the replicate database.

check schema map to <RDS>.<RDB>.NULL

Example 4

Displays the schema map of the replicate SAP HANA database.

check schema map to <RDS>.<RDB>.<tableowner>

Usage

If there is a schema mapping change during replication, you can use the check schema map command to check the current mapping relation. Later, you can alter the mapping according to your requirements.

See check schema map in the Reference Manual.