Show TOC

check schema map Locate this document in the navigation structure

(Only if the replicate datatbase is SAP HANA database) Displays all the primary and replicate schema maps defined in 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 when you use NULL instead of <from_schema> and <to_schema> respectively.

Examples
Example 1

This example displays the schema map of the primary Oracle or Adaptive Server database.

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

This example displays the schema map of the primary IBM DB2 UDB database.

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

This example displays all the schema maps of the replicate database.

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

This example displays the schema map of the replicate SAP HANA database.

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

  • Use the check schema map command to check the schema mapping defined in the Replication Server.

  • 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.