Overview
These courses are being delivered by an IBM Global Training Provider
This course teaches Information Server and/or DataStage administrators to configure, manage, and monitor the DataStage Engine which plays a crucial role in Information Server. It not only runs high performance parallel ETL jobs designed and built in DataStage. It also supports other Information Server products including Information Analyzer, QualityStage, and Data Click. After introducing DataStage parallel jobs and the Engine that runs them, the course describes DataStage project configuration, the Engine’s development and runtime environments, and the Engine’s data source connectivity. In addition the course explains how to import and export DataStage objects, how to run and monitor DataStage jobs through the command line and GUI, and how to use some important Engine utilities.
Prerequisites
It is recommend that students take KM510 “IBM InfoSphere Administrative Tasks for Information Server v11.5” course.
Delegates will learn how to
After completing this course, you should be able to:
- Describe how the DataStage Engine is used within Information Server
- Describe how the engine achieves high performance through partition parallelism
- Describe the DataStage job compilation process
- Describe the engine runtime process and environment
- Describe the purpose and format of the DataStage configuration file
- Describe how to configure the engine using environment variables
- Describe how to configure data source connections
- Describe the ways of running DataStage jobs
- Describe how to monitor DataStage jobs and the runtime environment
- Describe engine workload management
- Import and export DataStage jobs and other engine objects
Outline
Unit 1: Introduction to the Information Server (DataStage) engine
• Information Server architecture
• How the DataStage Engine is used in Information Server
• DataStage Engine features
Unit 2: Elements of a DataStage job
• Anatomy of a DataStage parallel job
• Explore the elements of an example DataStage job, including its stages and job parameters
• Understand the OSH that is generated by the job during compile
Unit 3: Engine architecture
• Partition parallelism
• Runtime architecture
• Configuration files
• The “Score”
Unit 4: Engine project configuration
• DataStage project authorizations
• Runtime Column Propagation (RCP)
• Environment variables
Unit 5: Configuring database connectivity
• Configuring ODBC data sources
• Configuring native database connections
Unit 6: Running DataStage jobs
• Running jobs from the command line
• Monitoring jobs in Director and the Operations Console
• Workload management
• Starting and stopping the Engine
Unit 7: Engine utilities
• Data set utilities
• Multiple job compile
• Resource estimation tool
Unit 8: Importing and exporting DataStage objects
• DataStage Designer exports and imports
• Command line exports and imports
Frequently asked questions
See all of our FAQsHow can I create an account on myQA.com?
There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.
If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".
If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.
Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.
How do QA’s virtual classroom courses work?
Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.
We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting (more details in the link below) to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.
Learn more about our Virtual Classrooms.
How do QA’s online courses work?
QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course. When you book a QA online learning course you will receive immediate access to it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.
All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.
Learn more about QA’s online courses.
When will I receive my joining instructions?
Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.
When will I receive my certificate?
Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.