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

PRGIND Statement

PRGIND Statement

The PRGIND statement controls whether PowerExchange writes read progress messages to the PowerExchange message log file.
All
PRGINT
No
PRGIND={
N
|Y}
  • N
    . PowerExchange does not write read progress messages to the PowerExchange message log file.
  • Y
    . After reading the number of records specified in the PRGINT statement, PowerExchange writes PWX-04587 messages to the PowerExchange message log file. These messages indicate the number of records read by a CDC or bulk data movement session.
Default is N.
  • For CDC sources and nonrelational bulk data movement sources, include the PRGIND and PRGINT statements in the DBMOVER configuration file on the PowerExchange Listener machine. For relational bulk data movement sources, include the PRGIND and PRGINT statements in the DBMOVER configuration file on the PowerCenter Integration Service machine.
  • For DB2 relational connections, PowerExchange writes a PWX-04587 message after it reads the following number of records:
    The smallest multiple of the
    Array Size
    connection attribute that is greater than or equal to the value of PRGINT