DB2 UDB V8 and WebSphere V5. Performance Tuning and Operations Guide2004

Overview

In this chapter we introduce the architecture of DB2 UDB V8.1 to provide you with a basic understanding of how DB2 UDB is designed. It is easier to understand what you should think of when there is a need for tuning once you know the DB2 UDB architecture. After a short introduction to the architecture, we show you the key performance-related areas in DB2 UDB. We also introduce some tools that help you to monitor and optimize the database environment.

In this chapter we discuss:

• DB2 UDB product family for Linux, UNIX, and Windows platforms

• DB2 UDB architecture overview

  • Process model

  • Memory model

  • Storage model

  • Key performance related areas

• Tools