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.