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

AS400EVENTMSGQ Statement

AS400EVENTMSGQ Statement

The AS400EVENTMSGQ statement specifies the message queue on an
i5/OS
system to which PowerExchange writes messages that do
not
require a user reply.
i5/OS
DB2 for i5/OS
CAPI_CONNECTION - AS4J, AS400USRMSGQ
No
AS400EVENTMSGQ=
library
/
queue_name
Separate the following parameters by a slash (/):
library
The name of the library that contains the message queue.
queue_name
The message queue name.
PowerExchange writes messages to the specified message queue when ALWCLRPFM=Y, ALWLIBRFSH=Y, or AS4JRNEXIT=Y is specified on the AS4J CAPI_CONNECTION statement, as follows:
  • If ALWCLRPFM=Y, PowerExchange writes the DTL3002 message to the message queue if PowerExchange encounters a journal entry for a CLRPFM command. PowerExchange cannot replicate changes that a CLRPFM command makes.
  • If ALWLIBRFSH=Y, PowerExchange writes message DTL3003I for an *ADDLIB (add library) event and message DTL3004I for a *DLTLIB (delete library) event to the message queue when you issue the SNDPWXJRNE command with an
    Event Identifier
    value. This command triggers refresh processing of the CDC library interest list for the added or deleted libraries.
  • If AS4JRNEXIT=Y, PowerExchange writes the DTL3001 message for each journal receiver that a change data extraction processes. PowerExchange writes the message when it reads the first journal entry for the next journal receiver on the chain. If multiple change data extractions successfully process the same journal receiver, the message queue contains multiple DTL3001 messages for that journal receiver.
For more information about this message queue, see the
PowerExchange CDC Guide for
i5/OS
.