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
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.