IBM - Managing Workloads for DB2 LUW and InfoSphere Warehouse

PROKODA Gmbh
In München

1.390 
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0221/... Mehr ansehen

Wichtige informationen

  • Seminar
  • Anfänger
  • München
  • Dauer:
    2 Tage
Beschreibung

IBM - Managing Workloads for DB2 LUW and InfoSphere Warehouse: This intermediate course is for DB2 DBA responsible for implementing DB2 Workload Manager._x000D_. This course is designed to teach the DB2 DBA how to administer DB2 Workload Manager (WLM). Each of the components are covered. The course first covers how to use service classes to control resources and how to..
Gerichtet an: This intermediate course is for DB2 DBA responsible for implementing DB2 Workload Manager._x000D_. This course is designed to teach the DB2 DBA how to administer DB2 Workload Manager (WLM). 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...

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
München
Werner-Eckert-Str.11, 81829, Bayern, Deutschland
Plan ansehen

Häufig gestellte Fragen

· Voraussetzungen

Students should have a good foundation in DB2 system administration_x000D_

Themenkreis

KURSZIEL
IBM - Managing Workloads for DB2 LUW and InfoSphere Warehouse: This intermediate course is for DB2 DBA responsible for implementing DB2 Workload Manager._x000D_

_x000D_

This course is designed to teach the DB2 DBA how to administer DB2 Workload Manager (WLM). 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. _x000D_

_x000D_

Course Materials _x000D_

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

_x000D_

Hands-On Labs _x000D_

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

ZIELGRUPPE
This intermediate course is for DB2 DBA responsible for implementing DB2 Workload Manager._x000D_

_x000D_

This course is designed to teach the DB2 DBA how to administer DB2 Workload Manager (WLM). 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. _x000D_

_x000D_

Course Materials _x000D_

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

_x000D_

Hands-On Labs _x000D_

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

KURSINHALT
Kursziele
  • 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
Themenübersicht
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
Hinweise
Course material will be in English.


VORRAUSSETZUNG
Students should have a good foundation in DB2 system administration_x000D_


Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen