Preface
Summary of PowerExchange New Features and Changes
- About This Summary
- PowerExchange 10.4.1
- PowerExchange 10.4.0 HotFix 1
- 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.1 - New Features and Changes for Installation and Upgrade
  - New Features in 10.4.1
    - IBM i Installer Improvements
  - Behavior Changes in 10.4.1
    - IBM i Installer Changed Behavior
- 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 Listener
  - 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.1 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.4.1
    - DBMOVER Configuration File Statements
- PowerExchange 10.4.0 HotFix 1 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.4.0 HotFix 1
    - DBMOVER Configuration File Statements
- 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 Listener
  - 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 Listener
  - 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 Listener
  - 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 Listener
- 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.4.1 - New Features and Changes for the PowerExchange Navigator
  - New Features
    - CheckNumData Function
  - Changed Behavior
    - Enhanced Datatype Validation for Selected Functions
- 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.1 - New Features and Changes for PowerExchange Utilities
  - New Features in 10.4.1
    - EDMUOPTS Utility
  - Parameter and Option Changes in 10.4.1
    - PWXUMAP Utility Parameters
- 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.4.1 - New Features and Changes for Adabas
  - New Features in 10.4.1
    - Support for Adabas Version 8.5.x
- 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.4.0 HotFix 1 - New Features and Changes for DB2 for Linux, UNIX, and Windows
  - Parameter and Option Changes in 10.4.0 HotFix 1
    - DBMOVER Configuration File Statement
- 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.4.1 - New Features and Changes for DB2 for z/OS
  - New Features in 10.4.1
    - Db2 for z/OS Huffman Compression Support
  - Parameter and Option Changes in 10.4.1
    - Db2 for z/OS ECCR Configuration Statements in the REPL2OPT DD Data Set
- 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.1 - New Features and Changes for SQL Server
  - Parameter and Option Changes in 10.4.1
    - DBMOVER Configuration File
- PowerExchange 10.4.0 HotFix 1 - New Features and Changes for SQL Server
  - New Features in 10.4.0 HotFix 1
    - Support for Microsoft SQL Server 2019
    - Adding ODBC Parameters for Connecting to a Microsoft SQL Server Source Database
- 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.1 - New Features and Changes for MySQL
  - New Features in 10.4.1
    - Support for MySQL Community Edition
- PowerExchange 10.4.0 HotFix 1 - New Features and Changes for MySQL
  - New Features in 10.4.0 HotFix 1
    - Adding ODBC Parameters for Connecting to a MySQL Source Database
- 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.1 - New Features and Changes for Oracle
  - New Features in 10.4.1
    - Staging Files for Improved CDC Performance in an ASM Environment
    - Support for Additional Oracle Versions in Amazon RDS Environments
  - Parameter and Option Changes in 10.4.1
    - PowerExchange Express CDC for Oracle Configuration File
- PowerExchange 10.4.0 HotFix 1 - New Features and Changes for Oracle
  - New Features in 10.4.0 HotFix 1
    - Toleration Support for Oracle 19c CDC Sources
- 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.1 - New Features and Changes for PostgreSQL
  - New Features in 10.4.1
    - Support for PostgreSQL 12.1
- PowerExchange 10.4.0 HotFix 1 - New Features and Changes for PostgreSQL
  - New Features in 10.4.0 HotFix 1
    - Adding ODBC Parameters for Connecting to a PostgreSQL Source Database
- 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.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Db2 for z/OS ECCR Configuration Statements in the REPL2OPT DD Data Set

PowerExchange 10.4.1 introduces the following change to a configuration statement in the data set or RUNLIB member that is allocated by the REPL2OPT DD statement in the Db2 for z/OS ECCR JCL:

IFI306 [OPT={N|

|F}] ...

Optional. Controls the Db2 ECCR interaction with the Db2 instrumentation facility interface (IFI). The default value for the OPT parameter has changed.

OPT: Specifies how the Db2 ECCR reads the Db2 log.

Valid values are:

Y
. Recommended. Returns CDC records from the Db2 log.
N
. Returns all records from the Db2 log.
F
. Returns CDC records from the log and filters them by registered tables.

New default is Y.