Administration Guide

Chapter 23. 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 Table Data"
• "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 18, Application Considerations
• Chapter 19, Environmental Considerations
• Chapter 20, System Catalog Statistics.

You may also refer to Administration Guide, Design and Implementation physical database design considerations.

[ DB2 List of Books | Search the DB2 Books ]