Ray Wurlod

P.O. Box 1214

ABN 57 092 448 518

North Sydney  N.S.W.  2060

Education and Consulting Services

Australia

 

Email: rayw@mindless.com

 

 

Advanced Parallel Job Techniques

 

This page outlines the elements of the DataStage® Advanced Parallel Job Techniques class, one of the services offered by this business.

It is an instructor-led class that can be delivered on-site (in a training room equipped with one PC per student and connectivity to a DataStage server).

 

Duration

 

Variable (see below)

 

 

Prerequisite

 

Prior to attending this class the student must have attended either IBM's DataStage Essentials (Enterprise Edition) class (code DX434) or the Ray Wurlod DataStage Fundamentals (EE) class.

An assessment of preparedness may be required to be completed.

 

 

Objectives

 

Having completed this class the student will be able, if the appropriate modules have been selected:

•        to configure partitioning, sorting and buffering optimally

•        to make use of inbuilt reporting and troubleshooting tools

•        to create jobs that work with vectors and subrecord types

•        to implement change detection and surrogate key management

•        to employ parallelism in Enterprise stage types

 

 

Contents

 

The course can be constructed from the following modules.  The first four must be included, and require one day.  The others, if taken, must be taken in the order specified and require one half-day each.  All thirteen modules can be delivered in five teaching days.

  1. Review of the parallel execution framework (architecture)
  2. Partitioning and collecting techniques
  3. Sorting techniques
  4. Buffering
  5. Managing resource allocation and performance tuning
  6. DB2 Enterprise stage
  7. Oracle Enterprise stage
  8. Teradata stages
  9. Monitoring: the OSH and the Score
  10. Vectors and Subrecords and handling structured and raw data
  11. Change detection techniques (vectors and subrecords module must also be selected)
  12. Surrogate key management in a parallel environment
  13. Troubleshooting and debugging

 

The three database stage modules require connectivity to the appropriate database type to have been installed, configured and tested successfully.

 

 

Courseware

 

Each student receives the following two documents.

•        Student notes: Powerpoint presentation with detailed notes pages.

•        Lab Exercises:  Detailed instructions for "hands on" exercises to reinforce learning

 

 

DataStage is a registered trademark of International Business Machines Corporation.

IBM, the IBM logo and WebSphere are registered trademarks of International Business Machines Corporation.

 

This page is copyright © 2006, Ray Wurlod. All rights reserved.