• Select a country/region: United States
  • IBM®
  • Site map

  • Training - worldwide
  • Training
  • Course catalog

Course description: Advanced DataStage - Web-Based

  • Add course to my custom catalog
  • Add to my training plan

Overview

  • Special note
  • Audience
  • Prerequisites
  • Skills taught
  • Course outline
  • Machine requirements
List of course details in a data table
Course code 1I445 Skill level Advanced
Duration 32.0 hours Delivery type Web Based Training
Course type Public only    
Public price USD $1,360.00 plus tax    

This course is designed for DataStage developers who have achieved a basic level of skill with the product. It is designed to deepen their knowledge of DataStage by discussing the underlying parallel job framework and by introducing more complex DataStage parallel job designs.

Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course.

For developers of DataStage Enterprise Edition V8, deepen your knowledge by discussing the underlying parallel job framework and by introducing more complex DataStage parallel job designs. Topics include the parallel architecture, compilation and execution, partitioning and collecting, sorting, buffering, parallel data types, database usage, stage and job design practices, and performance. This is a self-paced online course. You will receive detailed access instructions in an email confirming your registration. Once you receive your access information, you will have 60 days to complete this course.

The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.

View this course in other countries

Back to top

Special note

IBM Education Advantage Program eligibility:

  • Yes - IBM Education Pack - Online Account

Back to top

Audience

This advanced course is for DataStage V8.1 developers who have achieved a basic level of skill with the product. It is designed to deepen their knowledge of DataStage beyond the basic level. We recommend six months experience using DataStage.

Back to top

Prerequisites

You should have:

  • DataStage Essentials V8.1 course
  • Six months experience using DataStage

Back to top

Skills taught

  • Develop an understanding of the framework development and runtime architecture
  • Explain metadata in the framework
  • Create jobs using advanced design techniques
  • Design jobs using techniques for good performance and resource usage
  • Extend the functionality of DataStage with Build stages, Wrapped stages, and external functions
  • Choose the appropriate partitioning and collecting algorithms to satisfy business, performance, and resource usage requirements
  • Describe the difference between database stages
  • Read the score to determine what's happening at runtime
  • Explain configuration files
  • Describe how buffering works in parallel jobs

Back to top

Course outline

  • Introduction to the Parallel Architecture
  • Compilation and Execution
  • Debugging and testing
  • Partitioning data
  • Collecting and sorting
  • Buffering in Parallel jobs
  • Parallel Data Types
  • Extending Parallel Jobs, using Wrapped stages, Build stages, and external functions
  • Database usage
  • Stage and job design guidelines
  • Performance tuning

Back to top

Machine requirements

HW/SW CONFIGURATION

The minimum hardware and software required to launch the course are:

  • Reliable HIGH-SPEED INTERNET connection (min 200 kbps up and down)
  • Windows 2000 or XP or Vista
  • Computer with soundcard
  • Headset or computer speakers
  • Internet Explorer 5.01 or later, or Firefox 1.0 or later

Network Speed Test

http://clpext.moppssc.com/index.php?option=com_wrapper&view=wrapper&Itemid=8

User: clp

Pass: ibmeduc

For example, a speed test against the server with a slow connection of 140 Kbps download and 28 Kbps upload took 14 minutes to load a 30min recording before the video began. Extrapolate from this result to estimate approximately how fast your network internet access would be. High-speed broadband internet access is the recommended configuration for this course.

Keyboard Configuration

If you use a different character keyboard, you may experience errors when entering passwords. If possible, change your language/country settings for your keyboard to USA, which allows you to enter characters as in a QWERTY keyboard.

Back to top

My IBM

  • Edit your profile

We're here to help

Easy ways to get the answers you need.

  • or call us at
    Call 1-800-426-8322
    Open M-F 9AM-7PM ET.

Find the right course

  • Training paths will help you decide

Offers and more

  • Subscribe to IBM Training News
  • Training special offers
  • IBM Education Pack

    Save on Training

  • Request a complimentary IBM Training Plan
  • Training with no travel required

Student center

  • My enrollments
  • My training wish list

  • How to get to class