| Course Code: |
RT 521 |
| Course Abstract: |
This course provides SQL developers a fast-paced transition to DB2 performance and tuning. The course starts with an understanding of the DB2 architecture, environment and data structures, then covers index internals and proceeds to block index MDC’s. Next access methods are reviewed before the details of writing effective SQL predicates. Explain tables and tools are covered in detail as well as additional performance tools. The optimizer is studied along with RUNSTATS to understand why index methods are chosen by the access plan. Then MQT’s, database partition sand table partitions are explored and their relationships. Finally, monitoring with admin views is covered along with some performance suggestions. |
| Audience: |
This course is designed for SQL developers. |
| Duration: |
2 days |
| Learning Outcomes: |
Upon completion of this course, the participant will be able to:
> Use and understand performance components of DB2
> Recognize internal and index structures
> Efficiently query with effective predicates
> Employ data optimization techniques
> Create and Use MQT’s, MDC’s and partitions
> Use monitoring tools
> Identify and Use explain tables and tools |
| Course Topics: |
DB2 Architecture including (Memory, EDU, Tablespace, Bufferpool)
Structures including (Table, Page, Row)
Indexes including (Regular, Cluster, XML)
Access Methods
SQL Predicates
Explain Tables & Tools including (MS Perf Script)
DB2 Optimizer including (Statistics, Statistical Views)
Materialized Query Tables
Multi-Dimensional Clusters
Partitions including (DPF, Table Partitioning)
SQL for Performance including (Case, Derived Tables, Recursion)
Admin Routines and Views
Performance Suggestions
Appendix Query Tools |
| Prerequisites: |
DB2 - Fast Track to Programming class required. |