This article describes how to create an ODBC data source that is required to run a Stored Procedure transformation for a DB2 for z/OS stored procedure in a PowerCenter mapping. It applies to PowerExchange 10.0 and later.

This article describes how to create a PowerExchange capture registration and extraction map for an Oracle data source from the PowerExchange Navigator. It also describes how to import the extraction map into PowerCenter to create a source definition that can be included in a PowerCenter mapping for a CDC session.

This article describes how to define table properties in a data map to normalize a field defined as an array with multiple occurrences.

When you enable PowerExchange data maps caching, PowerExchange retrieves data maps from job-level memory rather than by accessing the data maps file, which improves performance. This article shows how to enable and configure PowerExchange data maps caching.

This article shows how to enter the Adabas FDT password when you connect to an Adabas source or target during a PowerCenter batch, Change, or Real-time mode session or run a CAPXRT database row test for an Adabas extraction map.

This article describes how to implement PowerExchange 10.4.0 Express CDC for Oracle in a non-RAC Oracle environment on UNIX. It identifies the configuration steps that you perform in Oracle, PowerExchange, and PowerCenter to create a working change data capture (CDC) environment. It also includes example configuration files, tips, and best practices.

In the PowerExchange Navigator, the term copybook refers generically to data definitions for records, segments, fields, keys, and other items from a data source that you import into a data map, or into records or segments in a data map, to define the layout of the data. This article shows how to import a COBOL or PL/I copybook into a data …

This article describes how to import PowerExchange data maps into the Developer tool as nonrelational data objects. You can then use the tables that the nonrelational data object contains in mappings, mapplets, and profiles.

You can use a decompressed Adabas unload file as a data source in a PowerExchange bulk data movement session. This article describes how to create a decompressed Adabas unload file, create a data map for it, and create a bulk data movement session to materialize a target from the data source.

To capture Oracle change data, you can migrate from the PowerExchange Oracle CDC with LogMiner solution to the PowerExchange Express CDC for Oracle solution. PowerExchange Express CDC captures Oracle change records faster and more efficiently in environments that meet its requirements and restrictions. This article describes how to …

You can define a DB2 for z/OS data source as a nonrelational data source in a PowerExchange bulk data movement session. This article describes the types of DB2 data sources that you define as nonrelational and explains how to create a data map for the data source and create a bulk data movement session to materialize a target from the data source.

You can create a PowerCenter workflow that remotely overrides the IMS database name that is input to a bulk data movement session. This article describes how to create the JCL, UNIX scripts and data files, PowerExchange data maps, and PowerCenter mappings, tasks, and workflow to accomplish this task.

This article describes the proper procedure for changing data sources or targets for existing PowerExchange Change Data Capture (CDC) sessions that use PowerExchange Client for PowerCenter (PWXPC).

PowerExchange supports code pages for internationalization. This article discusses various aspects of PowerExchange code page processing.

This article descibes key considerations for PowerExchange use of the Delete Journal Receiver exit program for DB2 for i5/OS change data capture (CDC). PowerExchanges uses this exit program to prevent the deletion of journal receivers while CDC sessions read change data from them.

PowerExchange requires IMS data maps for bulk data movement and change data capture (CDC) from IMS sources on z/OS. This article describes how to create an IMS data map that uses the DL/I access method in the PowerExchange Navigator client on Windows.

Data in flat files must be mapped to a datatype before it can be retired. You can use PowerExchange to create data maps that specify the datatypes for data in flat files. After you create a data map, you can validate and correct the data before you retire it.

You can use the DTLREXE utility on a Linux, UNIX, or Windows system to run the EDMLUCTR Log Print utility on a remote z/OS source system. This article describes how to use this feature to get information about PowerExchange change capture for a z/OS source when you do not have access to the z/OS system.

This article describes how to configure Informatica® Metadata Manager and PowerExchange® to retrieve metadata from a DB2 for z/OS system.

You can use PowerExchange, PowerCenter, and Persistent Data Masking and Data Subset to perform data masking and data subset with sequential or VSAM sources on z/OS. This article describes the procedures for installing and configuring PowerExchange and performing data masking and data subset with these sources.

This article describes how to use PowerExchange messages that report IMS change capture counts to monitor IMS log-based ECCR change capture activity.

This article describes how to use the PowerExchange xEDP-STAT and xEDP-STATWTO external subsystem commands to monitor PowerExchange change capture activity for IMS synchronous CDC.

This article describes error handling options for PowerCenter sessions that use a PowerExchange batch or relational connection to write data across a network to PowerExchange relational or nonrelational targets. It also describes the types of errors that might occur.

When you shut down a PowerExchange log-based ECCR on z/OS, it might report that an active UOW exists. Usually, the ECCR can handle this situation. However, if the UOW remains active in the PowerExchange Logger for MVS UOW connection, you need to take action. This article describes how to identify and handle inflight UOWs so that you can …

You can use a PowerExchange event table to stop the extraction of change data at a specific point in the real-time change data stream or the PowerExchange Logger or PowerExchange Condense files. This feature is useful if you need to stop CDC sessions before or after running routine batch jobs or before performing maintenance.