Performing Archival for Large Amounts of Data

You can archive large amounts of data in a single step.
CA RC/Extract™ for DB2 for z/OS
is integrated with CA Fast Load and CA Fast Unload using the
CA RC/Migrator™ for DB2 for z/OS
Model Services to efficiently archive large amounts of data. These options can only be selected through the Command Center. A valid license for CA Fast Load, CA Fast Unload,
CA RC/Migrator™ for DB2 for z/OS
, or
CA RC/Update™ for DB2 for z/OS
is required.
carcedb2
You can archive large amounts of data in a single step.
CA RC/Extract™ for DB2 for z/OS
is integrated with CA Fast Load and CA Fast Unload using the
CA RC/Migrator™ for DB2 for z/OS
Model Services to efficiently archive large amounts of data. These options can only be selected through the Command Center. A valid license for CA Fast Load, CA Fast Unload,
CA RC/Migrator™ for DB2 for z/OS
, or
CA RC/Update™ for DB2 for z/OS
is required.
2
2
Perform a Single-Step Extract and Load in Batch
The following steps create the JCL to perform the extract and loading of targets in a single batch job execution. The single-step extract command can only be executed in batch. The automatic creation of target objects is not supported.
Follow these steps:
  1. In the S column of the Command Center, specify
    S
    next to the source definition for which you want to perform an extraction and loading of targets.
    Press Enter.
    The Specify Extract Options pop-up screen appears.
  2. Define the extract options as described in Performing an Extract.
  3. Press PF3 to exit the screen.
    The Target Mapping panel appears.
  4. Define the targets. You must verify that
    the target tables and dependent objects are created before the job is executed.
  5. Press PF3 to exit the Target Mapping panel.
    The Load Target Options pop-up screen appears.
  6. Define the load target options, and press PF3 to exit the screen.
    The Batch Processor cards to perform the extract are created and loaded, and the Batch Processor interface is invoked. The Batch JCL Specification panel appears. You can submit the batch job or can save the JCL in a data set.
Perform a Single-Step Extract, Delete, and Load in Batch
The following steps create the JCL to perform the extract and
deletion of data in a single batch job execution. Optionally, a set of targets can be loaded with the extracted data in the same batch job. The single-step extract command can only be executed in batch. The automatic creation of target objects is not supported.
Follow these steps:
  1. In the S column of the Command Center, specify
    Z
    next to the source definition. The source definition is the one on which you want to perform an extraction and deletion of data, and loading of targets.
  2. Press Enter.
    The Specify Extract Options pop-up screen appears.
  3. Define the extract options as described in Performing an Extract, and press PF3 to exit the screen.
    The Deletion Options pop-up screen appears.
  4. Define the deletion options and press PF3.
    • If you chose Yes to View/Update Selection List, the source objects are displayed in a pop-up screen. By default, all tables are selected for deletion. You can choose the tables from which the extracted data is deleted.
    • If you chose SQL as the Data Deletion Method, the SQL Delete Options pop-up screen appears. Specify the Commit Frequency.
    • If you chose Utilities as the Data Deletion Method, the Utilities Delete Option pop-up screen appears. Specify a Model to be used for the utility options. You can update or view the model, or receive a selection list of models. The model must have Fast Unload selected; otherwise, an error message is received.
    • If you chose Yes to Load Targets, the Target Mapping panel appears.
    The Batch Processor cards are created to perform the extract and load, and the Batch Processor interface is invoked. The Batch JCL Specification panel appears. You can submit the batch job or can save the JCL in a data set.