Recreate optimizer access plans using db2look

A tool to aid in tuning queries

From the developerWorks archives

Samir Kapoor and Kaarel Truuvert

Date archived: January 12, 2017 | First published: August 04, 2005

The db2look tool gives you a way to recreate the same access plan for your test environment that DB2® Universal Database™ (DB2 UDB) is using for your production environment. Here are all the details for setting it up.

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=91239
ArticleTitle=Recreate optimizer access plans using db2look
publish-date=08042005