Follow Us :

CV96GB DB2 9 for z/OS Application Performance and Tuning

Course_Reference: 
CV96GB
Manufacturer: 
20
Training_Provider: 
0
Summary: 

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.

PreRequisites: 

Familiarity with DB2 application programming

Audience: 

  • DB2 for z/OS application developers
  • DB2 for z/OS DBAs

Objectives: 

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

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)

Description: 

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.

Keywords: 
DB2,z/OS Application Performance and Tuning,prevent application performance problems

Software Vendor

IT Technical

Business Skills