Bulk Data Movement Guide

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

DB2 Multiple-Row FETCH and INSERT Statements

When you use multiple-row FETCH and INSERT statements, DB2 fetches or inserts multiple rows of data at one time. As a result, PowerExchange accesses the database fewer times, which improves bulk data movement performance.

For all of the DB2 versions that PowerExchange supports, PowerExchange can use multiple-row FETCH and INSERT statements.

The PowerExchange default access method module, DTLAMV8F, uses multiple-row FETCH and INSERT statements.

To use multiple-row statements for bulk data movement operations, ensure that the following configuration requirements are met:

In the DBMOVER configuration member, set the third positional parameter in the DB2ID statement to DTLAMV8F or DEFAULT to use multiple-row FETCH and INSERT statements. For more information about the DB2ID statement, see DB2ID Statement.

Set the region size in the PWXLSTNR or STARTLST member for the PowerExchange Listener started task or job to a size that is large enough to accommodate the increased storage requirements of multiple-row FETCH and INSERT processing.

Set the

Array Size

connection attribute to the number of rows that you want to fetch or insert at a time. Default is 25.

PowerExchange verifies that the version of the DB2 subsystem in the DB2ID statement supports multiple-row SQL statements.

PowerExchange dynamically lowers the array size when all the following conditions are true:

The database type is DB2.

The table contains LOB columns.

The

Array Size

value is greater than 1.

Row size *

Array Size

is greater than 16000000 bytes.

If these conditions are met, PowerExchange reduces the array size and logs message PWX-00186 on both the client and PowerExchange Listener machines.

For more information about DB2 multiple-row FETCH and INSERT statements, see the IBM DB2 for z/OS documentation.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

DB2 Multiple-Row FETCH and INSERT Statements

DB2 Multiple-Row FETCH and INSERT Statements