X

CL412 IBM DB2 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop

Course Overview

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.

Course Outline

1 - Day 1

  • Welcome
  • 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

Enroll Today

This is a 4-day class

Price: $2,895.00
Payment Options

ILT Instructor‑Led Training

OLL Online LIVE

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.