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.