Configuring Replicat

These steps configure the Replicat process in a basic way without any special mapping or conversion of the data.

  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.
    REPLICAT financer
TARGETDB FINANCIAL USERID ogg, PASSWORD AACAAAAAAAAAAA, BLOWFISH ENCRYPTKEY mykey
DISCARDFILE /users/ogg/disc
MAP hr.*, TARGET hr2.*;
    Parameter Description 
    REPLICAT group

    group is the name of the Replicat group. 

    TARGETDB database USERID user, PASSWORD password, BLOWFISH ENCRYPTKEY keyname

    Specifies database connection information.

    • SOURCEDB specifies the data source name (DSN) of the target DB2 for i database.

    • USERID specifies the Replicat database user profile.

    • PASSWORD specifies the user's password that was encrypted with the ENCRYPT PASSWORD command. Enter or paste the encrypted password after the PASSWORD keyword.

    • BLOWFISH ENCRYPTKEY keyname specifies the name of the lookup key in the local ENCKEYS file. 

    DECRYPTTRAIL BLOWFISH

    Decrypts the input trail.

    		 
    MAP owner.table, TARGET owner.table;
MAP owner.table, TARGET library/file;
MAP library/file, TARGET owner.table;
MAP library/file, TARGET library/file;

    Specifies a relationship between a source and target table or tables. The MAP clause specifies the source objects, and the TARGET clause specifies the target objects to which the source objects are mapped.

    • owner is the schema name.

    • table is the name of a table or a wildcard definition for multiple tables.

    • library is the IBM i library name or a wildcard definition for multiple libraries.

    • file is the IBM i physical file name or a wildcard definition for multiple physical files.

    Note:

    There is an optional physical file member name also allowed with the physical file of the form file(member) and member may also be a wildcard definition for multiple members.

    To exclude tables from a wildcard specification, use the MAPEXCLUDE parameter.

    For more information and for additional options that control data filtering, mapping, and manipulation, see MAP in Reference for Oracle GoldenGate.

  3. Enter any optional Extract parameters that are recommended elsewhere in this manual and any others shown in Summary of Extract Parameters.
  4. Save and close the file.