My Cart
Bookstore Sign In

Preparing for and Tuning the V5R2 SQL Query Engine on DB2 Universal Database for iSeries

TOP : iSeries

Preparing for and Tuning the V5R2 SQL Query Engine on DB2 Universal Database for iSeries

DB2 Universal Database (UDB) for iSeries is deeply rooted in the architecture and heritage of the AS/400 and its predecessor, System/38. The IBM eServer iSeries server has a successful 24-year history of satisfying hundreds of customers' requirements, thanks to its developers.

The database has undergone significant changes over the years to maintain its competitive advantage. However, with an increasing demand for change, IBM has made fundamental changes to the structure of the database to compete successfully in the industry. In doing so, IBM Rochester launched a project to re-engineer and redesign important components of the database. The goal was to form the base for the future development of the product. This made the product easier to maintain, enhance, and provide far better performance. The redesigned components were architected using object-oriented design concepts and then implemented using DB2 Universal Database (UDB) for iSeries is deeply rooted in the architecture and heritage of the AS/400 and its predecessor, System/38. The IBM eServer iSeries server has a successful 24-year history of satisfying hundreds of customers' requirements, thanks to its developers.

The database has undergone significant changes over the years to maintain its competitive advantage. However, with an increasing demand for change, IBM has made fundamental changes to the structure of the database to compete successfully in the industry. In doing so, IBM Rochester launched a project to re-engineer and redesign important components of the database. The goal was to form the base for the future development of the product. This made the product easier to maintain, enhance, and provide far better performance. The redesigned components were architected using object-oriented design concepts and then implemented using object-oriented design concepts and then implemented using object-oriented implementation techniques.

Query optimizer was one of the key components that was redesigned. This IBM Redbook gives a broad understanding of the new architectural changes of the database concerning query optimizer. It explains:

  • The architecture of the new query optimizer
  • The new data access methods used by the new query optimizer
  • The new Statistics Manager included in V5R2
  • The feedback message changes of the new query optimizer
  • Some performance measurements
Price: $37.50 $30.00
Pages: 168
Date Published: August 28, 2003
ISBN: 0738425788
Author: IBM Redbooks
Product Number: SG24-6598-00
Ships in 3-5 days
Return to category
Why Vervante?

© 2024 Vervante Corporation. All rights reserved.