Using V9 Explain Tables for Query Tuning

Date: 
Tuesday, 16 June, 2009 - 14:15 - 15:30
Speaker: 
Susan Lawson

Objectives:
Learn how to use the new EXPLAIN tables to help with query tuning efforts.

Outline:
Discuss IBM Visual Explain and Optimization Service Center
Discuss the tables that support them for information
Discuss how to use these tables without the tools
Discuss the DSN_STATEMENT_CACHE_TABLE for dynamic SQL tuning

Full Abstract:
DB2 z/OS V8 and 9 have introduced us to many new EXPLAIN tables. This session will introduce users some of the new EXPLAIN tables to be used for advanced query analysis, and demonstrate how SQL queries can be used to gather and analyze the this information. The session will also include information about using the DSN_STATEMENT_CACHE_TABLE to perform analysis on the dynamic SQL cache.

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023