Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Moving Adabas Bulk Data

Moving Adabas Bulk Data

Use the following procedure to move Adabas bulk data.
Before you begin, gather the following information:
  • TCP/IP address or host name of the host that contains the Adabas database
  • Adabas database ID
  • Adabas file numbers for the files to be accessed
  • Your z/OS user ID and password, if required by the security settings in the SECURITY statement in the DBMOVER configuration file
To move Adabas bulk data:
  1. In the PowerExchange Navigator, create a data map.
    Click
    ADABAS
    in the
    Access Method
    list. To import metadata about data source records and fields, also select the
    Import Record Definitions
    option, the
    Import Key Fields/FDT
    option, or both.
    If you do not select the
    Import Record Definitions
    or
    Import Key Fields/FDT
    option, you can import the metadata later. Open the data map in the Resource Explorer and click
    File
     > 
    Import Copybook
    .
  2. Open the data map in the Resource Explorer, and click the nonrelational “record” or relational “table” view to verify that the metadata was successfully retrieved.
  3. If the data map is for a data source, send it to the PowerExchange Listener on the remote Adabas system. In the Resource Explorer, select the data map and click
    File
     > 
    Send to Remote Node
    . This step enables PowerExchange extraction routines to access the data map at runtime.
  4. In the
    Location
    field, enter the PowerExchange Listener node name that is specified in the NODE statement of the dbmover.cfg file on the local PowerExchange system. Complete the other fields, as needed.
    If you do not complete this step, you are prompted to send the data map to the remote node when you run a database row test.
  5. Run a database row test on the table view of the metadata to test that actual data can be returned from the Adabas source database.
  6. In the PowerCenter Designer, import the PowerExchange data map and create a mapping.
  7. In the PowerCenter Workflow Manager, define a workflow and session and configure a PWX NRDB Batch application connection. Then start the workflow to perform the bulk data movement.

0 COMMENTS

We’d like to hear from you!