DB2 UDB Enterprise Edition V8.1: Basic Performance Tuning Guidelines

IBM DB2 Universal Database (DB2 UDB) is configured to run on any system that meets its minimum hardware requirements. As a result, the basic configuration provided must be tuned to achieve optimum performance on systems that exceed the these requirements. Tuning a system can be quite involved. Volumes could be written (and often have been) on tuning each system level. Because the subject is quite complex, no single paper can really teach you everything about tuning a system for optimum performance. However, a single paper can cover the basics needed to tune one level of a system and that is the main purpose of this IBM Redpaper. It provides you with basic tuning information and a set of guidelines that can be used to modify the basic configuration of DB2 UDB to improve overall database performance.

Not available.

• Database Partitioning, Table Partitioning, and MDC for DB2 9, SG24-7467-00
• IBM System z10 Enterprise Class Technical Introduction, SG24-7515-02
• PowerVM Virtualization on IBM System p: Introduction and Configuration Fourth Edition, SG24-7940-03

Publish Date
12 June 2007

Rating:
(based on 2 reviews)

Rate this paper

Author(s)

Alex Osuna is a project leader at the ITSO, Tucson Center. He writes extensively and teaches IBM classes on all areas of storage. He has over 28 years in the IT industry, working for the United States Air Force, IBM, and Tivoli in computer maintenance, field engineering, service planning, Washington Systems Center, business and product planning, advanced technical support, and systems engineering, focusing on storage hardware and software. He has more than10 certifications from IBM, Microsoft and Red Hat.

• Alex Osuna

Roger E. Sanders is a senior manager, IBM Alliance Engineering, at Network Appliance. He has been designing and developing databases and database applications for more than 20 years and has been working with DB2 Universal Database and its predecessors since it was first introduced on the IBM PC. He has written articles for several magazines, authored DB2 tutorials for the IBM developerWorks Web site, presented at several international and regional DB2 user group conferences, taught classes on DB2 fundamentals and database administration, and is the author of nine books about DB2 and one book about ODBC. Roger is also a member of the DB2 Certification Exam development team and the author of a regular column (Distributed DBA) in DB2 Magazine.

• Roger E. Sanders

IBM Form Number
REDP-4251-00

Number of pages

42