Get tips from Kent Milligan, Senior DB2 Consultant at IBM, to help you analyze and tune DB2 for IBM i SQL requests. The ability to identify and resolve performance issues is a critical skill when running reports and queries that use SQL to access DB2 for i. This session helps you start developing your skills and introduces you to the graphical toolset that DB2 for i provides, at no additional charge, to help you analyze and tune SQL requests.
The DB2 performance tools being reviewed include:
- SQL Plan Cache Tooling—Instantly identify the longest-running queries and the most frequently run SQL statements
- Index Advisor—Real-time advice on which indexes boost query performance
- Index Evaluator—Insight on the most valuable indexes for performance and which indexes are just wasting disk space.
It's time to write more efficient SQL queries for DB2 on IBM i. See how Sequel can help.