PowerExchange Interfaces for PowerCenter

10.5.8
- 10.5.6
- 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

Connection Attributes for Multiple-Record Writes

When you create a connection for a source or target in a workflow that performs multiple-record writes, observe the following rules and guidelines:

You can use multiple-record writes with PWXPC connections only. Multiple-record writes with PowerExchange ODBC connections are not supported.

Select

Filter After

for the

Offload Processing

source and target connection attribute. PowerExchange and PWXPC perform offload processing on the Integration Service machine.

If you select a different value for

Offload Processing

, PowerExchange changes the value to

Filter After

However, if RBAs are being read using the GetDatabaseKey or GetIMSRBAByLevel function from an IMS unload file in the BMC LONG format, you must select

for the

Offload Processing

source connection attributes. Otherwise, the session will fail with message PWX-03803.

Multithreaded processing is supported for IMS source connections if you select

Filter After

for the

Offload Processing

connection attribute and set the

Worker Threads

connection attribute to a non-zero value.

Multithreaded mapping processing is not supported for IMS target connections. If you set the

Worker Threads

connection attribute to a non-zero value, the session ignores this setting.

Multithreaded processing is not supported for sequential or VSAM connections.

Multithreaded processing is not supported for sequential or VSAM source or target connections.

If you set the

Worker Threads

connection attribute to a nonzero value, the setting is ignored.

Select

Off

for the

Confirm Write

source and target connection properties. If you select a different value, PowerExchange changes the value to

Off

In certain cases, you might need to change the value of the

CSQ_MEMSIZE

parameter of the

PWX Override

connection property. This property defines the maximum amount of memory that the cache can consume for multiple-record writes.

Connections

Multiple-Record Writes to Nonrelational Targets

Considerations for Sessions that Perform Multiple-Record Writes

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Connection Attributes for Multiple-Record Writes

Connection Attributes for Multiple-Record Writes