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

Audience 

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.

Prerequisites 

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