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

PowerExchange Listener DISPLAY ACTIVE or LISTTASK Command

PowerExchange Listener DISPLAY ACTIVE or LISTTASK Command

Run the PowerExchange Listener DISPLAY ACTIVE or LISTTASK command to display CDC sessions that are active in the PowerExchange Listener.
The specific command name and syntax depends on how you issue the command, as follows:
  • Issue the DISPLAY ACTIVE command from the command line on the system where the PowerExchange Listener runs. For more information, see the
    PowerExchange Command Reference
    .
  • Use the pwxcmd program to issue the listtask command to a PowerExchange Listener that runs on the local system or a remote system. For more information, see the
    PowerExchange Command Reference
    .
  • In the PowerExchange Navigator, issue the LISTTASK command from the
    Database Row Test
    dialog box. For more information, see the
    PowerExchange Navigator User Guide
    .
  • If you run the PowerExchange Listener as an application service in the Informatica domain, run the infacmd pwx program to issue the ListTaskListener command. For more information, see the
    Informatica Command Reference
    .
In the command output, the
PwrCntrSess
field displays the PowerCenter session name in the following format:
integration_server_name
/
workflow_name
/
session_name
For example, when two CDC sessions are active, the DISPLAY ACTIVE or LISTTASK command produces the following output:
PWX-00711 Active tasks: PWX-00712 TaskId=1, Partner=10.10.10.01, Port=2480, PwrCntrSess=intserv1/workflow1/cdc_sess1, Application=
appl_name1
, Status=Active, AM=CAPXRT, Mode=Read, Process=, SessId= PWX-00729 Userid=
userid
, Client=
clientid
, File=
capture_registration_file_name
, Table=
table_name
, DB=
database_name
PWX-00712 TaskId=2, Partner=10.10.10.02, Port=2480, PwrCntrSess=intserv2/workflow2/cdc_sess2, Application=
appl_name2
, Status=Active, AM=CAPXRT, Mode=Read, Process=, SessId= PWX-00729 Userid=
userid
, Client=
clientid
, File=
capture_registration_file_name
, Table=
table_name
, DB=
database_name
PWX-00713 2 active tasks PWX-00709 0 Dormant TCBs

0 COMMENTS

We’d like to hear from you!