Usage
Creates reference mappings, that is, sending-to-receiving table mappings defined at a specified server (or servers) that refer to and duplicate one or more existing table mappings between other servers in the EDMM.
Use this to define many identical target servers. You define the reference target normally, with CREATE SHARED TABLES and CREATE TABLE MAPPINGS. Then, you can use CREATE REFERENCE MAPPINGS to refer to those already defined. In a large model, this can significantly reduce Connect CDC Director memory requirements. You do not have to refresh the available tables cache at the receiving server; you do not have to explicitly select any column mappings.
When importing RSL that includes reference mappings into Connect CDC Director, you must make sure the table mappings to which the CREATE REFERENCE MAPPINGS statements refer are already defined or that they precede the CREATE REFERENCE MAPPINGS statements in the RSL file.
CREATE REFERENCE MAPPINGS
[ REPLACE ] AT [ SERVER | SERVERS ] server-list
LIKE [ SERVER ] target-server
{ ALL [ TABLES ] | INCLUDE [ TABLE | TABLES ] table-list | OMIT [ TABLE | TABLES ] table-list }
;- server-list is a comma-separated list of server names. Reference mappings are created at the servers listed after the AT keyword. The reference mappings refer to and duplicate the mappings for the receiving tables specified in the table-list for the specified target-server.
- table-list is a comma-separated list of fully-qualified table names.
- To create reference mappings that reference more than one target server, specify at least one CREATE REFERENCE MAPPINGS statement for each such target server.
Parameters
|
Parameter |
Description |
|---|---|
|
REPLACE |
Specify this keyword if you want the reference mappings you are creating at this server or servers to replace any identical existing reference mappings at this server or servers. If you do not specify this keyword, and the reference mappings you are creating conflict with existing mappings, an error is reported. |
|
ALL |
Reference all the mappings at this target server. |
|
INCLUDE |
Reference only the mappings at this target server that are listed after the INCLUDE parameter. |
|
OMIT |
Reference all the mappings at this target server except those tables listed after the OMIT parameter. |
Example
-- refmaps.rsl
CREATE REFERENCE MAPPINGS AT AXQ9
LIKE SAIXD1
INCLUDE TABLES SAIXD1.qadba.emp, SAIXD1.qadba.payroll
;