Performance Analysis and Tuning for DB2 UDB

This paper concentrates on DB2 UDB for distributed systems and is intended as an introduction to DB2 performance concepts for those with some experience of other DBMSs. Section 2 compares and contrasts DB2 UDB with Oracle. No attempt is made to assess their relative merits. The choice of DBMS must, of course, be driven by the application and end-user requirements in each case. Section 3 outlines the primary sources of DB2 performance and resource consumption data. The following four chapters form the bulk of the material covering memory management, physical data storage, indexing & sorting, and locking. The paper concludes with some important new features that will be provided in the upcoming new release of DB2.