Preface
Summary of PowerExchange New Features and Changes
- About This Summary
- 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 10.2 HotFix 2
- PowerExchange 10.2 HotFix 1
- PowerExchange 10.2
PowerExchange Installation and Upgrade
- 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 Agent
- PowerExchange 10.2 HotFix 2 - New Features and Changes for the PowerExchange Agent
  - 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 Agent
  - Parameter and Option Changes in 10.2 HotFix 1
    - IAUPABND Option in the EDMSDIR Module
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
- 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
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 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 Listener
- 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 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 Logger for Linux, UNIX, and Windows
- 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 10.2 HotFix 2 - New Features and Changes for the PowerExchange Logger
  - 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 Navigator
- 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 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 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 Utilities
- 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 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 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 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.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 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 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 for DB2 for z/OS
- 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 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 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.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 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 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 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.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 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 for PostgreSQL
- 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.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 - 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 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.2
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Oracle LOB Support

For Oracle source tables, PowerExchange can process change data from BLOB, CLOB, and NCLOB columns. The maximum row size that PowerExchange can process is 8 MB.

For tables with BLOB or CLOB datatypes that are defined with the Oracle attribute ENABLE STORAGE IN ROW, PowerExchange delivers up to 3964 bytes of the data to PowerCenter workflows that use a PowerExchange CDC Oracle connection. In Oracle, when the ENABLE STORAGE IN ROW attribute is enabled, LOB data can be stored either fully inline in the row or out-of-line in the LOB file space. Oracle does not store partial LOB data in a row.

You can use the PowerExchange-generated DTL__ST_lob_columnname column with a PowerCenter Expression transformation and unconnected Lookup transformation to retrieve all of the LOB data from BLOB and CLOB columns. The session can then send all of the LOB data to a target.

Oracle has a maximum column size of 4000 bytes. For LOBs stored in-row, the column contains a 20-byte LOB locator, a 16-byte LOB node, and data, for a maximum of 3694 bytes. For CLOB data, this data is stored using a double-byte character set, even if the column character set is single byte, which reduces the maximum size to 1847 characters.

For more information, see the "Express CDC for Oracle" chapter in the

PowerExchange CDC Guide for Linux, Unix, and Windows

New Features in 10.5.1

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal