- Oracle GoldenGate Classic Documentation
- Prepare
- Prepare Your Database for Oracle GoldenGate Classic Architecture
- Db2 for i
- Configuring Oracle GoldenGate for DB2 for i
- Configuring Replicat for Change Delivery to DB2 for i
- Configuring Replicat
Configuring Replicat
These steps configure the Replicat process in a basic way without any special mapping or conversion of the data.
- In GGSCI on the target system, create the Replicat parameter file.
EDIT PARAMS
name
Where:
name
is the name of the Replicat group. - 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 theENCRYPT PASSWORD
command. Enter or paste the encrypted password after thePASSWORD
keyword. -
BLOWFISH ENCRYPTKEY
keyname
specifies the name of the lookup key in the localENCKEYS
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 theTARGET
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 formfile
(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. -
- Enter any optional Extract parameters that are recommended elsewhere in this manual and any others shown in Summary of Extract Parameters.
- Save and close the file.