Configuring the Data Pump

These steps configure the data pump that reads the local trail and sends the data across the network to a remote trail.

  1. In GGSCI on the source system, create the data-pump parameter file.
    EDIT PARAMS name

    Where: name is the name of the data pump Extract group.

  2. Enter the data-pump parameters in the order shown, starting a new line for each parameter statement. Your input variables will be different. See the following table for description.

    Basic parameters for the data-pump Extract group:

    EXTRACT extpump
SOURCEDB FINANCE USERID ogg, PASSWORD AACAAAAAAAAAAA, BLOWFISH ENCRYPTKEY mykey
RMTHOST fin1, MGRPORT 7809
RMTTRAIL /ggs/dirdat/rt
TABLE hr.*;
    Parameter Description 
    EXTRACT group

    group name is the name of the data pump. 

    SOURCEDB database USERID user, PASSWORD password, BLOWFISH ENCRYPTKEY keyname

    Specifies database connection information.

    • SOURCEDB specifies the default DB 2 for i database.

    • USERID specifies the Extract 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.

    		 
    RMTHOST hostname, MGRPORT portnumber

    • RMTHOST specifies the name or IP address of the target system.

    • MGRPORT specifies the port number where Manager is running on the target. 

    ENCRYPTTRAIL BLOWFISH

    Encrypts the remote trail with Blowfish encryption.

    		 
    RMTTRAIL pathname

    Specifies the path name of the remote trail.

    		 
    TABLE schema.object;
TABLE library/file;
TABLE library/file(member);

    Specifies a table or tables to process.

    Terminate the TABLE statement with a semi-colon.

    To exclude tables from a wildcard specification, use the TABLEEXCLUDE parameter after the TABLE statement.

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