Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

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
    . For DB2 9.1 and later, 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.