Configuring for good performance
Some types of DB2® deployment,
such as the InfoSphere® Balanced Warehouse® (BW),
or those within SAP systems, have configurations that are highly specified.
Instance configuration
When you start a new DB2 instance,
there are a number of steps that you can follow to establish a basic
configuration.
Data organization
Over time, data in your tables can become fragmented, increasing
the size of tables and indexes as records become distributed over
more and more data pages. This can increase the number of pages that
need to be read during query execution. Reorganization of tables and
indexes compacts your data, reclaiming wasted space and improving
data access.
Application design
Database application design is one of the factors that
affect application performance. Review this section for details about
application design considerations that can help you to maximize the
performance of database applications.
Lock management
Lock management is one of the factors that affect application
performance. Review this section for details about lock management
considerations that can help you to maximize the performance of database
applications.
Query optimization
Query optimization is one of the factors that affect application
performance. Review this section for details about query optimization
considerations that can help you to maximize the performance of database
applications.