Optim Query Tuner: Capture and tune DB2 z/OS SQL statements using a user-defined SQL repository
From the developerWorks archives
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.