1. Oracle GoldenGate Classic Architecture Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. Db2 LUW
  5. Preparing Tables for Processing
  6. Creating a Temporal Table
  7. Configuring the Replicat Parameter File

Configuring the Replicat Parameter File

These steps configure the Replicat process. This process applies replicated data to a DB2 LUW target database.

  1. In GGSCI on the target system, create the Replicat parameter file.
    EDIT PARAMS name

    Where: name is the name of the Replicat group.

  2. Enter the Replicat parameters in the order shown, starting a new line for each parameter statement.

    Basic parameters for the Replicat group:

    REPLICAT financer
TARGETDB mytarget, USERIDALIAS myalias
ASSUMETARGETDEFS
MAP hr.*, TARGET hr2.*;
    Parameter Description 
    REPLICAT group

    group is the name of the Replicat group. 

    TARGETDB database, USERIDALIAS alias

    Specifies the real name of the target DB2 LUW database (not an alias), plus the alias of the database login credential of the user that is assigned to Replicat. This credential must exist in the Oracle GoldenGate credential store. For more information, see Database User for Oracle GoldenGate Processes. 

    ASSUMETARGETDEFS

    Specifies how to interpret data definitions. ASSUMETARGETDEFS assumes the source and target tables have identical definitions. (This procedure assume identical definitions.)

    Use the alternative SOURCEDEFS if the source and target tables have different definitions, and create a source data-definitions file with the DEFGEN utility. 

    MAP schema.object, TARGET schema.object;

    Specifies the relationship between a source table or multiple objects, and the corresponding target object or objects.

    • MAP specifies the source portion of the MAP statement and is a required keyword. Specify the source objects in this clause.

    • TARGET specifies the target portion of the MAP statement and is a required keyword. Specify the target objects to which you are mapping the source objects.

    • schema is the schema name or a wildcarded set of schemas.

    • object is the name of a table or a wildcarded set of objects.

    Terminate this parameter statement with a semi-colon.

    Note that only the asterisk (*) wildcard is supported for DB2 LUW. The question mark (?) wildcard is not supported for this database. To exclude objects from a wildcard specification, use the MAPEXCLUDE parameter.

  3. Enter any optional Replicat parameters that are recommended for your configuration. You can edit this file at any point before starting processing by using the EDIT PARAMS command in GGSCI.
  4. Save and close the file.