IBM KM530G - IBM InfoSphere DataStage Engine Administration for Information Server v11.7

Course Outline

Unit 1: Introduction to the Information Server (DataStage) engine

• Describe the Information Server (DataStage) engine
• Describe how the engine is used in Information Server
• Identify how the engine is invoked
• List the main features of the engine

Unit 2: Elements of a DataStage job

• Describe the components that make up a DataStage job
• Describe the OSH and explain how it corresponds to the GUI DataStage job design
• Run a DataStage job and view the job log

Unit 3: Engine architecture

• Define partition parallelism
• Describe the DataStage runtime process
• Explain the purpose of job configuration files
• List the elements of a job configuration file

Unit 4: Engine project configuration

• Create Data users
• Give credentials to DataStage users
• Specify project roles for DataStage users
• Configure a DataStage project in the DataStage Administrator client
• Specify environment variable settings

Unit 5: Configuring database connectivity

• Configure the engine to connect to databases using direct API connections
• Configure the engine to connect to databases using ODBC drivers

Unit 6: Running DataStage jobs

• Run job sequences 
• Run jobs from the command line
• Monitor the DataStage job log
• Use the DataStage and QualityStage Operations Console
• Manage the workload
• Stop and start the DataStage engine

Unit 7: Engine utilities

• Manage data sets
• Use the Multiple Job Compile utility

Unit 8: Importing and exporting DataStage objects

• Export and import DataStage objects in DataStage Designer
• Export and Import DataStage objects using the DSXImportService command

Objective

After completing this course, you should be able to:  

• Describe the components of a DataStage parallel job
• Describe the engine architecture and project configuration
• Describe the purpose and format of the DataStage configuration file
• Explain how to configure the engine using environment variables
• Demonstrate how to configure data source connections
• List several ways of running DataStage jobs
• Describe how to monitor DataStage jobs and the runtime environment
• Manage data sets and run the Multiple Job Compile utility
• Import and export DataStage jobs and other engine objects

Audience

This course is recommended for those who will be administering Information Server and DataStage.