Tuning DB2 Universal Database Using the Statement Event Monitor

From the developerWorks archives

Ramakrishna Kolluru

Date archived: January 13, 2017 | First published: March 13, 2003

This article describes a technique for analyzing output from the DB2 Universal Database statement event monitor in order to tune your SQL and determine what indexes should be created to improve performance. A sample program is provided.

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
ArticleID=13799
ArticleTitle=Tuning DB2 Universal Database Using the Statement Event Monitor
publish-date=03132003