DB2 for i SQL Performance Workshop

DB2 for i Center of Excellence - Rochester, MN

Description

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

Skills taught

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:

North America Schedule

Outside of North America Schedule

Interested in future scheduling or a custom onsite workshop, contact the IBM Systems Lab Services and Training.

Contact IBM

Browse Power Systems

Next generation applications for big data and analytics and cognitive computing are providing unprecedented insights into opportunities, threats and efficiencies. IBM Power Systems is at the forefront of delivering solutions to gain faster insights from analyzing both structured information and unstructured big data. With the secure, flexible and open platform of IBM Power Systems plus solutions and software, organizations can outpace their competitors by delivering faster services, providing differentiated offerings and turning operational cost into investment opportunity.

IBM Power Systems hardware is at the heart of enabling major business and industry transformations fueled by the explosive growth of big data and analytics. Power Systems help organizations drive faster business insights with industry leading performance, scalability and virtualization flexibility.

IBM Power Systems deliver flexibility and choice of operating systems to enable your business to support the next generation applications for big data and analytics and cognitive computing that are transforming how organizations work today. Whether running 1, 2, or all 3 - coupled with PowerVM, they maximize the benefit of Power Systems in your business.

IBM's integrated approach to developing Systems and Systems Software stacks together delivers a platform that supports next generation applications for big data and analytics and cognitive computing on an open platform for choice while providing maximum utilization, availability, and flexibility to help you deliver new advantages to your business.

IBM and IBM Business Partner solutions exploit key benefits in IBM Power Systems’ unique design combined with systems software to provide support for next generation applications for big data and analytics and cognitive computing to providing unprecedented insights into opportunities, threats and efficiencies to your organization.


Over the last five years thousands of clients have migrated to IBM Power Systems. Learn how Power Systems has helped them support next generation applications for big data and analytics and cognitive computing on an open platform for choice while improving business performance, reducing risk, and establishing a platform for growth.

Additional information