Strategies and Tactics in the Science and Art of DB2 for i SQL Tuning (OLB20G)

During the 3 day session, we discuss the fundamentals of query optimization and query execution in IBM i and the building blocks of SQL query plans. We also provide guidance on the tools and techniques used to monitor, analyze and tune SQL requests, as well as share best practices for designing and implementing data centric solutions using DB2 for i. In addition to lectures, there will be an opportunity to explore the strategies and tactics using hands on exercises. 

If you are acting as the DB2 for i Database Engineer, or you are responsible for the success of data centric programming, this event is for you!

Teacher: Mike Cain, Senior Technical Staff Member, Team Leader DB2 for i Center of Excellence, Lab Services and Training, IBM Systems and Technology Group, IBM US (Rochester).

Database Designer, Perfomance Analyst, Application Developer.

Mike Cain is a Senior Technical Staff Member within the IBM Systems organization.  He is the creator and team leader of the DB2 for i Center of Excellence located in Rochester, Minnesota USA.  Prior to his current position, he worked as an IBM AS/400 Systems Engineer and technical consultant and educator.  Before joining IBM in 1988, Mike worked as a System/38 programmer and Data Processing Manager for a property and casualty insurance company.  Mike has 27 years of experience with IBM working with clients and business partners around the world. In additional to assisting clients, he uses his knowledge and experience to influence the IBM solutions, development and support processes.  Mike's insight and perspectives can be found at: