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 9. 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 |
DB2 Universal Database 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 Universal Database Satellite Edition are managed centrally by the same server.
DB2 Universal Database Personal Edition is a single-user version of the full DB2 product. It contains:
DB2 Universal Database 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 Universal Database Enterprise Edition is designed for large databases with many users. It contains all the functionality of the Workgroup Edition, plus:
DB2 Universal Database 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 Universal Database 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 Universal Database Enterprise Edition, plus:
The following DB2 products are available for IBM midrange and mainframe systems: