DB2 for LUW Performance Tuning and Monitoring Workshop - SPVC - 2L413G

Description

Use tools in class that are common across the Linux, UNIX, and Windows environments. During labs running on DB2 10.1, develop your ability to use monitoring tools, Explain tools and DB2 utilities like RUNSTATS, REORG and db2batch to tune a database running on your local LINUX workstation.

The course materials cover DB2 10.1 for Linux, UNIX, and Windows.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

http://www.ibm.com/training/terms

Database Monitoring
Database I/O Management
Table space and Table Design for Performance
DB2 Memory Management
Automated Memory Management
Application Performance Considerations
Using Explain Tools
The DB2 Optimizer
Using Indexes for Performance
Complex SQL Performance
Tools and Utilities for Performance
Event Monitor

Aim

Define the impact of database design (tables, indexes, and data placement) on database performance
Describe database application programming considerations and how they affect performance
Identify and describe the parameters (database and non-database) that affect performance
Tune parameters to achieve optimum performance
Identify and use the tools that assist in monitoring and tuning of a database

Participant requirements

You should complete:

DB2 10 for LUW: Basic Administration for Linux and Windows (CL2X3) or
DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL484)

Participant

This is an advanced course for database designers, database administrators, and application developers working with DB2 for Linux, UNIX, and Windows who are concerned about performance.