KT-OD400 IBM DB2 for i SQL Performance Monitoring and Tuning Workshop Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University


Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training



 Course Search
Course #

 Training Delivery
Training Delivery
Custom Curriculum
Course List
 Main Menu
View Courses
Site Index

IBM DB2 for i SQL Performance Monitoring and Tuning Workshop


Learn the information, tools and strategies for monitoring, analyzing and tuning IBM DB2 for i5/OS Structured Query Language (SQL). Explore the science and art behind the DB2 for i5/OS query optimizer and database engine, including database performance and scalability. Discuss performance issues affecting database design and data-centric applications. Get hands on experience with database performance parameters and options, as well as the various tools that assist in performance monitoring, analysis and tuning. Knowledge and skill gained by attending this course are considered critical success factors when building and deploying SQL based solutions.

Skills taught 

  • Understand the art and science of DB2 for i5/OS SQL query optimization and execution  
  • Explain the strategies and related methodology for monitoring, analyzing and tuning DB2 for i5/OS SQL and query performance Discuss how to design high-performing SQL applications on the System i  
  • Recognize the database and system parameters and options that can impact performance

Click here to view the Course Outline


This is an intermediate course for i5/OS database designers, performance analysts, and application developers who are concerned about SQL and query performance. It is highly recommended for individuals interested in SQL and query performance of System i running i5/OS as the database server, application server or web server. This course is also designed for database administrators, database consultants and performance analysts working in and around iSeries or System i.


You should have:

  • Intermediate knowledge of SQL and relational database concepts Basic understanding of DB2 for i5/OS  
  • Basic understanding of Sytem i and i5/OS architecture and application concepts  
  • Basic understanding of System i and i5/OS work management
4 Days  

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.