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

Kendrick Ren, Yuan Gao, Robert Heath, and Cliff Leung

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=825866
ArticleTitle=Handling access-plan changes using InfoSphere Optim Query Workload Tuner on DB2 for z/OS
publish-date=07192012