Table of Contents

Search

  1. Preface
  2. Performance Tuning Overview
  3. Bottlenecks
  4. Optimizing the Target
  5. Optimizing the Source
  6. Optimizing Mappings
  7. Optimizing Transformations
  8. Optimizing Sessions
  9. Optimizing Grid Deployments
  10. Optimizing the PowerCenter Components
  11. Optimizing the System
  12. Using Pipeline Partitions
  13. Appendix A: Performance Counters

Performance Tuning Guide

Performance Tuning Guide

Buffer Memory

Buffer Memory

When the Integration Service initializes a session, it allocates blocks of memory to hold source and target data. The Integration Service allocates at least two blocks for each source and target partition. Sessions that use a large number of sources and targets might require additional memory blocks. If the Integration Service cannot allocate enough memory blocks to hold the data, it fails the session.
You can configure the amount of buffer memory, or you can configure the Integration Service to calculate buffer settings at run time.
To increase the number of available memory blocks, adjust the following session properties:
  • DTM Buffer Size.
    Increase the DTM buffer size on the Properties tab in the session properties.
  • Default Buffer Block Size.
    Decrease the buffer block size on the Config Object tab in the session properties.
If data partitioning is enabled, the DTM buffer size is the total size of all memory buffer pools allocated to all partitions. For a session that contains
n
partitions, set the DTM Buffer Size to at least
n
times the value for the session with one partition.