ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Managing Workloads for DB2 LUW and InfoSphere Warehouse - Instructor Led Online  (3W322)

Format: Formation en classe avec formateur
Autres formats:
 
 

This replaces course 3W321. This is the Instructor Led Online version of Classroom course (DW322); also see the Flex ILO 3N322

This is an online course. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.

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.

Course Materials

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.

Hands-On Labs

Lab exercises will be provided to give you experience working with Workload Manager.
 
This Course is Certified By IBM   Flex Training Savings
 

Compétences acquises
 

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

Qui peut en profiter
 

This intermediate course is for:

  • DB2 DBA responsible for implementing DB2 Workload Manager.
  • This course is also appropriate for customers who have acquired the IBM Smart Analytics System

Préalables
 

Students should have a good foundation in DB2 system administration.

Abstract
 

IBM Education Advantage Program eligibility:

  • Yes - IBM Education Pack - online account
 
Enroll For This Class
Enroll For This Class
DB2 Lotus Tivoli Training Class Ce cours est donné par des formateurs certifiés IBM.

À titre de partenaire en formation agréée , ExitCertified peut vous inscrire à n’importe quel cours en Amérique du Nord.

Il y a une différence. Découvrez-la
Training Class Enrollment Ask A Question About This Training
Code: 3W322
Format: Formation en classe avec formateur
Durée: 2 days
Certifié par: IBM
Frais d’inscription (CAD): $contact
TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011
Recherchez des cours semblables
Cours connexes

Trier l'horaire par: 
No Course Dates Ce cours n'est pas prévu à l'horaire pour l'instant. Si vous êtes intéressé à suivre ce cours, utilisez le lien ci-dessous pour demander une date.
   
demander la date/l’emplacement demander de la formation sur place
 

Managing Workloads for DB2 LUW and InfoSphere Warehouse - Instructor Led Online  (3W322) Contenu détaillé
 
 
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


  ExitCertified is your Authorized IT Training Partner  
  Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

Il y a une différence. Apprenez directement de la source.		  
Training Contacts  
   
Canada United States

Formation à Montréal :: 514.876.1666
Formation à Ville de Québec :: 514.876.1666
Formation à Ottawa :: 613.232.3948
Formation à Toronto :: 416.487.3948

Formation à Vancouver :: 604.633.3948
Formation à Victoria :: 1.866.328.3948
Formation à Calgary :: 403.291.2855
Formation à Edmonton :: 780.441.3948
Formation à Regina :: 1.866.328.3948

 Formation à Sacramento :: 916.669.3970
Formation à San Francisco :: 415.975.3948
Formation à San Jose :: 408.288.3948
Formation à Las Vegas :: 1.800.803.3948
Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948 Des questions?
Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
   



(c) 2012 ExitCertified Corp. Tous droits réservés.


ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
 
Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
         
Formation MySQL Formation Apple Formation en gestion de projet    
Base de données MySQL Cours Apple, Formation Leopard Formation du PMI