Intel 170 Servers, AS/400 RISC Server, 7xx Servers manual Copyright IBM Corp

Models: 7xx Servers 170 Servers AS/400 RISC Server

1 368
Download 368 pages 6.76 Kb
Page 63
Image 63

2.The System i information center section on DB2 for i5/OS under Database and file systems has information on all aspects of DB2 for i5/OS including the section Monitor and Tune database under Administrative topics. This can be found at url: http://www.ibm.com/eserver/iseries/infocenter

3.Information on creating efficient running queries and query performance monitoring and tuning is found in the DB2 for i5/OS Database Performance and Query Optimization manual. This document contains detailed information on access methods, the query optimizer, and optimizing query performance including using database monitor to monitor queries, using QAQQINI file options and using indexes. To access this document look in the Printable PDF section in the System i information center.

4.The System i redbooks provide performance information on a variety of topics for DB2. The redbook repository is located at http://publib-b.boulder.ibm.com/Redbooks.nsf/portals/systemi.

IBM i 6.1 Performance Capabilities Reference - January/April/October 2008

© Copyright IBM Corp. 2008

Chapter 4 - DB2 Performance

 

63

Page 63
Image 63
Intel 170 Servers, AS/400 RISC Server, 7xx Servers manual Copyright IBM Corp