Optim Query Tuner: Capture and tune DB2 z/OS SQL statements using a user-defined SQL repository

From the developerWorks archives

Cheung-Yuk Wu, Leif Pedersen, and Cliff Leung

Date archived: January 11, 2017 | First published: May 09, 2013

Learn how to create query workloads directly from your own SQL repository, without the overhead of archiving or staging your workload data. Leverage the Query Tuner user interface to define dynamic and static SQL statement filters, and tune the saved workload without implementing your own client. This article describes how you can define database views against your existing SQL repository that stores dynamic or static SQL statements in your environment. The Optim™ Query Tuner user-defined SQL repository can use these views to filter and capture SQL statements directly from your SQL repository for single-query tuning or workload tuning.

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=928977
ArticleTitle=Optim Query Tuner: Capture and tune DB2 z/OS SQL statements using a user-defined SQL repository
publish-date=05092013