Table of Contents

Search

  1. Preface
  2. Change Data Capture Introduction
  3. PowerExchange Listener
  4. PowerExchange Condense
  5. DB2 for i5/OS Change Data Capture
  6. Remote Logging of Data
  7. Introduction to Change Data Extraction
  8. Extracting Change Data
  9. Monitoring CDC Sessions
  10. Managing Change Data Extractions
  11. Tuning CDC Sessions
  12. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for i5/OS

CDC Guide for i5/OS

Starting PowerExchange Listener

Starting PowerExchange Listener

To start the PowerExchange Listener on i5/OS, use the SBMJOB command to invoke the DTLLST program.
In PowerExchange 9.0 and later, you cannot run the DTLLST program in interactive mode.
Before starting the PowerExchange Listener, verify that the following prerequisites are met:
  • The QMLTTHDACN system value is set to 1 or 2. For more information about the QMLTTHDACN system value, see the IBM i Information Center for i5/OS.
  • The JOBD description includes the ALWMLTTHD(*YES) parameter to allow multiple threads.
To enter the SBMJOB command, use the following syntax:
SBMJOB CMD(CALL PGM(
dtllib
/DTLLST) PARM(‘
node_name
’ ‘[CONFIG=
library/file(myconfig_member)
]’ ‘[LICENSE=
library/file(mylicense_key_member)
]’) JOB(
job_name
) JOBD(
datalib
/DTLLIST) PRTDEV(*JOBD) OUTQ(*JOBD) CURLIB(*CRTDFT) INLLIBL(*JOBD)
This syntax contains the following variables:
  • dtllib
    is the name of the PowerExchange software library that was entered at installation.
  • node_name
    is the PowerExchange Listener node name that was specified in the LISTENER statement of the
    datalib
    /CFG(DBMOVER) configuration member.
  • job_name
    is the name of the PowerExchange Listener job or started task.
  • datalib
    is the user-specified name for the PowerExchange data library that was entered at installation.
You can enter the SBMJOB command at the command line.
Alternatively, you can execute the SBMJOB command by using an automated scheduler, a CL program, or a REXX procedure. For example, include the SBMJOB command in a REXX member named STARTLST and then use the following statement to start the PowerExchange Listener:
STRREXPRC SRCMBR(STARTLST) SRCFILE(
datalib
/REXX)
You cannot use the pwxcmd program to start the PowerExchange Listener.

0 COMMENTS

We’d like to hear from you!