Managing Workloads for DB2 LUW and InfoSphere Warehouse

start > courses and registration > training feature sheet

Managing Workloads for DB2 LUW and InfoSphere Warehouse

course schedule			who can benefit
prerequisites			skills gained
other notes			course content
related solutions

code.

DW321

length.

2 days

type.

Instructor-Led

partner.

IBM

price.

$1,300

Skill level: Intermediate

This course is designed to teach the DB2 DBA how to administer DB2 Workload Manager. Each of the components are covered. The course first covers how to use service classes to control resources and how to use DB2 workloads to group DB2 work activities and assign the workloads to service classes. Next we discuss thresholds and how they can be applied to service classes, workloads or the database. Then the course presents how work classes are used to differentiate the types of work activities, that is, DML, DDL, stored procedures and utilities, and work actions are used to apply thresholds to the work classes. The monitoring component is shown how it plays a critical role in performance tuning and problem determination. The course finishes with a unit on best practices for using DB2 WLM.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

This intermediate course is for those responsible for implementing DB2 Workload Manager.

prerequisites

You should have:

A good foundation in DB2 system administration.

skills gained

After completing this course, you should be able to:

	Describe how DB2 Workload Manager and Query Patroller can coexist
	Describe the use of DB2 service classes
	Explain how thresholds are used to control DB2 work activities
	Describe how to group DB2 work activities into workloads
	Define a work class and a work action
	Create event monitors using by DB2 Workload Manager

course materials

The course materials address the Workload Manager feature available as part of InfoSphere Warehouse 9.5 or as part of the DB2 Performance Optimization Feature.

hands-on labs

Lab exercises will be provided to give you experience working with Workload Manager.

ibm education advantage program eligibility:

Yes - IBM Education Pack - online account

course content details

	Introduction to DB2 Workload Manager

	Explain the need for DB2 Workload Manager
	Describe DB2 Workload Manager
	List the components of DB2 Workload Manager
	Explain how DB2 Workload Manager and Query Patroller can coexist
	Explain how to use perspectives in the Design Studio
	List the components of the Business Intelligence perspective

	Service Classes

	Describe the use of DB2 service classes
	Differentiate between default services classes and user defined service classes
	List the service class features
	List the requirements when altering a DB2 service class
	Describe the restrictions when dropping a DB2 service class
	Define the use of the Outbound Correlator parameter
	List the main considerations when integrating DB2 service classes with AIX's Workload Manager

	DB2 WLM workloads

	Describe how DB2 WLM workloads are used by Workload Manager
	List the DB2 WLM workload connection attributes
	Describe how DB2 WLM workload evaluation takes place
	Differentiate between the two default DB2 WLM workloads
	Define DB2 WLM workload usage privilege
	List the administrative restrictions for DB2 WLM workloads

	Thresholds

	Describe how thresholds are used in DB2 WLM
	Define the use of a threshold boundary
	Explain the difference between activity and aggregate thresholds
	List the activity and aggregate thresholds

	Work Classes and Work Actions

	Define a work class
	Describe how to classify work activities using a work class
	Define a work class set
	List the work class database activity attributes
	Define a work action
	Describe how work actions link work classes to either the database or to service classes
	Define a work class set
	List some of the work action limitations

	Monitoring and Control

	Create event monitors for Workload Manager
	Describe table functions that can be used to obtain operational information
	List the Workload Manager stored procedures
	Describe the statistics table functions
	Explain how histogram templates can be used with service and work classes

	Best Practices

	List the steps necessary to create a successful DB2 Workload Manager configuration
	Define goals that are easy to translate into DB2 Workload Manager controls
	Explain when work class are viable

	Agenda - Day 1

	Welcome
	Unit 1 - Introduction to DB2 Workload Manager
	Exercise 1 - Basic Monitoring
	Unit 2 - Service Classes
	Unit 3 - Workloads
	Exercise 2 - Isolating Activities
	Unit 4 - Thresholds
	Exercise 3 - Using Threshold
	Unit 5 - Work Classes and Work Actions

	Day 2

	Unit 5 - Work Classes and Work Actions - continued
	Exercise 4 - Differentiating Activities by Activity Type
	Unit 6 - Monitoring and Control
	Exercise 5 - Monitoring
	Unit 7 - Best Practices
	Exercise 6 - Additional Monitoring and Historical Analysis