WA1675 DB2 System Performance and Tuning for Linux, Unix and Windows Training and Courseware

This course is designed to review many aspects of performance and tuning of DB2 version 9,  for Linux, UNIX and Windows. DB2 commands and tools created by IBM for DB2, will be used to support workshop activities. Performance and tuning varies with type of user to be supported.  We will review this topic for support of SQL users, programmers, data designers and database administrators.

What you will learn
At the end of this course, students will be able to:
  • Code SQL to improve performance.
  • Use DB2 EXPLAIN tools to evaluate performance expectations.
  • Design application programs to improve performance and review with EXPLAIN tools.
  • Use the tool DB2BATCH to benchmark applications.
  • Improve performance through parallelism
  • Review data placement to improve performance.
  • Understand row compression and range partitioning on tables to improve performance
  • Consider Multi-Dimensional Clustering as a design option, by analysing data and application needs.
  • Tune registry variables and configuration parameters to effect performance.
  • Use DB2 monitor tools to assist in performance tuning.
  • Use performance improving options for DB2 utilities
  • Configure DB2 for self tuning
  • Use advanced features of utilities including support for identity columns.
  • Set for automatic maintenance.
  • Use and analyse benefits of advanced table design like row compression.
Audience
Database administrators and those senior support persons who are responsible for tuning DB2 for performance.
 
Prerequisites
Relevant Operating Systems experience (Linux, UNIX or Windows) along with knowledge of relational database theory and SQL. Previous experience of using DB2 in a support roles that includes some database administration.
 
Duration
Four days.
More Information
Schedule this course
Course Outline
Download this page as a word document
Learn more about the courseware