ExistBI certified IBM InfoSphere trainers deliver class based, custom and virtual training services to meet the needs of your organization. We are trusted IBM partners and regularly deliver corporate training, consulting and support services in the US, Canada, UK and Europe. We provide the certified instructor, licensed environment, materials and hands-on labs.

This 3-day course (Code: KM402G) is designed to introduce advanced parallel job development techniques in DataStage V9.1. In this course you will develop a deeper understanding of the DataStage architecture, including a deeper understanding of the DataStage development and runtime environments. This will enable you to design parallel jobs that are robust, less subject to errors, reusable, and optimized for better performance.

Course Duration

  • Four-days of instructor led training
  • 60% lecture, 40% hands-on

Target Audience

  • This advanced course is for experienced DataStage developers seeking training in more advanced DataStage job techniques and who seek an understanding of the parallel framework architecture.



  • Describe the parallel processing architecture
  • Describe pipeline and partition parallelism
  • Describe the role and elements of the DataStage configuration file
  • Describe the compile process and how it is represented in the OSH
  • Describe the runtime job execution process and how it is depicted in the Score
  • Describe how data partitioning and collecting works in the parallel framework
  • List and select partitioning and collecting algorithms
  • Describe sorting in the parallel framework
  • Describe optimization techniques for sorting
  • Describe sort key and partitioner key logic in the parallel framework
  • Describe buffering in the parallel framework
  • Describe optimization techniques for buffering
  • Describe and work with parallel framework data types and elements, including virtual data sets and schemas
  • Describe the function and use of Runtime Column Propagation (RCP) in DataStage parallel jobs
  • Create reusable job components using shared containers
  • Describe the function and use of Balanced Optimization
  • Optimize DataStage parallel jobs using Balanced Optimization


  • Module 1: Introduction to the Parallel Framework Architecture
  • Module 2: Compilation and Execution
  • Module 3: Partitioning and Collecting Data
  • Module 4: Sorting Data
  • Module 5: Buffering in Parallel Jobs
  • Module 6: Parallel Framework Data Types
  • Module 7: Reusable components
  • Module 8: Balanced Optimization
Print Friendly, PDF & Email