Administration Guide

Chapter 27. Operational Performance

The following topics provide information on how you can influence performance of an SQL query during run-time:

• "How DB2 Uses Memory"
• "Managing the Database Buffer Pool"
• "Managing Multiple Database Buffer Pools"
• "Prefetching Data into the Buffer Pool"
• "Configuring I/O Servers for Prefetching and Parallel I/O"
• "Sorting"
• "Reorganizing Catalogs and User Tables"
• "Performance Considerations for DMS Devices"
• "Managing Initialization Overhead"
• "Database Agents"
• "Using the Database System Monitor"
• "Extending Memory".

The following chapters also provide information on how performance can be influenced:

• Chapter 22, Application Considerations
• Chapter 23, Environmental Considerations
• Chapter 24, System Catalog Statistics.

You may also refer to Administration Guide: Planning physical database design considerations.