Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Connection Pooling

Connection Pooling

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.

0 COMMENTS

We’d like to hear from you!