Duration
4 days
Course Overview
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.
Through the course of 4 days, build knowledge and experience with DB2 for i5/OS support for SQL and high performance data access and data processing. Through lecture and lab exercises learn about best practices for SQL, indexing and statistics. Become familiar with the science and art of using System i Navigator Performance Center, including SQL Performance Monitors, SQL Plan Cache and Visual Explain.
Audience
This course is designed 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.
Pre-requisites
- 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
Course Objective
- 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
Key Topics
- DB2 for i5/OS Query Optimizer and Database Engine
- Parallel database processing - DB2 Symmetric Multiprocessor (SMP)
- Indexing and Statistics strategies
- SQL application design and programming best practices
- State of the art tools, including System i Navigator Performance Center
- Best practices for popular SQL interfaces, such as Open Database Connectivity (ODBC), Call Level Interface (CLI), and Java Database Connectivity (JDBC)
Programme scope, delivery arrangements and suitability are confirmed during enquiry.