Create a reference mapping - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

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.

Syntax
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 }
;
Note:
  • 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

The following RSL file, refmaps.rsl, creates a reference mapping at server AXQ9 that duplicates the qadba.emp and qadba.payroll table mappings at server SAIXD1.
-- refmaps.rsl
CREATE REFERENCE MAPPINGS AT AXQ9
   LIKE SAIXD1
      INCLUDE TABLES SAIXD1.qadba.emp, SAIXD1.qadba.payroll
;