Recreate optimizer access plans using db2look

A tool to aid in tuning queries

From the developerWorks archives

Samir Kapoor and Kaarel Truuvert

Date archived: May 15, 2019 | 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 content, steps, or illustrations may have changed.

Zone=Information Management
ArticleTitle=Recreate optimizer access plans using db2look