IBM DB2 für z/OS - IBM CV963G - IBM DB2 11 for z/OS Application Performance and Tuning

Standort:

Termin:

3.590,00 € *

zzgl. MwSt.

Preis inkl. gesetzlicher MwSt.: 4.272,10 €
IBM CV963G - IBM DB2 11 for z/OS Application Performance and Tuning This advanced course is for... mehr

IBM CV963G - IBM DB2 11 for z/OS Application Performance and Tuning

This advanced course is 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.
This course is designed to teach you on how to prevent application performance problems and to improve the performance of existing applications.
Hinweis: Dieses Seminar wird in Zusammenarbeit mit dem offiziellen Partner des IBM Global Training Providers Global Knowledge: Integrata AG oder dem IBM Education Delivery und IBM Sales Partner von Arrow ECS: Fast Lane Institute for Knowledge Transfer GmbH durchgeführt.

Inhalt

Introduction to Application Performance and Tuning:
Why Performance Disappoints, Causes of Performance Problems
SQL EXPLAIN Information, Modify the Index
The Accounting Trace, Accounting Trace Information
Filter Factors, Another Index Modification
Who Detects Problems?, When Should Problems be Detected?
VQUBE2, What is a Touch?
The Message
Performance Analysis Tools:
Components of Response Time, Methodology Formulas, VQUBE2
SQL EXPLAIN, The Plan Table
Running the Explain, Interpreting the Results
The Accounting Trace, Reading an Accounting Trace
The Bubble Chart, Monitoring Execution
Performance Thresholds, Tuning Potential
Towards Better Indexes:
DB2 Index Structure and Usage, Tuning Methodology and Index Cost
Customer Order Application, Index Design
Poorly Performing Application, Advanced Access Paths
Multiple Table Access:
Joining Issues, Joining Tables
Subqueries and Global Query Optimization
Union, Except, and Intersect
Towards Better Tables:
Table Design, Materialized Query Tables
Temporal Tables
Learning to Live with the Optimizer:
Dangerous Predicates
NonIndexable and NonBoolean Predicates **
Introduction to Browsing, Filter Factors
Helping the Optimizer
Massive Batch:
Batch Performance Issues, Benefit Analysis, Massive Delete
Locking Issues:
Serialization, Transation Locking, Application Design

Voraussetzungen

You should have: Familiarity with DB2 for z/OS application programming.

Zielgruppe

This advanced course is 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.

Zielsetzung

This course is designed to teach you on how to prevent application performance problems and to improve the performance of existing applications.