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. Performance Counters

Performance Tuning Guide

Performance Tuning Guide

Configuring Sessions to Distribute Files

Configuring Sessions to Distribute Files

You can manually configure sessions to distribute the file load. You might need to edit sessions when the load changes significantly or when you add new sessions or file systems, including adding new nodes to a grid with a cross-mounted shared file system.
Instead of editing sessions manually, use session variables to distribute files to different directories. This allows you to redirect session files to different file servers when necessary.
Use the following guidelines to use session variables:
  • Name variables for session file names and directories to reflect business logic.
  • In the parameter file, define each variable so the file load is evenly distributed across all available file systems. You can also define node-specific variables.
  • Optionally, automate reconfiguration with a script to process parameter files.
    When you use a script, use a placeholder in the parameter file so the script can redefine session variables as necessary.