Target System

Configure the Manager process and Replicat group on the target system.

To Configure the Manager Process

1. On the target, configure the Manager process.

2. In the Manager parameter file, use the PURGEOLDEXTRACTS parameter to control the purging of files from the local trail.

To Configure the Replicat Group

1. On the target, create a Replicat checkpoint table (unless using Oracle integrated Replicat). See About Checkpoint Table for instructions.
2. On the target, use the ADD REPLICAT command to create a Replicat group. For documentation purposes, this group is called rep.

   ADD REPLICAT rep
   [, INTEGRATED | PARALLEL | COORDINATED [MAXTHREADS number] |  ]
   , EXTTRAIL remote_trail 
   , BEGIN time
   ( SPECIALRUN |
                ( EXTFILE         file-name  |
                  EXTTRAIL        trail-name )
                 [ BEGIN           ( NOW | begin-datetime ) |
                  EXTSEQNO        trail-sequence-number [ EXTRBA trail-offset-number ] ]
                 [ CHECKPOINTTABLE table-name | NODBCHECKPOINT ] )
                 [ DESC            description ]
                 [ CRITICAL        [ YES | NO ]  ]
                 [ PROFILE         profile-name
                 [ AUTOSTART       [ YES | NO ]
                   [ DELAY            delay-number ] ]
                 [ AUTORESTART     [ YES | NO ]
                   [ RETRIES          retries-number ]
                   [ WAITSECONDS      wait-number    ]
                   [ RESETSECONDS     reset-number   ]
                   [ DISABLEONFAILURE [ YES | NO ]     ] ] ]

   Use the EXTTRAIL argument to link the Replicat group to the remote trail.

   See Parameters and Functions Reference for Oracle GoldenGate for detailed information about these and other options that may be required for your installation.

3. On the target, use the EDIT PARAMS command to create a parameter file for the Replicat group. Include the following parameters plus any others that apply to your database environment. For possible additional required parameters, see the Oracle GoldenGate installation and setup guide for your database.

   -- Identify the Replicat group:
   REPLICAT rep
   -- Specify database login information as needed for the database:
   [TARGETDB dsn_2][, USERIDALIAS alias]
   -- Specify error handling rules:
   REPERROR (error, response)
   -- Specify tables for delivery and threads if using coordinated Replicat:
   MAP [container.|catalog.]owner.table, TARGET owner.table[, DEF template]
   [, THREAD (thread_ID)][, THREADRANGE (thread_range[, column_list])]
   ;

   Note:

   For DB2 for i, you may need to use the ADD TRANDATA command on the target tables if they are not already journaled. Alternatively, you could use the STRJRNPF command to assign the tables to the appropriate journal. If the target tables are not required to be replicated by Oracle GoldenGate, the IMAGES(*AFTER) option can be used with STRJRNPF. Since Oracle GoldenGate operates using transactions, all tables must be journaled to support transactions and this is not the default with DB2 for i.