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

Local Storage Files

Local Storage Files

To avoid unnecessary file sharing when you use shared file systems, store the following files locally:
  • Non-persistent cache files for sessions that are not enabled for a grid, including Sorter transformation temporary files.
  • Individual target files for different partitions when performing a sequential merge for partitioned sessions.
  • Other temporary files that are deleted at the end of a session run. In general, to establish this, configure $PmTempFileDir for a local file system.
Avoid storing these files on a shared file system, even when the bandwidth is high.