Installation and Upgrade Guide

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

Back Next

Connection Sharing for DB2 Lookups

PowerExchange 9.6.0 provides connection sharing for DB2 lookups. By default, all DB2 lookups in a workflow use the same connection, and the PowerExchange Listener performs them in a single task.

In PowerExchange releases earlier than 9.6.0, each DB2 lookup uses a separate connection. If you need to preserve this behavior in PowerExchange 9.6.0 or later, specify CONNSHARE=N in the PowerCenter PWX Override connection attribute.

If the DB2 connection is used as a target in a CDC workflow, do not change the default behavior. Otherwise, internal PowerCenter state tables that require connection sharing might not be updated correctly.

DB2 lookups that share a connection do not use offload processing, partitioning, or threading.

Upgrade Considerations for PowerExchange 9.6.0

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal