Performing the Load

After performing an extraction and defining the target subsystem and objects in which to load the data, you can load objects into the target environment. To define input to the load process, you specify an extract object (which contains the data to load). You also specify the target definition that is defined for that extract object. Load source definitions containing views with the SQL Load engine.
carcedb2
After performing an extraction and defining the target subsystem and objects in which to load the data, you can load objects into the target environment. To define input to the load process, you specify an extract object (which contains the data to load). You also specify the target definition that is defined for that extract object. Load source definitions containing views with the SQL Load engine.
Follow these steps:
  1. Enter 
    in the Option field of the
    CA RC/Extract™ for DB2 for z/OS
    Main Menu.
    The Extract/Load Services menu appears.
  2. Enter 
    4
     (for Perform Load) in the Option field.
    The Process Target Definition panel appears.
    If an extract object is modified before loading the data, the changes are automatically synchronized in the target definition. You can update the target objects from the Target Mapping panel. 
  3. Complete the fields on the panel to define the criteria for loading the target objects.
    If you specify Y for Parallel Load (for loading extracted data in separate jobs), specify
    B
    for the Process Mode field and
    U
    for the Load Method field.The DDL Options fields specify whether
    CA RC/Extract™ for DB2 for z/OS
    generates DDL to do the following automatically:
    • Create the target objects (if they do not exist).
    • Create referential integrity (if it does not exist).
    • Perform the Check Utility function (which helps verify that loaded data is referentially intact).
    Press Enter to process your selections.
    The product loads the data into the target environment.