Preface
Summary of PowerExchange New Features and Changes
- About This Summary
- PowerExchange 10.5
- 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 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 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
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.5 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.5
    - DBMOVER Configuration File Statements
- 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 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 Navigator
- PowerExchange 10.5 - New Features and Changes for the PowerExchange Navigator
  - New Features for 10.5
    - Ability to Skip Data Rows for IMS Unload Data Sets During a Row Test
    - Ability to View IMS Unload Files From the DL/1 Batch Access Method Tab
  - Parameter and Option Changes for 10.5
    - Capture Registration Name Lengths
- 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 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 Utilities
- PowerExchange 10.5 - New Features and Changes for 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 for Adabas
- PowerExchange 10.5 - New Features and Changes for Adabas
  - Parameter and Option Changes in 10.5
    - Adabas ECCR Parameter
- 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 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 for DB2 for i
- PowerExchange 10.5 - New Features and Changes for Db2 for i
  - New Features in 10.5
    - Support for Extended Relative Record Number Values
    - TLS Security in a PowerExchange Network
  - Parameter and Option Changes in 10.5
    - DBMOVER Configuration File Statements
- 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 for DB2 for Linux, UNIX, and Windows
- PowerExchange 10.5 - New Features and Changes for DB2 for Linux, UNIX, and Windows
  - New Features in 10.5
    - Support for DB2 for Linux, UNIX, and Windows Version 11.5
  - Behavior Changes in 10.5
    - Required User Authority
- 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 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 for IMS
- PowerExchange 10.5 - New Features and Changes for IMS
  - New Features in 10.5
    - Updated Components in the PowerExchange ECCR CRG.LOAD Library for IMS Synchronous CDC
- 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 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 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.5 - New Features and Changes for Oracle
  - New Features in 10.5
    - Checkpointing In-flight Transactions
  - Parameter and Option Changes in 10.5
    - PowerExchange Express CDC for Oracle Configuration File
- 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 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.5 - New Features and Changes for VSAM and Flat Files
  - New Features in 10.5
    - Support for CICS Transaction Server Version 5.6
- 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 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

Release Guide

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

Back Next

DTLREXE Utility Statements

The following table identifies a new parameter that you can add in each DTLREXE control statement:

Statement	New, Changed, or Deprecated
DELETE	Changed - New config parameter
PING	Changed - New config parameter
SUBMIT	Changed - New config parameter
SYSTEM	Changed - New config parameter

Rename Saved Search

Table of Contents

Release Guide

Release Guide

DTLREXE Utility Statements

DTLREXE Utility Statements