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

Performance Tuning Guide

Performance Tuning Guide

Optimizing PowerCenter Repository Performance

Optimizing PowerCenter Repository Performance

Complete the following tasks to improve PowerCenter repository performance:
  • Ensure the PowerCenter repository is on the same machine as the Repository Service process.
  • Order conditions in object queries.
  • Use a single-node tablespace for the PowerCenter repository if you install it on a DB2 database.
  • Optimize the database schema for the PowerCenter repository if you install it on a DB2 or Microsoft SQL Server database.