atabase performance is one of those things that goes unnoticed, until it starts flagging. There are three broad areas relevant to database performance:
- System resources (essentially, the hardware)
- Data structures and the way they are allocated to system resources
- Data operations requested by the applications and they way they are allocated to system resources
DB2 uses a default configuration, aimed to allow a simple, reliable, scalable database to be built with minimal effort on minimal hardware. Achieving the best performance means taking more responsibility for certain background informationinformation DB2 uses in allocating resources to its work.This article presents an overview of key factors in how DB2 uses disk and memory to place and retrieve data. The information is pertinent to DB2 v5 or later.
An underperforming database can be tricky to troubleshoot, particularly for inexperienced DBAs. You want to optimize the performance of your DB2 database, but aren't sure how to begin.
Learn how and where your data is stored and how to manage it for better performance.