Connection pooling is a method of reusing cached connection information and eliminating overhead in opening network connections and creating new tasks.
When connection pooling is enabled, PowerExchange maintains a pool of PowerExchange Listener connections. It does not keep files or databases open for the pooled connections.
The following clients support connection pooling:
Data Integration Service. Define connection pooling properties for the Data Integration Service by using the Informatica Administrator. Before you enable connection pooling, verify that the value of the MASTASKS statement in the DBMOVER file on the PowerExchange Listener system is large enough to accommodate the maximum number of connections in the pool for the Listener task. For more information, see the
Informatica Administrator Guide
.
PowerExchange Navigator. Configure connection pooling for the PowerExchange Navigator by defining connection pooling properties in the
Preferences
dialog box. For more information, see the
PowerExchange Navigator User Guide
.
DTLUCBRG utility. DTLUCBRG automatically enables connection pooling with a connection pool size of six connections and a retention period of 30 seconds. You cannot change these values.
DTLURDMO utility. DTLURDMO automatically enables connection pooling with a connection pool size of two connections and a retention period of 30 seconds. You cannot change these values.
PowerExchange Agent on z/OS. The PowerExchange Agent uses connection pooling automatically in certain cases. You cannot configure connection pooling for the PowerExchange Agent.
PowerCenter Integration Service. The PowerCenter Integration Service uses connection pooling automatically in certain cases. You cannot configure connection pooling for the PowerCenter Integration Service.
Informatica Developer tool. The Developer tool uses connection pooling automatically in certain cases. You cannot configure connection pooling for the Developer tool.