Use IBM InfoSphere Optim Query Workload Tuner 3.1.1 to tune statements in DB2 for Linux, UNIX, and Windows, and DB2 for z/OS that reference session tables

From the developerWorks archives

Daniel Zilio, Cliff Leung, Gao Zhong Liang, Guo Bin Zhao, Cheung-Yuk Wu, Bian Li, Xin Wu, and Rui Yang

Date archived: January 12, 2017 | First published: November 08, 2012

IBM® InfoSphere® Optim® Query Workload Tuner (OQWT) 3.1.1 can tune statements for IBM DB2 for Linux®, UNIX®, and Windows®, and IBM DB2® for z/OS®. This tutorial describes how to use OQWT to tune a statement that accesses one or more session tables. Two methods are presented on how to set up the database environment for the session table such that OQWT 3.1.1 can tune statements using the table. Examples are provided for a script that is required to set up the environment, including example snapshots of the output and functionality of the applicable OQWT tuning features.

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=844222
ArticleTitle=Use IBM InfoSphere Optim Query Workload Tuner 3.1.1 to tune statements in DB2 for Linux, UNIX, and Windows, and DB2 for z/OS that reference session tables
publish-date=11082012