Preface
Summary of PowerExchange New Features and Changes
- About This Summary
- PowerExchange 10.5.5
- PowerExchange 10.5.4
- PowerExchange 10.5.3
- PowerExchange 10.5.2
- PowerExchange 10.5.1
- PowerExchange 10.5
- PowerExchange 10.4.1
- PowerExchange 10.4.0 HotFix 1
- PowerExchange 10.4.0
PowerExchange Installation and Upgrade
- PowerExchange 10.5.5 - New Features and Changes for Installation and Upgrade
  - IBM i Installer Improvement
- PowerExchange 10.5.3 - New Features and Changes for Installation and Upgrade
  - IBM i Installation Enhancement
- PowerExchange 10.5.2 - New Features and Changes for Installation and Upgrade
  - IBM i Installation
  - Manual Installation on IBM i
- PowerExchange 10.5.1 - New Features and Changes for Installation and Upgrade
  - Upgrade Consideration for IBM i
- 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 Client for PowerCenter
- PowerCenter 10.5.2 - New Features and Changes for the PowerExchange Client for PowerCenter
  - New Features in 10.5.2
    - CREATEFILE Large Format Physical Sequential (PS) Data Set Support
  - Parameter and Option Changes in 10.5.2
    - PWXPC Connection Attributes
- PowerCenter 10.5.1 - New Features and Changes for the PowerExchange Client for PowerCenter
  - New Features in 10.5.1
    - Sample Template for the PM_RECOVERY Table
    - Recovery Table Scripts
PowerExchange Condense
- PowerExchange 10.5.2 - New Features and Changes for PowerExchange Condense
  - Behavior Change in 10.5.2
    - Ability to Access the CCT File in Read Mode
PowerExchange Listener
- PowerExchange 10.5.5 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.5.5
    - DBMOVER Configuration File Statements
  - Command Changes in 10.5.5
    - DISPLAYSTATS Command
- PowerExchange 10.5.4 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.5.4
    - DBMOVER Configuration File Statements
- PowerExchange 10.5.3 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.5.3
    - DBMOVER Configuration File Statements
  - Behavior Changes in 10.5.3
    - Non-relational Optimized Read Process
- PowerExchange 10.5.2 - New Features and Changes for the PowerExchange Listener
  - New Features in 10.5.2
    - Improved Memory Management for Listeners on z/OS
  - Parameter and Option Changes in 10.5.2
    - DBMOVER Configuration File Statements
- PowerExchange 10.5.1 - New Features and Changes for the PowerExchange Listener
  - Parameter and Option Changes in 10.5.1
    - DBMOVER Configuration File Statements
- 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 Logger for Linux, UNIX, and Windows
- PowerExchange 10.5.4 - New Features and Changes for the PowerExchange Logger
  - Parameter and Option Changes in 10.5.4
    - PowerExchange Logger for LUW Configuration File
- PowerExchange 10.5.3 - New Features and Changes for the PowerExchange Logger
  - Parameter and Option Changes in 10.5.3
    - PowerExchange Logger for LUW Configuration File
- PowerExchange 10.5.2 - New Features and Changes for the PowerExchange Logger
  - Parameter and Option Changes in 10.5.2
    - PowerExchange Logger for LUW Configuration File
  - Behavior Change in 10.5.2
    - Ability to Access the CCT file in Read Mode
PowerExchange Logger for z/OS
- PowerExchange 10.5.5 - New Features and Changes for the PowerExchange Logger for z/OS
  - Behavior Change in 10.5.5
    - PowerExchange Logger Warns When the Current Active Log RBA Is Near the Maximum RBA
PowerExchange Navigator
- PowerExchange 10.5.5 - New Features and Changes for the PowerExchange Navigator
  - Parameter and Option Changes for 10.5.5
    - Row Table Option for SAP HANA Source Tables
  - Behavior Changes for 10.5.5
    - Database Row Test Default Value Changes
- PowerExchange 10.5.3 - New Features and Changes for the PowerExchange Navigator
  - New Features for 10.5.3
    - New Functions for User-Defined Fields
- PowerExchange 10.5.2 - New Features and Changes for the PowerExchange Navigator
  - Behavior Changes in 10.5.2
- 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
  - Behavior Changes in 10.4.1
    - Enhanced Datatype Validation for Selected Functions
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 Utilities
- PowerExchange 10.5.5 - New Features and Changes for PowerExchange Utilities
  - New Features in 10.5.5
    - DTLINFOX Utility
    - ZOSTOUCH Utility
  - Behavior Change in 10.5.5
    - DTLURDMO Utility
- PowerExchange 10.5.3 - New Features and Changes for PowerExchange Utilities
  - New Features in 10.5.3
    - DTLINFOX Utility
  - Parameter and Option Changes for 10.5.3
    - DDLFILE Option for HANOPTS Parameter
- PowerExchange 10.5.2 - New Features and Changes for PowerExchange Utilities
- PowerExchange 10.5.1 - New Features and Changes for PowerExchange Utilities
  - Parameter and Option Changes in 10.5.1
    - DTLUCBRG Utility Parameters
- 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 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 for DB2 for i
- PowerExchange 10.5.5 - New Features and Changes for Db2 for i
  - Parameter and Option Changes in 10.5.5
    - DBMOVER Configuration File Statement
  - Behavior Changes in 10.5.5
    - Support for IBM i Journals with more than 345K files
- PowerExchange 10.5.4 - New Features and Changes for Db2 for i
  - New Features in 10.5.4
    - Ability to Use a Secure Connection to the IBM i Server During Installation
  - Behavior Changes in 10.5.4
    - Support for the BOOLEAN Datatype
- PowerExchange 10.5.3 - New Features and Changes for Db2 for i
  - New Features in 10.5.3
    - Process Changes from Journal Receivers Outside of Default Processing
    - Db2 for i5/OS Version 7.5 Support
  - Parameter and Option Changes in 10.5.3
    - DBMOVER Configuration File Statement
- PowerExchange 10.5.2 - New Features and Changes for Db2 for i
  - Parameter and Option Changes in 10.5.2
    - DBMOVER Configuration File Statement
  - Behavior Changes in 10.5.2
    - PowerExchange Journal Exit
- 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 for DB2 for Linux, UNIX, and Windows
- PowerExchange 10.5.5 - Features and Changes for Db2 for Linux, UNIX, and Windows
  - Behavior Changes in 10.5.5
    - Support for BINARY and VARBINARY Datatypes
- PowerExchange 10.5.4 - Features and Changes for Db2 for Linux, UNIX, and Windows
  - Behavior Changes in 10.5.4
    - Support for the BOOLEAN Datatype
- 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 for DB2 for z/OS
- PowerExchange 10.5.5 - Features and Changes for Db2 for z/OS
  - New Features in 10.5.5
    - Db2 ECCR Configuration Statements in the REPL2OPT DD Data Set
- PowerExchange 10.5.3 - Features and Changes for DB2 for z/OS
  - New Features in 10.5.3
    - Db2 for z/OS Version 13 Support
- PowerExchange 10.5.2 - New Features and Changes for DB2 for z/OS
  - Parameter and Option Changes in 10.5.2
    - DB2 ECCR Configuration Statements in the REPL2OPT DD Data Set
- PowerExchange 10.5.1 - New Features and Changes for DB2 for z/OS
  - New Features in 10.5.1
    - DB2 Loader and IMS Netport Passphrase Support
  - Parameter and Option Changes in 10.5.1
    - %PWD Substitution Variable for Netport Jobs
- 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 for IMS
- PowerExchange 10.5.5 - New Features and Changes for IMS
  - New Features in 10.5.5
    - IMS 15.3 and 15.4 Support
    - Updated Components in the PowerExchange ECCR CRG.LOAD Library
  - Parameter and Option Changes in 10.5.5
    - DBMOVER Configuration File Statements
- PowerExchange 10.5.2 - New Features and Changes for IMS
  - Parameter and Option Changes in 10.5.2
    - DBMOVER Configuration File Statement
- PowerExchange 10.5.1 - New Features and Changes for IMS
  - New Features in 10.5.1
    - Passphrase Support for IMS Netport Jobs
- 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 for Microsoft SQL Server
- PowerExchange 10.5.4 - New Features and Changes for SQL Server
  - New Features in 10.5.4
    - Support for Microsoft SQL Server 2022
- 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 for MySQL
- PowerExchange 10.5.4 - New Features and Changes for MySQL
  - Behavior Changes in 10.5.4
    - PowerExchange Replicates the CHAR type as VARCHAR
- 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 ODBC
- PowerExchange 10.5.4 - New Features and Changes for ODBC
  - Parameter and Option Changes in 10.5.4
    - PowerExchange Data Source Wizard
PowerExchange for Oracle
- PowerExchange 10.5.5 - New Features and Changes for Oracle
- PowerExchange 10.5.4 - New Features and Changes for Oracle
  - New Features in 10.5.4
    - Support for Oracle 21c on Additional Linux Platforms
- PowerExchange 10.5.3 - New Features and Changes for Oracle
  - New Features in 10.5.3
    - Support for Oracle 21c in Amazon RDS Environments
  - Parameter and Option Changes in 10.5.3
    - PowerExchange Express CDC for Oracle Configuration File
- PowerExchange 10.5.2 - New Features and Changes for Oracle
  - New Features in 10.5.2
  - Parameter and Option Changes in 10.5.2
    - PowerExchange Express CDC for Oracle Configuration File
- PowerExchange 10.5.1 - New Features and Changes for Oracle
  - New Features in 10.5.1
  - Parameter and Option Changes in 10.5.1
    - PowerExchange Express CDC for Oracle Configuration File
- 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 for PostgreSQL
- PowerExchange 10.5.5 - New Features and Changes for PostgreSQL
  - Parameter and Option Changes in 10.5.5
    - DBMOVER Configuration File
- PowerExchange 10.5.4 - New Features and Changes for PostgreSQL
  - New Features in 10.5.4
    - Support for PostgreSQL version 15
    - Additional Datatypes Supported for PostgreSQL CDC Sources
- PowerExchange 10.5.2 - New Features and Changes for PostgreSQL
- PowerExchange 10.5.1 - New Features and Changes for PostgreSQL
  - New Features in 10.5.1
    - Support for PostgreSQL 13.x
- 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 SAP HANA
- PowerExchange 10.5.5 - New Features and Changes for SAP HANA
  - Parameter and Option Changes in 10.5.5
    - DBMOVER Configuration File
    - Row Table option in 10.5.5
- PowerExchange 10.5.2 - New Features and Changes for SAP HANA
  - Behavior Changes in 10.5.2
- PowerExchange 10.5.1 - New Features and Changes for SAP HANA
  - New Features in 10.5.1
    - Support for SAP HANA CDC Sources
  - Parameter and Option Changes in 10.5.1
    - DBMOVER Configuration File
PowerExchange for VSAM and Flat Files
- PowerExchange 10.5.3 - New Features and Changes for VSAM and Flat Files
  - New Features in 10.5.3
    - Support for CICS Transaction Server Version 6.1
- 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

Release Guide

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
- 10.4.0

Back Next

DBMOVER Configuration File Statements

The DBMOVER configuration file contains the following new and changed parameters:

FILEMAPPED_MEMORY_DIR=path/directory: Changed
. Required for AIX and IBM i. On IBM i, the default is /tmp. When you install PowerExchange on IBM i and you select the
Configure PowerExchange DBMOVER file
check box, or you manually install PowerExchange on IBM i, the installer adds FILEMAPPED_MEMORY_DIR=/tmp to the DBMOVER configuration file.
FROMRCVR=library/from_receiver: New
. Optional. Specifies the beginning of a valid sequence of override journal receivers associated with the journal specified in the JOURNAL JRN parameter. If you specify this parameter, you must also specify the TORCVR parameter.
TORCVR=library/to_receiver: New
. Optional. Specifies the end of a valid sequence of journal receivers associated with the journal receiver specified in the JOURNAL JRN parameter.
IBMI_USE_DB2_SYSTEM_OBJECT_NAMES={Y| N }: New
. Optional. Controls whether PowerExchange searches both IBM i system object names and SQL object names or only SQL object names for Db2 for i source objects when you create PowerExchange capture registrations in the PowerExchange Navigator or with the DTLUCBRG utility or perform database row tests in the PowerExchange Navigator. Default is N, which reflects the previous behavior of searching SQL object names only.
JOB_START_MINIMUM_BELOWLINE_MEMORY_KB=kilobytes: New
. Optional. The minimum z/OS memory below the 16 MB line that must be present before the PowerExchange Listener on z/OS allows an incoming connection request to start a task.

JOURNAL=(JRN=library/journal_name, [FROMRCVR=library/from_receiver], [TORCVR=library/to_receiver]): Changed
. Required. Defines the name of the Db2 for i journal associated with the CAPI_CONNECTION instance for registrations. The JRN parameter specifies the library name and journal name and is required.

If you need to process changes from a range of journal receivers outside of default processing, you can optionally specify a range of journal receivers using the FROMRCVR and TORCVR parameters on the JOURNAL JRN parameter.
LRECL: Changed
. Optional. Specifies the logical record length that PowerExchange uses when dynamically allocating target data sets on z/OS, if you do not provide LRECL information For the record_length value, enter a number from 1 through 32756.
REPORT_UNUSED_OPT_READING_CONDITIONS={ Y |N}: New
. Optional. Controls whether PowerExchange records conditions in a SQL WHERE clause that are skipped by the NRDB optimized read process. Set this option to N to suppress messages about skipped conditions in the SQL WHERE clause.