Reviewing DB2 for i5/OS query optimizer and database engine feedback mechanisms
DB2 for i5/OS: Feedback is good
From the developerWorks archives
Date archived: January 12, 2017 | First published: November 09, 2006
Learn how DB2® implements requests using various database feedback mechanisms, and understand how the database engine works. Compare the use of Visual Explain with the use of the database monitors or the SQE Plan Cache, and learn when to use which mechanism. Use DB2 for i5/OS® to ask for and receive feedback on demand. Then use the iSeries™ Navigator to analyze, understand, and tune SQL requests.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.