Performance Analysis and Tuning for DB2 UDB
Source: Metron Technology
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.