For many database administrators and SQL application programmers, new to the IBM i (formerly known AS/400 and iSeries), DB2 for i is an unknown commodity. As a result they experience poor performance when comparing the execution of SQL statements on other platforms to the IBM i platform. In addition, existing customers, familiar with native record-level database access techniques and IBM i Work Management concepts, are totally stymied when attempts to convert legacy applications to SQL produce undesirable results. This workshop addresses these issues.
In this workshop, you will gain a deeper understanding of the DB2 for i query optimizer and SQL Engine This workshop also teaches a methodology for analyzing and tuning DB2 for i performance from an SQL and query perspective.
This workshop provides lectures and labs in a face-to-face classroom setting. The labs are used to demonstrate and provide hands on experience with most of the topics covered in the workshop. In addition, the labs also focus on teaching the student a methodology for using the graphical DB2 performance tools that are provided by IBM i Navigator.
Test Drive Videos
Audience & Prerequisites
This workshop is intended for existing IBM i (including iSeries and AS/400) database engineers, performance analysts, and application developers who are concerned about SQL and query performance. It is also highly recommended for individuals new to the platform that are interested in SQL and query performance with DB2 for i.
The following are recommended prerequisites:
Outside of North America Schedule
Interested in future scheduling or a custom onsite workshop, contact the IBM Systems Lab Services and Training.