The name DB2 is used for relational database products that run on a variety of platforms.
DB2 Everywhere is a very small footprint database that runs on mobile devices, such as personal digital assistants (PDAs), smart phones, and handheld personal computers (HPCs). Each mobile device stores a subset of the data from an enterprise database, which it can use without the need for a continuous database connection.
DB2 Everywhere Sync Server, running on a mid-tier server, replicates the data in both directions between mobile devices and the enterprise database. For example, each worker in a loading dock might carry a PDA that is periodically synchronized with an inventory database on OS/390.
The following table shows which products are available on each
platform:
Table 18. DB2 Universal Database Platforms
| Edition | Windows 95/98 | Windows NT/ Windows 2000 | OS/2 | Linux | AIX | HP-UX | Solaris | PTX/NUMA-Q |
|---|---|---|---|---|---|---|---|---|
| Satellite | X | X | ||||||
| Personal | X | X | X | X | ||||
| Workgroup | X | X | X | X | X | X | ||
| Enterprise | X | X | X | X | X | X | X | |
| Enterprise - Extended | X | X | X | X | X |
| Note: | DB2 UDB Workgroup Edition, DB2 UDB Enterprise Edition, and DB2 UDB Enterprise - Extended Edition are commonly referred to as "servers" or "DB2 servers". Various clients are provided with each server product. |
DB2 UDB Satellite Edition is a single-user, small footprint version of DB2 available for Windows 32-bit operating systems. It is designed for occasionally connected remote systems, such as laptop computers.
Typically, many instances of DB2 UDB Satellite Edition are managed centrally by the same server.
DB2 UDB Personal Edition is a single-user version of the full DB2 product. It contains:
DB2 UDB Workgroup Edition is a multi-user version of the DB2 product, designed for a small business or departmental environment. It contains all the functionality of the Personal Edition, plus:
DB2 UDB Enterprise Edition is designed for large databases with many users. It contains all the functionality of the Workgroup Edition, plus:
DB2 UDB Enterprise - Extended Edition is designed for the largest databases. It is ideal for scaling to very large databases for warehousing, data mining, and large-scale OLTP applications. It contains all the functionality of the Enterprise Edition, plus:
Two special editions of DB2 are available for people who develop DB2 applications:
DB2 Personal Developer's Edition provides tools to help a software developer create applications for a DB2 Personal Edition database. DB2 Personal Developer's Edition contains all the functionality of DB2 UDB Personal Edition, plus:
DB2 Universal Developer's Edition provides the tools for developing client/server applications. DB2 Universal Developer's Edition contains all the functionality of DB2 UDB Enterprise Edition, plus:
The following DB2 products are available for IBM midrange and mainframe systems: