Skip to main content

 
IBM Power Systems software  >  IBM i  > Support and services  > 

DB2 for i SQL Performance Monitoring, Analysis and Tuning Workshop

  
 View schedule and enroll

Interested in bringing a class to you? Onsite training

Overview
Audience
Prerequisites
Skills taught
Course outline



       
Course code LSDB24i Skill level Intermediate
Duration 4.0 days Delivery type Classroom
(Hands-on labs)
Course type Public or Private on-site    
Public price USD $2,500.00 plus tax    

Learn the information, tools and strategies for monitoring, analyzing and tuning DB2 for i Structured Query Language (SQL). Explore the science and art behind the DB2 for i 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.

View this course in other countries

Training Paths that reference this course are:
Application Developer (DB2, WDSc, RPG, COBOL, CL, SQL)

Back to top
 
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.

Back to top
 
Prerequisites

You should have:

  • Intermediate knowledge of SQL and relational database concepts
  • Basic understanding of DB2 for i
  • Basic understanding of Sytem i and i5/OS architecture and application concepts
  • Basic understanding of System i and i5/OS work management
Back to top
 
Skills taught
  • Understand the art and science of DB2 for I SQL query optimization and execution
  • Explain the strategies and related methodology for monitoring, analyzing and tuning DB2 for i 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
Back to top
 
Course outline
  • DB2 for i 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)
Back to top