DB2 UDB Performance and Tuning for Unix and Windows Training

Course #:WA1296

DB2 UDB Performance and Tuning for Unix and Windows Training

This course is designed to review the concepts and components of DB2 for UNIX and Windows. DB2 commands and SQL will be used to focus on DB2 administration activities. The relationships between object components will be presented along with communication and security aspects. Design issues of referential Integrity, table check constraints, user defined data types and functions, triggers and large objects will be reviewed. Program design issues will be considered which effect concurrency, integrity and performance. DB2 administration functions and utilities will be reviewed and applied in workshops. Performance and tuning issues will be reviewed.

  After completing this course the student should 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.
  • 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
Target Audience
  Database administrators, programmers and data designers who are responsible for tuning DB2 for performance
  • Relevant Operating Systems experience (AIX or Windows) along with knowledge of relational database theory, SQL and programming.
  • Previous experience of using DB2 or similar relational databases is required.
  Three days.

Outline of DB2 UDB Performance and Tuning for Unix and Windows Training

There is no detailed outline for this course at this time.

We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.