Chapter 7. Performance maximization techniques 239
7.2 IBM DB2 Performance tuning considerations
Depending on the size of your environment, there are many options available
when tuning your IBM DB2 Universal Database Enterprise Edition servers’
performance. Follow the recommendations given in the following sections to help
maximize your DB2 server’s potential.
Here are some of the factors affecting DB2 performance. This is based on the
information provided by the redbook
Database Performance Tuning on AIX
,
SG24-5511
.
Database Size
The performance of the Administration server Web interface will be reduced if
table sizes in the administration database (TLMA) become too large. Most of
the database tables are reasonably static, because they