CL412 IBM DB2 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop
Explore performance issues affecting the design of the database and applications using the database, the major database performance parameters, and the different tools that assist in performance monitoring and tuning.
Who Should Attend
This is an advanced course for database designers, database administrators, and application developers working with DB2 for Linux, UNIX, and Windows who are concerned about performance.
1 - Day 1
- Unit 1: Database monitoring
- Exercise 1: Database Monitoring
- Unit 2: Database I/O Management
- Unit 3: Table Space and Table Design for Performance
- Exercise 2: I/O Management and Table Space Design
2 - Day 2
- Unit 4: DB2 Memory Management
- Exercise 3: Memory Management
- Exercise 4: Section 1 - Setup for STMM lab
- Unit 5: Automatic Memory Management
- Exercise 4: Sections 2, 3 - Using STMM to Manage Memory
- Unit 6: DB2 Application Performance Considerations
- Exercise 5: Application Performance
3 - Day 3
- Unit 7: Using Explain Tools
- Exercise 6: Using Explain Tools
- Unit 8: The DB2 Optimizer
- Exercise 7: DB2 Optimizer
- Unit 9: Using Indexes for Performance
- Exercise 8: Index Performance
4 - Day 4
- Unit 10: Complex SQL Performance
- Exercise 9: Complex SQL Performance
- Unit 11: Tools and Utilities for Performance
- Exercise 10: Tools and Utilities
- Unit 12: Event Monitoring
- Exercise 11: Event Monitors
This is a 4-day class
GTR Guaranteed to Run
Class times are listed Eastern time. This class is available for Private Group Training
To sort by location or date, click the ‘When’ and ‘Where’ column headings.
Class dates not listed.
Please contact us for available
dates and times.