Handling access-plan changes using InfoSphere Optim Query Workload Tuner on DB2 for z/OS
For a large number of packages
From the developerWorks archives
Date archived: January 11, 2017 | First published: July 19, 2012
Access-plan changes can happen at any point during the database-application or data-server maintenance lifecycle. It is important for DBAs to handle these changes quickly and effectively. However, most DBAs lack tools to deal with access-plan changes in large numbers of packages in enterprise-scale applications. In this article, we describe methods of managing query access plans in such situations. We also introduce a tool provided in IBM® InfoSphere® Optim™ Query Workload Tuner 3.1 to implement these methods.
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.