第一天

1 Introduction to Database Performance
1.1 Performance Tuning Overview
1.2 Database Architecture Fundamentals
1.3 Hardware Planning Rules of Thumb
1.4 Database Design & Recommendations
2 DB2 LUW Performance Hands on Lab

3 Performance Monitoring Essentials
3.1 Introduction to Monitoring Essentials
3.2 Monitor Elements
3.3 Monitoring Interfaces Available with DB2
3.4 Essential Monitoring Targets

4 Monitoring Interfaces & Monitor Targets Hands On Labs

第二天

1 Performance Monitoring Tool Overview?

2 Performance Monitoring Tool Hands On Labs

3 SQL Query Tuning Overview?
3.1 Problematic SQL & Situation
3.2 Response time solution
3.3 SQL costs solution
3.3.1 Snapshot Monitoring
3.3.2 Event Monitoring
3.3.3 SQL Monitoring Interfaces
3.3.4 Analyzing SQL
3.3.5 Statement Concentrator
3.4 Making Performance Improvements
3.4.1 Database Objects
3.4.2 Better Coding
3.4.3 Design Advisor
3.4.4 DB2 Optim Query Workload Tuner
3.4.5 Other Considerations

4 SQL Query Tuning Hands On Labs
5 Locking Overview and Hands On Labs
5.1 Logging Concepts
5.2 Configuration and Performance
5.3 Logging Bottlenecks
5.4 Reducing Logging
5.5 Monitoring and Tuning

6 Locking Hands On Labs

7 DB2 Utilities Overview and Hands On Labs
7.1 Features that impact utility performance
7.2 Maintenance commands, utilities and stored procedures
7.3 Automating maintenance

8 DB2 Utilities Hands On Labs