Chapter 3: Overview of DB2 UDB V8
| < Day Day Up > |
Chapter 3: Overview of DB2 UDB V8
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-
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
| < Day Day Up > |
| < Day Day Up > |
3.1 DB2 UDB product family
The DB2 UDB family offers a database server for any application from very small to very large. The DB2 UDB runs on a variety of hardware platforms. It supports both 32-bit and 64-bit hardware including Intel and AMD based systems, IBM PowerPC server pSeries, iSeries, and zSeries.
IBM's DB2 UDB database software is
Figure 3-1:
DB2 UDB product overview
3.1.1 DB2 Everyplace
This database engine is designed to store and process data on mobile and embedded devices. It is a full relational database with a small footprint and a synchronization server.
3.1.2 DB2 Express
This is the newest member of the DB2 UDB product family. The key features include simplified deployment, autonomic management capabilities, application development support and design for 7x24 operation. This flavor of DB2 UDB is aimed at Independent Software Vendors (ISVs) who want to integrate DB2 UDB as part of their applications with low cost and have the capability to expand easily in the future.
3.1.3 DB2 UDB Personal Edition (PE)
This full-function database offering is for single-users and will not accept remote database
3.1.4 DB2 UDB Workgroup Server Edition (WSE)
This edition is designed for deployment in a departmental or small business environment that involves a small number of users. The WSE can be deployed in Linux, UNIX and Windows environments with up to four CPUs.
3.1.5 DB2 UDB Enterprise Server Edition (ESE)
ESE is designed to meet the database server needs of midsize to large businesses. The ESE can be deployed in Linux, UNIX, and Windows environments on any
| Note |
The DB2 UDB Database Partitioning Feature (DPF) is required in order to partition your DB2 UDB ESE database, either within a single server or across multiple servers. The DPF is license-only and does not require any additional products on top of DB2 UDB ESE to be installed on your database server to support database partitioning. |
| < Day Day Up > |