Db2 for LUW System Performance & Tuning

SEE SCHEDULE

Duration: 4 Days

Method: Instructor led, Hands-on workshops

Price: $2250.00

Course Code: DB3017

Audience

Database administrators, systems personnel and senior development staff.

Description

This course covers all aspects of Db2 performance & tuning. Over four days, we cover system monitoring and tuning, buffer pool and memory allocation, keys to indexing, table design and monitor application performance. This class uses hands-on and paper exercises to reinforce the topics covered. This class is current to Db2 11.1 and new fix packs.

Prerequisites

This is not an introductory Db2 class. Students should be senior enough to be Db2 DBAs or senior application staff, or have experience with another DBMS.

Topics

I. Object Management
- Db2 Arcitecture Types of objects and their relationships
- Table types
II. Key System Parameters
- Heaps, Servers, and Thresholds
- Database config
- Database manager config
- Registry
- Workload Manager
III. Buffer Pool Optimization Techniques
- Types of physical I/O
- A buffer pool tuning methodology
- Number and size of buffer pools
- Object placement in BPs
- Tuning sorts
IV. Database and Db2 System monitoring
- DB and DBM snapshot monitors
- Event Monitors
- Techniques to save and develop performance history
- Building a performance database
V. Table Space Design
- DMS, SMS & Automatic storage
- Table design
- Data compression
- RUNSTATS
- Reorganizing tables and indexes
- Utility performance
VI. Locking and concurrency
- Understanding locking
- Lock choices in various environments
- Monitoring locks
VII. Index Design
- Index structure and MDC indexes
- When to use indexes
- Index redesign
VIII. Access Path Selection
- Types of access paths
- Range delimiting and sargable predicates
- Factors used in access path selection
- Db2 catalog statistics used
- Join methods and subselects
IX. Evaluating SQL Performance
- Explain tables, db2expln, db2exfmt
- Monitoring using Db2 catalog information
- Design Advisor