3.1 DB2 UDB product family

---

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 full-featured, robust, scalable and easy to use. As the market share leader, DB2 UDB provides the foundation of information on demand on Linux, UNIX, Windows, and z/OS platforms (see Figure 3-1). DB2 UDB is specially designed and priced to meet your business needs whether large or small.

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 requests. This offering is available on Windows and Linux. DB2 Personal Edition only has a 32-bit version available.

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 size server. The ESE feature set, scalability, reliability, and availability provide the ideal foundation for building data warehouses, transaction processing, or Web-based solutions, as well as a back-end for packaged solutions like ERP, CRM, or SCM.

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.

---