IBM InfoSphere DataStage Engine Administration for Information Server v11.7

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

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

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