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

DB2ID Statement

DB2ID Statement

The DB2ID statement defines the DB2 subsystem, plan, and access method load module that PowerExchange uses to process data from a DB2 for z/OS source for bulk data movement.
z/OS
DB2 for z/OS
DB2PLAN
No
DB2ID=(
db2_subsystem
   [,
plan
] [,{
module_name
|
DTLAMV8F
}] )
db2_subsystem
The DB2 subsystem identifier. The value is populated at installation. If you are creating a DB2ID statement for another DB2 subsystem, you must enter this value.
plan
The DB2 plan name for PowerExchange bulk data movement operations. Default is the value from the DB2PLAN statement.
{
module_name
|
DTLAMV8F
}
The PowerExchange DB2 access method load module. Options are:
  • DEFAULT
    . The default access method load module, which is DTLAMV8F.
  • DTLAMV8F
    . The module that PowerExchange uses to process multiple rows of data at a time by using DB2 multiple-row FETCH and INSERT SQL statements.
Default is DTLAMV8F.
  • If you can use the defaults for all parameters in this statement, including the subsystem ID from installation, you do not need to specify the DB2ID statement. Otherwise, you must define a DB2ID statement.
  • You can specify up to 25 DB2ID statements in a DBMOVER member.

0 COMMENTS

We’d like to hear from you!