£575.00

Price for this course

1 HOURS

Duration

Classroom IBM

Delivery

Available dates


Mon01Mar 21 TO Mon01Mar 21

Where

Tech Data ILO UK
Connection details will be communicated separately
Instructor Led
Online

Code

TR-664722
Tue01Jun 21 TO Tue01Jun 21

Where

Tech Data ILO UK
Connection details will be communicated separately
Instructor Led
Online

Code

TR-664723

Overview

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.

Audience

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

Prerequisites

It is recommend that students take KM510 “IBM InfoSphere Administrative Tasks for Information Server v11.5” course.

Objective

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

Course 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



FAQs

What do I need to bring with me to my public class?

All required learning materials and equipment are provided in the classroom.

 

 

 

 

When do public training course fees have to be paid?

For public training classes payment must be received no later than three business days prior to the first day of class in order to remain in the class and confirm your seat. Failure to provide payment by this date may result in removal from the class, and/or late cancellation fees applied. You can submit payment in the form of a Purchase Order or credit card.

 

 

 

 

On-site (private) Course Pricing:

To find out more about On-site training e-mail us at enablement@agilesolutions.co.uk or call one of our offices.

 

 

 

 

What is the cancellation policy?

Requests for cancellations or date transfers need to be received at least ten (10) business days prior to the event start date in order to receive a full refund. If a cancellation or reschedule request is received less than ten (10) business days before the start date, the penalty of 100% of the cost of the course will be applied, resulting in no amount of the fee being refunded. Refunds will not be allowed for “no-shows” in our public training or IVA courses. This cancellation policy is strictly enforced.

 

 

 

 

What happens if Agile Solutions needs to cancel or reschedule a course?

Agile Solutions reserves the right to cancel events for any reason at any time. Cancellation liability for Agile Solutions, if Agile Solutions cancels the course, is limited to the return of course payment ONLY. Agile Solutions will not reimburse registrants for any other costs including but not limited to any travel cancellation fees or penalties, including airfare and hotel costs. PLEASE NOTE: If your registration status is either “Approved”, or “Pending Payment” you have not been confirmed for the class and it is recommended that you do not make any travel arrangements until you have received a confirmation e-mail letting you know the class and registration is confirmed.

 

 

 

 

How will I know if my course has been rescheduled?

Agile Solutions reserves the right to reschedule or cancel a course due to low enrollment or if necessitated by other circumstances. Agile Solutions will contact you via e-mail or phone to inform you of the change of schedule. Once you have been notified you may reschedule or receive a full credit. Agile Solutions shall not be liable for any other costs including but not limited to any non-refundable travel arrangements if a course is rescheduled or cancelled.