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.

DB2 9 for z/OS Application Performance and Tuning - Instructor Led Online  (3V960)

Format: Formation en classe avec formateur
Autres formats:
 
 

This course is designed to teach you how to prevent application performance problems and to improve the performance of existing applications.
 
This Course is Certified By IBM   Flex Training Savings
 

Compétences acquises
 
  • Design better indexes
  • Determine how to live with the optimizer (avoid pitfalls, help when necessary)
  • Avoid locking problems
  • Use accounting traces to find significant performance problems in an operational application
  • Describe access path stability

Qui peut en profiter
 

This is an intermediate course for DB2 for z/OS application developers, DB2 for z/OS DBAs and anyone else with a responsibility for application performance and tuning in a DB2 for z/OS environment.

Préalables
 

Familiarity with DB2 for z/OS application programming.

Abstract
 

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.

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: 3V960
Format: Formation en classe avec formateur
Durée: 5 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
 

DB2 9 for z/OS Application Performance and Tuning - Instructor Led Online  (3V960) Contenu détaillé
 
 
Application performance issues and management methods
  • Describe common DB2 application performance problems
  • Evaluate different approaches for detecting the problems
  • Describe different solutions
Towards better indexes
  • Detect inadequate indexing with VQUBE as soon as program specifications are completed
  • Design the best possible index for a single-table SELECT
  • Evaluate the cost of an index
Towards better tables
  • Evaluate clustering alternatives
  • Consider the tradeoffs in two kinds of denormalization
  • Describe why tables for optional attributes are often not good for performance
Learning to live with optimizer
  • Describe the limitations related to dangerous predicates
  • Identify situations when the optimizer needs help with filter factor estimates
  • Avoid the pitfalls with joins, subqueries, unions, except, and intersect
Unpredictable transactions
  • Design good cursors and indexes for a transaction with optional input fields
  • Describe the problems the index designer and the optimizer face with star joins
  • Describe MQTs and situations where they might improve application performance
Massive batch
  • Detect early the eventual performance problems with massive batch jobs
  • Make batch jobs run faster
CPU time estimates
  • Predict CPU time with a rough formula
Avoiding locking problems
  • Avoid lock durations that are too long or locks that are too strong
  • Prevent wrong results caused by lock durations that are too short or locks that are too weak
 
Monitoring application performance
  • Describe access path stability
  • Identify how traces work
  • Define what an accounting trace is
  • List the most important counters in an accounting trace
  • Compare VQUBE and accounting traces
  • Analyze an accounting trace
  • Describe the most useful accounting reports
 
Agenda
 
Day 1
  • Welcome
  • Application performance issues and management methods
  • DB2 index structure and basic access paths
  • Index design - part one
Day 2
  • Index design - part one (continued)
  • Lab 1 (Improve indexes for customer / order application)
  • Lab 1 review
  • Index design - part two
  • Machine exercise 1
  • Machine exercise 1 review
  • Index design - part two (continued)
  • Lab 2 (Poorly performing application already in production)
  • Lab 2 review
  • Advanced access paths
Day 3
  • Lab 3 (Multiple index access)
  • Lab 3 review
  • Towards better tables
  • Dangerous predicates
  • Machine exercise 2
  • Machine exercise 2 review
  • Dangerous predicates (continued)
  • Lab 4 (Browsing application)
  • Lab 4 review
  • Optimizer and filter factors
  • Machine exercise 3
  • Machine exercise 3 review
  • Join issues
Day 4
  • Join issues (continued)
  • Lab 5 (Joins)
  • Lab 5 review
  • Subquery issues
  • Lab 6 (Different implementations of the same transaction)
  • Lab 6 review
  • UNION, EXCEPT, and INTERSECT
  • Lab 7 (Union)
  • Lab 7 review
  • Machine exercise 4
  • Machine exercise 4 review
  • Unpredictable transactions and MQTs
  • Machine exercise 5
  • Machine exercise 5 review
  • Massive batch
  • Lab 8 (Improve batch performance)
Day 5
  • Lab 8 Review
  • Massive delete
  • CPU time estimates
  • Avoiding locking problems
  • Monitoring application performance


  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