Skip to main content

PartnerWorld > Products > Systems, servers, and storage > Technical >

Creating and using materialized query tables (MQT) in IBM DB2 for i

by Michael W. Cain

Last updated: 2006-10-18

PDF iconDownload the white paper (590 KB)
Links to external URLGet Adobe® Reader®

 
Rate this article
  Feedback

© Copyright IBM Corporation, 2008. All Rights Reserved.
All trademarks or registered trademarks mentioned herein are the property of their respective holders.

Abstract
This white paper explains, at length, the process for creating and implementing materialized query tables (MQT) within the IBM DB2 UDB for iSeries environment. MQT is a new technology that is delivered with the latest release of this state-of-the-art database. It offers new methods for enjoying high performance query processing.
Introduction
On any platform, good database performance depends on good design. And good design includes a solid understanding of the underlying operating system and database technology, as well as the proper application of specific strategies.

This is also true for IBM® DB2® for i5/OS, which provides a robust set of technologies that assist with query optimization and performance.

This paper introduces DB2 for i5/OS materialized query tables (MQT) and looks at their design, creation and use.

It is strongly recommended that database administrators, analysts and developers who are new to the IBM System i™ platform, or new to SQL, attend the “DB2 for i5/OS SQL and Query Performance Monitoring and Tuning” workshop. This course teaches the developer the proper way to architect and implement a high-performing DB2 for i5/OS solution. The IBM Global Services Web site listed in Appendix B provides more information about this workshop.

The points discussed in this paper assume some knowledge of DB2 for i5/OS. It is helpful to refer to, and familiarize yourself with, the information contained in the iSeries Information Center Web site listed in Appendix B, as well as the following publications:

Prerequisite publications
  • DB2 for i5/OS SQL Reference
  • DB2 for i5/OS Database Performance and Query Optimization

Redbooks
  • Preparing for and Tuning the V5R2 SQL Query Engine on DB2 UDB for iSeries (SG24-6598-00)
  • SQL Performance Diagnosis on DB2 UDB for iSeries
  • (SG24-6654-00)

Papers
  • Indexing and Statistics Strategies for DB2 for i5/OS
  • Star Schema Join Support within DB2 for i5/OS
  • DB2 for i5/OS Symmetric Multiprocessing

Links to these as well as other database publications listed in the Resources section of this course.