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

DB2 for z/OS Bulk Data Movement with Relational Source or Target Definitions

DB2 for z/OS Bulk Data Movement with Relational Source or Target Definitions

To perform a bulk data movement with DB2 for z/OS source data, use a relational source database connection, except under the conditions listed in DB2 for z/OS Bulk Data Movement with Nonrelational Source Definitions.
When you use a DB2 image copy as a data source, special considerations and procedures apply. For more information, see DB2 for z/O Bulk Data Movement with an Image Copy as a Data Source.
To perform a bulk data movement with a DB2 for z/OS target, use a relational target database connection.
Before you define the bulk data movement, gather the following information:
  • DB2 subsystem ID
  • DB2 table names in the format
    creator
    .
    table_name
  • z/OS user ID and password if required by the security settings in the SECURITY statement in the DBMOVER configuration member
If you want to preview the DB2 data from the PowerExchange Navigator first, you can create a personal metadata profile and run a database row test on it. The PowerExchange Navigator displays metadata for each DB2 column in a table. The metadata shows column attributes such as datatype, date format, and CCSID.

0 COMMENTS

We’d like to hear from you!