Reviewing DB2 for i5/OS query optimizer and database engine feedback mechanisms

DB2 for i5/OS: Feedback is good

From the developerWorks archives

Mike Cain and Jackie Jansen

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management, IBM i
ArticleID=173385
ArticleTitle=Reviewing DB2 for i5/OS query optimizer and database engine feedback mechanisms
publish-date=11092006