DB2 Performance Tuning for AIX

Audience: System Administrators

Date: December 8, 2001

In response to last weeks Oracle performance tips, several people have asked about DB2 tuning. Here are the resources I use for tuning AIX for DB2. Many, if not most, of the DB2 and Oracle settings are the same.

Redbooks:

Home page: http://www.redbooks.ibm.com
SG24-5511 - Database Performance on AIX in DB2 UDB and Oracle Environments
SG24-5340 - RS/6000 SP Performance Tuning Update (See Chapter 16)

DB2 Performance:

DB2 Tuning for AIX: DB2 UDB V7.1 Performance Tuning Guide Performance: http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_main
See "Performance" under the Administration category

Other DB2 Information
Publications: http://www-4.ibm.com/software/data/pubs /
Manuals: http://www-4.ibm.com/software/data/db2/library /

TPC Web Page

Full Disclosure Reports include AIX settings: http://www.tpc.org