Preface
Summary of PowerExchange New Features and Changes
- About This Summary
- PowerExchange 10.4.0
- PowerExchange 10.2 HotFix 2
- PowerExchange 10.2 HotFix 1
- PowerExchange 10.2
- PowerExchange 10.1.1 HotFix 2
  - Parameter and Option Changes in 10.1.1 HotFix 2
    - DBMOVER Configuration File Statements
- PowerExchange 10.1.1 HotFix 1
- PowerExchange 10.1.1
- PowerExchange 10.1
- PowerExchange 10.0
PowerExchange Installation and Upgrade
- PowerExchange 10.4.0 - New Features and Changes for Installation and Upgrade
  - New Features in 10.4.0
    - IBM i Installer
  - Behavior Changes in 10.4.0
    - PowerExchange for z/OS LOADLIB Allocation
- PowerExchange 10.1.1 - New Features and Changes for Installation and Upgrade
  - Behavior Changes in 10.1.1
    - Installation Change for DB2 for z/OS CDC
- PowerExchange 10.0 - New Features and Changes for Installation and Upgrade
  - Behavior Changes in 10.0
    - Changes to PowerExchange Installation and Functionality on Windows
PowerExchange Agent
- PowerExchange 10.2 HotFix 2 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.2 HotFix 2
    - Changes to the IAUPABND Option in the EDMSDIR Module
- PowerExchange 10.2 HotFix 1 - New Features and Changes for the PowerExchange Logger
  - Parameter and Option Changes in 10.2 HotFix 1
    - IAUPABND Option in the EDMSDIR Module
PowerExchange Client for PowerCenter
- PowerCenter 10.2 HotFix 2 - New Features and Changes for the PowerExchange Client for PowerCenter
  - Parameter and Option Changes in 10.2 HotFix 2
    - PWXPC Session Attributes
- PowerCenter 10.2 HotFix 1 - New Features and Changes for the PowerExchange Client for PowerCenter
  - New Features in 10.2 HotFix 1
    - Time-based Restart Points for CDC Sessions That Retrieve Data from the Logger
  - Parameter and Option Changes in 10.2 HotFix 1
    - PWXPC Connection Attributes
- PowerCenter 10.2 - New Features and Changes for the PowerExchange Client for PowerCenter
  - Parameter and Option Changes in 10.2
    - PWXPC Connection Attributes
- PowerCenter 10.1 - New Features and Changes for the PowerExchange Client for PowerCenter
  - Parameter and Option Changes in 10.1
    - PWXPC Connection Attributes
- PowerCenter 10.0 - New Features and Changes for the PowerExchange Client for PowerCenter
  - Parameter and Option Changes in 10.0
    - PWXPC Connection Attributes
PowerExchange Condense
- PowerExchange 10.2 HotFix 1 - New Features and Changes for PowerExchange Condense
  - Parameter and Option Changes in PowerExchange 10.2 HotFix 1
    - PowerExchange Condense Configuration Parameters
- PowerExchange 10.1 - New Features and Changes for PowerExchange Condense
  - Parameter and Option Changes in PowerExchange 10.1
    - PowerExchange Condense Configuration File Parameter
- Behavior Change in 10.1
  - Change to PowerExchange Condense Initialization
PowerExchange Listener
- PowerExchange 10.4.0 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.4.0
    - DBMOVER Configuration File Statements
- PowerExchange 10.2 HotFix 2 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.2 HotFix 2
    - DBMOVER Configuration File Statements
- PowerExchange 10.2 HotFix 1 - New Features and Changes for the PowerExchange Logger
  - Parameter and Option Changes in 10.2 HotFix 1
    - DBMOVER Configuration File Statements
- PowerExchange 10.2 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.2
    - DBMOVER Configuration File Statements
- PowerExchange 10.1.1 HotFix 2 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.1.1 HotFix 2
    - DBMOVER Configuration File Statements
- PowerExchange 10.1.1 HotFix 1 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.1.1 HotFix 1
    - DBMOVER Configuration File Statements
- PowerExchange 10.1.1 - New Features and Changes for the PowerExchange Listener
  - New Features in 10.1.1
    - Expanded OpenLDAP and Oracle LDAP Support for Requests to the PowerExchange Logger
  - Parameter and Option Changes in 10.1.1
    - DBMOVER Configuration File Statements
- PowerExchange 10.1 - New Features and Changes for the PowerExchange Listener
  - New Features in 10.1
    - OpenLDAP Support for Requests to the PowerExchange Listener
  - Parameter and Option Changes in 10.1
    - DBMOVER Configuration File Statements
- PowerExchange 10.0 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.0
    - DBMOVER Configuration File Statements
PowerExchange Logger for Linux, UNIX, and Windows
- PowerExchange 10.2 HotFix 2 - New Features and Changes for the PowerExchange Listener
  - Behavior Change in 10.2 HotFix 2
    - Checksum Testing of CDCT Records
- PowerExchange 10.2 HotFix 1 - New Features and Changes for the PowerExchange Logger
  - New Features in 10.2 HotFix 1
    - Time-based Restart Points for CDC Sessions That Retrieve Data from the Logger
  - Parameter and Option Changes in 10.2 HotFix 1
    - DBMOVER Configuration File Parameter
- PowerExchange 10.1.1 - New Features and Changes for the PowerExchange Logger
  - New Features in 10.1.1
    - Monitoring Statistics Printed at PowerExchange Logger for Linux, UNIX, and Windows Shutdown
    - Expanded OpenLDAP and Oracle LDAP Support for Requests to the PowerExchange Logger
- PowerExchange 10.1 - New Features and Changes for the PowerExchange Logger
  - New Features in 10.1
    - OpenLDAP Support for Requests to the PowerExchange Logger
- PowerExchange 10.0 - New Features and Changes for the PowerExchange Logger
PowerExchange Navigator
- PowerExchange 10.2 - New Features and Changes for the PowerExchange Navigator
  - New Features in 10.2
    - PowerExchange Navigator Overrides for the DBMOVER Configuration File and PowerExchange License Key File
  - Parameter and Option Changes in 10.2
    - Parameter for Issuing the LISTLOCATIONS Command
- PowerExchange 10.1.1 - New Features and Changes for the PowerExchange Navigator
  - New Features in 10.1.1
    - Support for Multiple Versions of the PowerExchange Navigator
- PowerExchange 10.0 - New Features and Changes for the PowerExchange Navigator
  - New Features in 10.0
    - Ability to Specify Restart Tokens for a Database Row Test
PowerExchange Monitoring and Tuning
- PowerExchange 10.4.0 - New Features and Changes for Monitoring and Tuning
  - Parameter and Option Changes in 10.4.0
    - DTLSMFRP JCL Parameter
- PowerExchange 10.2 HotFix 1 - New Features and Changes for Monitoring and Tuning
  - New Features in 10.2 HotFix 1
    - Generating Reports from SMF Statistics Records
- PowerExchange 10.2 - New Features and Changes for Monitoring and Tuning
  - New Features in 10.2
    - Improvements to SMF Statistics Records and Documentation
- PowerExchange 10.1.1 - New Features and Changes for Monitoring and Tuning
  - New Features in 10.1.1
    - Monitoring Statistics Printed at PowerExchange Logger for Linux, UNIX, and Windows Shutdown
    - Improvements to Statistics Fields in SMF Records
- PowerExchange 10.0 - New Features and Changes for Monitoring and Tuning
  - New Features in 10.0
    - Enhanced Monitoring Statistics for the PowerExchange Logger for Linux, UNIX, and Windows
PowerExchange Utilities
- PowerExchange 10.4.0 - New Features and Changes for PowerExchange Utilities
- PowerExchange 10.2 HotFix 2 - New Features and Changes for PowerExchange Utilities
  - New Features in 10.2 HotFix 2
    - PWXCATMY Utility for the Catalog of MySQL Source Table Definitions
- PowerExchange 10.2 HotFix 1 - New Features and Changes for PowerExchange Utilities
- PowerExchange 10.2 - New Features and Changes for PowerExchange Utilities
  - Parameter and Option Changes in 10.2
    - DTLUTSK Utility Parameter
- PowerExchange 10.1.1 - New Features and Changes for PowerExchange Utilities
  - New Features in 10.1.1
    - Enhancement to the Data Map Creation Utility
- PowerExchange 10.1 - New Features and Changes for PowerExchange Utilities
  - New Features in 10.1
    - Enhancements to the Data Map Creation Utility
- PowerExchange 10.0 - New Features and Changes for PowerExchange Utilities
  - New Features in 10.0
    - Enhancements to the Data Map Creation Utility
PowerExchange for Adabas
- PowerExchange 10.2 HotFix 1 - New Features and Changes for Adabas
- PowerExchange 10.1.1 - New Features and Changes for Adabas
  - New Features in 10.1.1
    - Support for Adabas Cipher Codes
- PowerExchange 10.1 - New Features and Changes for Adabas
  - Parameter and Option Changes in 10.1
    - Adabas ECCR Parameter
- PowerExchange 10.0 - New Features and Changes for Adabas
  - New Features in 10.0
    - Adabas Version 8.3.x Support
PowerExchange for CA Datacom
- PowerExchange 10.2 HotFix 1 - New Features and Changes for Datacom
  - New Features in 10.2 HotFix 1
    - Support for Datacom Version 15.1
  - Command Changes in 10.2 Hotfix 1
    - pwxcmd Commands for the Datacom Table-Based ECCR
- PowerExchange 10.0 - New Features and Changes for Datacom
  - New Features in 10.0
    - Datacom Version 15 Support
PowerExchange for DB2 for i
- PowerExchange 10.4.0 - New Features and Changes for Db2 for i
  - New Features in 10.4.0
    - Support for DB2 for i Version 7.4
- PowerExchange 10.2 HotFix 1 - New Features and Changes for Db2 for i
  - Parameter and Option Changes in 10.2 HotFix 1
    - DBMOVER Configuration Member Parameter
- PowerExchange 10.1.1 - New Features and Changes for DB2 for i5/OS
  - New Features in 10.1.1
    - DB2 for i5/OS Version 7.3 Support
- PowerExchange 10.1 - New Features and Changes for DB2 for i5/OS
  - New Features in 10.1
    - Generating SQL Statements for Re-creating Source or Target Objects for Troubleshooting
- PowerExchange 10.0 - New Features and Changes for DB2 for i5/OS
  - New Features in 10.0
    - Support for LOB Datatypes
PowerExchange for DB2 for Linux, UNIX, and Windows
- PowerExchange 10.2 - New Features and Changes for DB2 for Linux, UNIX, and Windows
  - Parameter and Option Changes in 10.2
    - DBMOVER Configuration File Statement
- PowerExchange 10.1.1 - New Features and Changes for DB2 for Linux, UNIX, and Windows
  - New Features in 10.1.1
    - Support for DB2 for Linux, UNIX, and Windows Version 11.1
PowerExchange for DB2 for z/OS
- PowerExchange 10.2 - New Features and Changes for DB2 for z/OS
  - New Features in 10.2
  - Parameter and Option Changes in 10.2
    - DB2 ECCR Configuration Statements in the REPL2OPT DD Data Set
- PowerExchange 10.1.1 HotFix 1 - New Features and Changes for DB2 for z/OS
  - New Features in 10.1.1 HotFix 1
    - DB2 12 for z/OS Support
  - Parameter and Option Changes in 10.1.1 HotFix 1
    - DB2 ECCR Configuration Statements in the REPL2OPT DD Data Set
- PowerExchange 10.1.1 - New Features and Changes for DB2 for z/OS
- PowerExchange 10.1 - New Features and Changes for DB2 for z/OS
  - New Features in 10.1
    - Improved Support of DB2 for z/OS Image Copies as Sources
  - Parameter and Option Changes in 10.1
    - DB2 ECCR Configuration Statements in the REPL2OPT DD Data Set
- PowerExchange 10.0 - New Features and Changes for DB2 for z/OS
  - New Features in 10.0
    - Support for LOB Datatypes
  - Behavior Changes in 10.0
    - DB2 for z/OS ECCR Changed Behavior
PowerExchange for CA IDMS
- PowerExchange 10.2 HotFix 1 - New Features and Changes for IDMS
  - Command Changes for 10.2 HotFix 1
    - pwxcmd Commands for the IDMS ECCR
- PowerExchange 10.0 - New Features and Changes for IDMS
  - New Features in 10.0
    - IDMS Version 19 Support
PowerExchange for IMS
- PowerExchange 10.4.0 - New Features and Changes for IMS
  - New Features in 10.4.0
    - Updated Components in the PowerExchange ECCR CRG.LOAD Library for IMS Synchronous CDC
    - Getting Source DBD Information from the IMS Catalog
  - Parameter and Option Changes in 10.4.0
    - DBMOVER Configuration File Statements
- PowerExchange 10.2 HotFix 2 - New Features and Changes for IMS
  - Command Changes for 10.2 HotFix 2
    - New Command for the IMS Log-Based ECCR
- PowerExchange 10.2 HotFix 1 - New Features and Changes for IMS
  - New Features in 10.2 HotFix 1
    - Support for IMS Version 15
    - Updated Components in the PowerExchange ECCR CRG.LOAD Library for IMS Synchronous CDC
  - Command Changes for 10.2 HotFix1
    - pwxcmd Commands for the IMS Log-Based ECCR
- PowerExchange 10.2 - New Features and Changes for IMS
  - New Features in 10.2
    - Updated Components in the PowerExchange ECCR CRG.LOAD Library for IMS Synchronous CDC
  - Behavior Changes in 10.2
    - Support for IMS Command Code A
- PowerExchange 10.1 - New Features and Changes for IMS
  - New Features in 10.1
    - IMS Version 14 Support
    - Updated Components in the PowerExchange 10.1 ECCR CRG.LOAD Library for IMS Synchronous CDC
  - Parameter and Option Changes in 10.1
    - DBMOVER Configuration File Statements
- PowerExchange 10.0 - New Features and Changes for IMS
  - New Features in 10.0
    - Updated Components in the PowerExchange 10.0 ECCR CRG.LOAD Library for IMS Synchronous CDC
PowerExchange for Microsoft SQL Server
- PowerExchange 10.4.0 - New Features and Changes for SQL Server
  - Parameter and Option Changes in 10.4.0
    - DBMOVER Configuration File
- PowerExchange 10.2 HotFix 1 - New Features and Changes for SQL Server
  - New Features in 10.2 HotFix 1
    - Support for Microsoft SQL Server 2017
- PowerExchange 10.2 - New Features and Changes for SQL Server
- PowerExchange 10.1.1 HotFix 1 - New Features and Changes for SQL Server
  - Parameter and Option Changes in 10.1.1 HotFix 1
    - DBMOVER Configuration File Statements
- PowerExchange 10.1.1 - New Features and Changes for SQL Server
  - New Features in 10.1.1
- PowerExchange 10.1 - New Features and Changes for SQL Server
  - New Features in 10.1
    - PowerExchange CDC No Longer Requires SQL Server Management Objects
  - Behavior Changes in 10.1
    - Handling Columns Added with the NOT NULL and DEFAULT Options to a SQL Server Source Table
- PowerExchange 10.0 - New Features and Changes for SQL Server
  - Behavior Changes in 10.0
    - Installation of the DataDirect ODBC Driver for SQL Server
  - Parameter and Option Changes in 10.0
    - DBMOVER Configuration File Statements
PowerExchange for MySQL
- PowerExchange 10.4.0 - New Features and Changes for MySQL
  - New Features in 10.4.0
    - Support for MySQL Version 8.0
  - Parameter and Option Changes in 10.4.0
    - DBMOVER Configuration File
- PowerExchange 10.2 HotFix 2 - New Features and Changes for MySQL
  - New Features in 10.2 HotFix 2
    - Catalog of MySQL Source Table Definitions
  - Parameter and Option Changes in 10.2 HotFix 2
    - DBMOVER Configuration File
- PowerExchange 10.2 HotFix 1 - New Features and Changes for MySQL
  - New Features in 10.2 HotFix 1
    - Support for MySQL CDC Sources
  - Parameter and Option Changes in 10.2 HotFix 1
    - DBMOVER Configuration File
PowerExchange for Oracle
- PowerExchange 10.4.0 - New Features and Changes for Oracle
- PowerExchange 10.2 HotFix 1 - New Features and Changes for Oracle
  - New Features in 10.2 HotFix 1
    - PowerExchange Express CDC for Oracle Support for Amazon RDS for Oracle Sources
    - Toleration Support for Oracle 12c R2 Sources
  - Parameter and Option Changes in 10.2 HotFix 1
    - PowerExchange Express CDC for Oracle Configuration File
- PowerExchange 10.2 - New Features and Changes for Oracle
  - New Features in 10.2
    - Reporting DDL Operations on Registered Oracle Source Tables
  - Parameter and Option Changes in 10.2
    - PowerExchange Express CDC for Oracle Configuration File
- PowerExchange 10.1 - New Features and Changes for Oracle
  - New Features in 10.1
  - Parameter and Option Changes in 10.1
    - PowerExchange Express CDC for Oracle Configuration File
- PowerExchange 10.0 - New Features and Changes for Oracle
  - New Features in 10.0
    - PowerExchange Express CDC for Oracle Supports Oracle Index-Organized Tables
    - PowerExchange Express CDC for Oracle Supports Oracle 12c Multitenant Pluggable Databases
  - Parameter and Option Changes in 10.0
    - PowerExchange Express CDC for Oracle Configuration File
PowerExchange for PostgreSQL
- PowerExchange 10.4.0 - New Features and Changes for PostgreSQL
  - New Features in 10.4.0
    - Support for PostgreSQL CDC Sources
  - Parameter and Option Changes in 10.4.0
    - DBMOVER Configuration File
PowerExchange for VSAM and Flat Files
- PowerExchange 10.2 HotFix 2 - New Features and Changes for VSAM and Flat Files
  - New Features in 10.2 HotFix 2
    - Support for CICS Transaction Server Version 5.5
- PowerExchange 10.2 HotFix 1 - New Features and Changes for VSAM and Flat Files
  - New Features in 10.2 HotFix 1
    - Support for CICS Transaction Server Version 5.4
- PowerExchange 10.2 - New Features and Changes for VSAM and Flat Files
  - Behavior Changes in 10.2
    - Improved CICS/VSAM ECCR Reporting of Data Sets with CDC Disabled
- PowerExchange 10.1.1 HotFix 1 - New Features and Changes for VSAM and Flat Files
  - Behavior Changes in 10.1.1 HotFix 1
    - Improved CICS/VSAM ECCR Reporting of Data Sets with CDC Disabled
- PowerExchange 10.1 - New Features and Changes for VSAM and Flat Files
  - New Features in 10.1
    - Support for CICS Transaction Server Version 5.3
- PowerExchange 10.0 - New Features and Changes for VSAM and Flat Files
PowerExchange ODBC
- PowerExchange 10.2 HotFix 1 - New Features and Changes for ODBC
  - Parameter and Option Changes in 10.2 HotFix 1
    - USE_CATALOG_METADATA Option of the PWXOVERRIDES Parameter
- PowerExchange 10.2 - New Features and Changes for ODBC
  - Parameter and Option Changes in 10.2
- PowerExchange 10.0 - New Features and Changes for ODBC
  - Parameter and Option Changes in 10.0
    - Location Property

Release Guide

10.4.0
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1

Back Next

DB2 for z/OS ECCR DISPLAY Command

When you issue a DB2 for z/OS ECCR DISPLAY command, the ECCR now displays detail-level statistics in the PWXEDM177085I message only for source tables for which it has received DML changes from DB2. The PWXEDM177085I and PWXEDM177084I statistics messages are written to the EDMMSG data set.

To list detail-level statistics for every source table, including those with no change activity, you can include the new ALL parameter in the DISPLAY command. Use the following syntax:

DISPLAY,ALL
DISPLAY,ST,ALL
DISPLAY,SQ,ALL

Because ST is the default parameter for the DISPLAY command, DISPLAY,ALL and DISPLAY,ST,ALL are equivalent.

Parameter description:

ALL: Prints the SQ or ST detail-level statistics in message PWXEDM177085I for every source table, even those tables for which the ECCR has received no DML changes. If you omit the ALL parameter, the ECCR prints the detail-level statistics only for the source tables for which the ECCR received at least one DML change. If you specify the ALL parameter without the SQ or ST parameter, the ALL parameter applies to the ST detail-level statistics.

Example DISPLAY,ST output:

PWXEDM177084I ABCDSNB  capture statistics at 2016-09-06 21.30.29
DB2 Log Location  000000000007AE9460B6.0000.0000
DB2 Log Timestamp 2016-09-06 21.30.17
Current Delay=            sec   Average Delay=            sec
DB2 Log records       REC_TOT      REC_INTV REC_PSEC
                           13             0        0
EDM Messages          MSG_TOT      MSG_INTV MSG_PSEC
                            2             0        0
PWXEDM177085I Detail level statistics follow
      MSG_TOT      MSG_INTV MSG_PSEC  TABLE_NAME
            1             0        0  ABCOOK1.TSTP1
            1             0        0  ABCOOK1.SVT@ALL

Example DISPLAY,ST,ALL output:

PWXEDM177084I ABCDSNB  capture statistics at 2016-09-06 21.31.05
DB2 Log Location  000000000007AE9460EA.0000.0000
DB2 Log Timestamp 2016-09-06 21.30.17
Current Delay=            sec   Average Delay=            sec
DB2 Log records       REC_TOT      REC_INTV REC_PSEC
                           13             0        0
EDM Messages          MSG_TOT      MSG_INTV MSG_PSEC
                            2             0        0
PWXEDM177085I Detail level statistics follow
      MSG_TOT      MSG_INTV MSG_PSEC  TABLE_NAME
            0             0        0  ABCOOK1.V11TAB
            0             0        0  ABCOOK1.TSTP3
            0             0        0  ABCOOK1.TSTP2
            1             0        0  ABCOOK1.TSTP1
            0             0        0  ABCOOK1.SVT@SCC
            1             0        0  ABCOOK1.SVT@ALL
            0             0        0  ABCOOK1.RRF1
            0             0        0  ABCOOK1.P750612
            0             0        0  ABCOOK1.P707951D
            0             0        0  ABCOOK1.P707951C
            0             0        0  ABCOOK1.P707951B
            0             0        0  ABCOOK1.P707951A
            0             0        0  ABCOOK1.COMP1111222233334444555566667777888899990000COMP
            0             0        0  ABCOOK1.QAALLTYPES_DMAP

For more information, see the "DB2 for z/OS ECCR Commands" chapter in the

PowerExchange Command Reference

Command Changes in 10.1.1

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal