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

{DTLARRAYSIZE= } Escape Sequence

{DTLARRAYSIZE= } Escape Sequence

Defines the DB2 fetch array size, in number of rows, for DB2 bulk data movement operations that use the DB2 access method. The array size pertains to the DB2 multiple-row FETCH statements that PowerExchange uses to read data from DB2 source tables.
Valid values are from 1 through 5000. Default is 25.
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.