- Home
- Catalog
- Courses
- Database Curriculum
- Optimize DB2 Application Performance
Optimize DB2 Application Performance
Duration
2 to 3 hours
Overview
Audience
Programmers and DBAs requiring training in managing and accessing DB2 databases, particularly the use of SQL
Prerequisites
Basic knowledge of DB2, relational databases, and SQL
Objectives
After completing this course, the student will be able to:
• Identify some of the performance issues encountered with DB2
• Recognize the DB2 tools that are used to tune performance
Course Content
DB2 Lock Types and Performance
DB2 Locking and Concurrency
DB2 Performance Issues Associated With Locking and Concurrency
DB2 EXPLAIN Facility
The Concepts of DB2 Explain
The Concepts of the Plan Table
DB2 Access Paths
DB2 Access Paths and the Effect of Different Database Structures and Joins
Performance Management: Components and Facilities
DB2 Performance Management
The DB2 Optimizer
The DB2 Estimator
Optimize DB2 Application Performance Mastery Test
Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at 770-872-4278
