Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.
|
This course is designed to teach you how to prevent application performance problems and to improve the performance of existing applications. - CV96 was previously known as CF96. CV96 is an updated and enhanced version of CF96.
- Whilst CV96 is written for a DB2 9 for z/OS audience, it is also suitable for students working with an earlier release of DB2 for z/OS.
-
Audience - DB2 for z/OS application developers
- DB2 for z/OS DBAs Prerequisites Familiarity with DB2 application programming Skills Gained After completing this course, you should be able to: - 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
Course Outline Overview of application performance issues and performance management methods Towards better indexes - From data model to database version 0
- Detecting inadequate indexing with VQUBE
- Three-star index: deriving the best possible index for a SELECT
- Estimating the cost of an index
-
- Restrictions and limitations
- Towards better tables
- Clustering
-
- Denormalization
- Learning to live with the optimizer
- Predicting index matching and screening
- Indexable predicates
- Boolean term predicates
- REOPT(ALWAYS) and the alternatives
- Joins
- Subqueries
-
- Union, Except, Intersect
- Unpredictable transactions
- Unpredictable predicates
- Many criteria, few provided
- Star join
-
- Materialized query tables (MQTs)
- Massive batch
- Random disk I/O
- Estimating and minimizing disk I/O time
- Manual and automatic parallelism
-
- Massive deletes
- CPU time estimates
-
- Worksheet for rough CPU time estimates
- Preventing long lock waits
- Lock life cycle
-
- Recommendations
- Tuning operational applications
- Analyzing slow transactions with accounting traces
- Detecting inadequate indexing
- Detecting optimizer problems
- Detecting long lock waits
-
- Detecting tables which should be denormalized
- Optimizer Service Center (OSC) and Optimizer Expert (OE)
Practical Work - 8 real-world, desk-checking exercises using the VQUBE (Very Quick Upper Bound Estimate) technique
- 5 hands-on machine exercises using DB2 9 for z/OS
How to make a booking for the CV96GB course
|
