|
NWDB3017 DB2 System Performance & Tuning for Distributed Platforms (LUW)
DESCRIPTION
This 4 day course is designed to review many aspects of performance and tuning of DB2 version 9.5, for Linux, UNIX and Windows (LUW). 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.
AUDIENCE
Database administrators and those senior support persons, who are responsible for tuning DB2 for performance or analyzing application performance.
OBJECTIVES
After completing this course the student should be able to:
- Code SQL to improve performance.
- Use various 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.
- Use various tools and snapshot functions and administrative views to evaluate DB2 perfomance and operational behaviour of 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 DB2 for automatic maintenance.
- Use and analyse benefits of advanced table design like row compression.
TOPICS
- Creating Tables and Tablespaces
- Advanced SQL Techniques
- SQL Performance
- Data Access and EXPLAIN
- The DB2 Optimizer
- Event and Snapshot Monitors
- DB2 Operational Model
- The Health Monitor and Activity Monitor
- DB2 Configuration Parameters
- Multi Dimensional Clustering (MDC)
- Advanced Table Options
- Configuring for Self Tuning of DB2
PREREQUISITES
Relevant Operating Systems experience (Linux, UNIX or Windows) along with knowledge of relational database theory and SQL. Previous experience of using DB2 that includes either some database administration or application support.
|
