Administration Guide

Chapter 15. 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 also provide information on how performance can be influenced:

• Chapter 2. "Designing Your Physical Database"
• Chapter 10. "Application Considerations"
• Chapter 11. "Environmental Considerations"
• Chapter 12. "System Catalog Statistics".

[ DB2 List of Books | Search the DB2 Books ]