Gauge SQE use in DB2 for i 6.1

From the developerWorks archives

Scott Forstie

Date archived: January 11, 2017 | First published: November 22, 2009

This article explains how to collect a SQL Performance Monitor and understand how many of the SQL queries are using SQE and why other SQL statements continue to use CQE. SQE is the strategic query engine on DB2 for i, with better performance, scaling and tooling such as the SQL Plan Cache.

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=449245
ArticleTitle=Gauge SQE use in DB2 for i 6.1
publish-date=11222009