Which distributed edition of DB2, Version 8 is right for you?

This popular article is updated with the latest news in product features, editions, and licensing for IBM® DB2® Universal Database™ Version 8.2.3 up to and including the announcement of DB2 Express - C on January 30th, 2006. The author lays out the options and includes a quick reference that maps typical user environments to the suggested DB2 edition.

Paul ZikopoulosIBM Toronto Lab

Photo: Paul C. ZikopoulosPaul C. Zikopoulos, BA, MBA, is an award-winning writer and speaker with the IBM Database Global Sales Support team. He has more than nine years of experience with DB2 and has written numerous magazine articles and books about it. Paul has co-authored the following books: DB2 Version 8: The Official Guide, DB2 - The Complete Reference, DB2 Fundamentals Certification for Dummies, DB2 For Dummies, and A DBA's Guide to Databases on Linux. Paul is a DB2 Certified Advanced Technical Expert (DRDA and Cluster/EEE) and a DB2 Certified Solutions Expert (Business Intelligence and Database Administration). You can reach him at paulz_ibm@msn.com



23 March 2006 (First published 01 November 2002)

Introduction

Information management software is at the core of enterprise computing. Companies need access to a wide range of information such as XML, message queues, documents, streaming video, and other rich media types. The on demand evolution makes continuous availability a necessity and is driving the convergence of transaction, business intelligence, and content management applications as companies integrate their business operations and processes thereby transforming them to the on demand model.

The Information Management Software portfolio provides the foundation you need for providing information on demand, with support for structured, semi-structured, and unstructured data, federation, content management, rich run-time analytic capabilities, and much more. At the heart of the Information Management portfolio are the DB2 Universal Database (DB2) database servers, which are the focus of this article. Note that this article describes only the family of database servers that run on distributed and pervasive platforms. For information about the entire DB2 portfolio, see the Information Management Software Web site or each product's respective Web site: DB2 for z/OS® or DB2 for i5/OS™.

What's great in DB2 Universal Database Version 8

DB2 Universal Database Version 8 (DB2 V8) can help your organization meet the challenges outlined in the previous section. Whether your business is large or small, you need a database that can grow as your business needs grow. DB2 V8 is that database. It responds quickly to peaks in transaction demand on your Web sites, effortlessly expands to hold growing amounts of information distributed in a number of different databases, and grows with your information infrastructure from one processor to multiple processors vertically inside an SMP or horizontally across more nodes that you'd care to know (1000 to be exact, and more if you really needed it). The integration of data partitioning and clustering technology into DB2 Enterprise Server Edition means that it is flexible enough to meet any needs you may encounter.

It doesn't matter how big or small your business, from 'ma and pa' shops, to line of business departmental applications, to large scale mission critical functions of the enterprise: with the flexibility of DB2, you don't need to make all of your decisions today based on expectations of growth in the future - it's all about investment protection.

DB2 V8 includes free autonomic database technology (in every edition for that matter) that lets database administrators (DBAs) choose to configure, tune, and manage their databases with enhanced automation. Autonomic database management means that DBAs spend less time managing routine tasks and more time focusing on tasks that help businesses gain a sustainable competitive advantage. Ground breaking technology like multidimensional clustering of tables reduces the administrative workload of DBAs while providing automatic data clustering for fast queries. This means that you get better decision-making information sooner, with less system management overhead, and improved response times for your applications. DB2's innovative query rewrite, optimization technologies, and assisted configuration capabilities lead the industry, allowing you to spend more time analyzing business data and less time on manual performance improvement and tuning issues.

DB2 in the classroom

DB2 is also available under the IBM Academic Initiative Program. This program is designed to provide faculty and researchers at institutions of higher learning, worldwide, with a wealth of academic and research offerings, resources, and benefits from IBM. Under this program, DB2 can be used to teach database skills at no charge. Many educational institutions are teaching valuable DB2 skills today; for example, Pennsylvania (Penn) State University and Queen's University (Kingston, Ontario) have curricula that are centered around DB2 technologies.

The planned and unplanned availability capabilities in DB2 helps to ensure that your business applications are available whenever you need them. Online utilities like index rebuild, index create, and table load, as well as configuration parameters that can be changed without stopping the database instance, means improved levels of performance and high availability.

DB2 Version 8 delivers the right data management solutions for the new millennium. No other database management system provides the kind of advanced performance, availability, scalability, and manageability features found in the DB2 Version 8 release.

DB2 V8.2 picks up where DB2 V8 left off

DB2 V8.2 (formerly known as DB2 "Stinger") extends the powerful characteristics and features in the DB2 V8 release with a four-corner enrichment stategy.

First, application development on the DB2 platform gets another shot in developer productivity with plug-ins and tooling that are "for developers, written by developers". DB2 truly is the database for all developers. You choose the platform, the data access API, the integrated development environment (IDE), and we'll provide the best data platform and integration with your selection. It means that Linux/Eclipse developers are treated to a plug-in that assists in schema browsing and object creation. For more end-to-end productivity, Java™ developers can use the powerful and capable Rational® Application Developer IDE and expose DB2 schema and DB2 business logic (stored procedures, triggers, and so on) as Enterprise Java Beans (EJBs) with mere clicks of a button. Microsoft .NET developers will feel right at home with a full-feature plug-in that not only allows them to leverage tooling capabilities that SQL Server developers are waiting for in SQL Server 2005, but also anctipated functionality like Common Language Run-time (CLR) routines too. (Of course, DB2 has supported a rich development plug-in for Visual Studio.NET since DB2 V8.1.2 - and it just gets better in DB2 V8.2.) There's even something for open source programmers with the open source Apache Derby database and Zend Core for IBM that provides a feature rich development environment for DB2 PHP programmers.

Second, DB2 V8.2 also focuses on reducing deployment and management costs. For example, DB2 can automatically reorganize tables, collect statistics, and spawn backups based on log consumption without involvement of the DBA -- or simply notify the DBA that it's time this maintenance was applied. In addition to this, there are a host of new features that fall into the autonomic computing category; many of which are tremendous capabilities that are exclusive to DB2 (for example, the ability for our advisors to recommend up to 4 objects to enrich the database schema for your query workload). The DB2 V8.2 autonomic features are beyond just managing "helpers" - they also help improve the efficiency and integration of the database with other features (like including the log files within an online backup file).

The third cornerstone of DB2 V8.2 is a stronger, more robust, and more powerful infrastructure. With every version and point release, the development labs make advancements in the areas of availability, performance, and security - and DB2 V8.2 is no exception. In fact, as of the publication date of this article, DB2 is the world's fastest database in overall single system transactional throughput (as measured by The Transaction Processing Performance Council's TPC-C metrics) and the most cost effective transactonal database with respect to price performance. (DB2 holds many other benchmarks too; for example, various SAP metrics, TPC-H metrics, and more - however, this topic is out of the scope of this article.)

Finally, DB2 V8.2 extends the value of information with enhancements to replicaton, federation, and the new DB2 Geodetic Extender. It is obviously out of the scope of this article to go into all the new features in DB2 V8.2. For more information, I recommend visiting the developerWorks DB2 V8.2 page. In addition to this, Chris Fierros' "Doing More With More" article in the Quarter 3, 2004 version of DB2 Magazine provides an excellent high-level overview of the key features in DB2 V8.2.

The DB2 V8.2.2 (also known as Fix Pack 9) extends upon the ease-of-use foundation and delivers a host of features that boost performance. This release was inspired by SAP, but you don't need to be an SAP customer to benefit from it (think of it as SAP doing the requirements work for you). For more information on DB2 V8.2.2, read the 3 part series on the new features in DB2 V8.2.2 by starting at: "What's new in DB2 V8.2.2 (Part 1): Overview, licensing, packaging, and administrative enhancements" (developerWorks, June 2005).

It is easy to arrive at the decision to use DB2, however, there are different editions of DB2 (and respective licensing options) that are well suited for different parts of the marketplace. From Palmtop to Teraflop, there's a DB2 that's right for you.

I originally wrote this article to help you decide which distributed DB2 edition you want to use to power up your business - over time, this has morphed into a reference. It still helps you figure out the different editions, but details licensing and product changes (as well as some major feature evolution) on a marginal basis between FixPacks, Updates, and Point Releases. If you need packaging and licensing information that is more to the point, check out the articles I reference at the end of this section.

In this article, I'll cover the different DB2 editions that are available for deployment on the distributed platforms, and for the most part, how they are licensed, what they include, what they don't include, and so on. This article is designed so that you can jump to various editions and read about the sequential changes from FixPak or Update to subsequent FixPak or Update (which accounts for its length). This gives you, the reader, an easy way to see the delta between the different FixPaks and Updates. It would take too long to detail all of the new function and features within each Fix Pack or Update; therefore, with respect to functions and non-packaging related items, I'll only comment on those that are the a major source of client questions I receive at various speaking engagements.

When talking with customers, I often get asked a lot of high availability licensing questions, or feature comparisons between the different editions of DB2 or DB2 Connect. For details on these topics and more, other articles I've written may be helpful:


DB2 is DB2 is DB2

The first thing that you should understand when choosing an edition of DB2 to service your workload is that, with the exception of DB2 Everyplace® and Apache Derby/IBM Cloudscape™ (whose SQL API is fully compatible with DB2), each DB2 edition has the same code base across all the distributed platforms. DB2's support for Linux extends across all of IBM's servers: iSeries®, System z®, xSeries®, and pSeries® -- the DB2 on all of these platforms is the distributed version too. For example, DB2 for Linux on System z is the same code base and licensed the same way as DB2 on an Intel or AMD-based workstation (which means DB2 Connect is required even though the DB2 for Linux on System z database server resides on a zSeries server), and so on. A common code base offers portability and assurances that if you ever need to scale your DB2 solution, you can do so seamlessly without regard to database costs, platform, or migration efforts.

Figure 1 shows an architectural view of DB2 across the supported distributed platforms.

If you ever decide to change your strategic direction with respect to a hardware archictecture (for example, from an Intel-based architecture to a Power 5 one), operating system (like moving from Windows® to Linux™), or programming architecture (like .NET to Java or vice-versa), you can count on the fact that DB2 will be there. Quite simply, it's all about choice and DB2 is literally the only database in the world that really gives you the breadth and depth of a database platform tailored to your environment.

Figure 1. DB2 has common code across Windows®, Linux (on iSeries, pSeries, System z, and xSeries), and UNIX.®
DB2 is DB2 is DB2 across Windows, Linux, UNIX

The different editions of DB2 are shown in Figure 2. With the exception of DB2 Everyplace and IBM Cloudscape/Apache Derby, you can assume that each function, feature, and benefit of an edition shown in the bottom of Figure 2 is included in each subsequent edition as you move up the 'edition chain' -- kind of like a Russian Doll.

Figure 2. The distributed DB2 product line
The distributed DB2 product line

Changes from DB2 Version 7.2

In Version 8, DB2 is no longer offered on the OS/2® or NUMA-Q/PTX® servers. DB2 V7.2 was supported on these platforms until September 30th, 2004 (although you can still purchase a service extension). IBM has announced a whole new unified support structure for IBM software. For a complete list of the end of service dates for all IBM software products, see the IBM Support Web site.

DB2 Version 8: What's In a name?

In the past, maintenance and new features have been delivered throughout a version release through FixPaks. FixPaks were released more or less quarterly, and could contain any number of maintenance fixes or features. In DB2 V8.1, a new nomenclature and approach to periodic maintenance and feature delivery has been implemented. This new naming convention is the first step in clearly identifying feature-based and maintenance-based ship vehicles.

To help distinguish feature-oriented ship vehicles from fix-oriented ones, downloads that deliver mainly maintenance and fixes to a DB2 installation are still referred to as FixPaks (FPs). Those that focus on new features are called Updates. At times, a FixPak will ship new features, but for the most part, the naming convention used will follow these guidelines.

FixPaks and Updates are not neccessarily planned for delivery in an 'every-other' fashion - but will often follow that pattern. All shipped vehicles are cumulative in nature. Therefore, applying FixPak 3 also gives you the V8.1.2 Update and FixPak 1.

The numbering convention from a naming perspective will follow such that both the modification level and the FixPak are part of the sequence number. For example, FixPak 1 is V8.1.1 and it was followed by an Update which was V8.1.2 (what some people would still call FixPak2), followed by FixPak 3 which is V8.1.3, followed by the V8.1.4 Update (which some people still call FixPak 4), and so on (though remember, IBM could ship two conecutive FixPaks or Updates). An example is shown in Figure 3.

Figure 3. DB2 updates and FixPaks
DB2 updates and FixPaks

You can download FixPaks and Updates from the DB2 Technical Support site. (I've detailed the naming conventions in this section so that you can better understand IBM communications about DB2 mainteance - some Web sites may still use the old nomenclature.)

Non-specific packaging changes since DB2 Version 8.1

In this section I'll detail some of the changes that affect all of the DB2 editions since the general availability date of DB2 V8.1. Some of this information is repeated in the subsequent sections which focus on the DB2 line-up from an individual edition perspective. However, I wanted to highlight some key features, packaging, and platform highlights that apply to all of the distributed DB2 servers here.

Changes in FixPak 1

There were no major features or packaging changes in this FixPak.

Changes in DB2 Version 8.1.2 (also known as FixPak 2)

DB2 V8.1.2 added full support for the Windows Server 2003 platform, including 64-bit servers on Intel Itanium-based workstations. DB2 was technically previewed on 64-bit Windows on AMD-based workstations and was working closely with Microsoft to support this architecture (it is supported as of DB2 V8.2.2) for a very long time - essentially, we were waiting for Microsoft to officially support their 64-bit model on this architecture. The DB2 V8.1.2 Update also added support for 64-bit instances on Linux machines running on Intel Itanium processors, as well as support for DB2 for Linux servers on all the IBM eServer machines (iSeries, pSries, xSeries, and System z).

Although it is out of the scpe of this article to detail each and every new feature that accompanies DB2 Updates and FixPaks, I'll note that this Update included the introduction of the Visual Studio.NET plug-in and a native DB2 .Net Managed Provider. Subsequent Updates and FixPaks extend this functionality (for example, FixPak 3 added support for Visual Studio.Net 2003) and added further performance enhancements that are not fully detailed in this article.

In addition to this, DB2 Express, the DB2 Data Warehouse Editions, and DB2 Query Patroller became generally available.

Changes in FixPak 3

The major platform change in FixPak 3 was the added support for 64-bit DB2 for Linux instances that run on an AMD Opteron-powered server architecture.

Changes in DB2 Version 8.1.4 (also known as FixPak 4)

DB2 V8.1.4 has some significant packaging changes that are discussed throughout this article. Specifically, DB2 Everyplace Enterprise Edition has a lower price point, a new processor-based licensing option was made available for DB2 Express Edition, and the new DB2 Mobility on demand feature was added to all DB2 servers.

In addition to this, a 64-bit version of Query Patroller was shipped for UNIX-based servers, as well as a host of interesting new features like Range Clustered Tables, backup compression, new SQL features like INSERT OVER, and more.

Changes after DB2 Version 8.1.4 but before FixPak 5

Although not part of the DB2 V8.1.4 Update, a build of DB2 for Hewlett Packard's Intel 64-bit processor powered servers (HP/IA64) was introduced. This edition of DB2 was based on the V8.1.4 code base, but aligns with the mainstream build stream in subsequent FixPaks and Updates.

Changes in FixPak 5

Since this was a maintenance focussed vehicle, there isn't a lot of new funtion in this FixPak. However, it is worth noting that the OLE DB to .NET bridge was officially supported at this point in the DB2 release cycle. In addition to this, support for DB2 Connect for Linux on zSeries 64-bit instances was added.

Changes in FixPak 6

Since this was a maintenance focussed vehicle, there isn't any new features or packaging/licensing changes in this deliverable. However, it is worth noting that this is an example where two subsequent FixPaks were shipped in a row without an Update installation between them.

Changes in DB2 Version 8.2 (also known as FixPak 7)

In DB2 V8.2, 64-bit support for all Linux distributions was been added. This means that no matter what hardware architecture you choose for your DB2 for Linux server, you can leverage the extended memory model that a 64-bit environment provides. In addition to this, a 64-bit version of DB2 V8.2 for Linux supports Intel's new EMT64 32-bit/64-bit hybrid chipset and AIX 5.3 support became official.

For Windows customers, a new DB2 Run-Time Client Lite was been added. This new client provides two important benefits. First, for customers that need to enable a large number of Windows desktop for DB2 server connections, it provides a convenient way of deploying DB2 drivers (ODBC, CLI, OLE DB, the DB2 .NET Data Provider, JDBC, and SQLJ) with little effort and impact on the network. Second, for application developers that want to provide a complete out-of-the-box solution for their customers, IBM now provides a redistribution license that allows an ISV to package these drivers as part of their application and distribute them at no extra charge and without the need for custom agreements or contracts with IBM (it is even available as Microsoft Merge Modules, so adding it to your application is as simple as clicking a button).

The DB2 Run Time Client Lite contains the absolute minimum file set (outside of using the DB2 JDBC Type 4 driver) for DB2 connectivity and is designed with mass deployments on the Windows platform in mind. For example, the DB2 Run-Time Client for Windows is about 80 MB, the DB2 Run-Time Client Lite for Windows is about 12 MB. In addition to this, a new utility called db2iprune can be used to reduce the size of any Windows-based image so that it only contains the filesets that you require. (I included mention of these DB2 V8.2 enhancements since they affect packaging with respect to deployment options.)

For application developers that make Java their architectual choice, you'll be happy to know that the Java Common Client (also refered to as the DB2 JDBC Universal Driver - which includes both JDBC Type 4 driver and SQLJ enablement), is now available with a royalty free redistribution license. This means that ISVs and customers can use this lightweight Java client (it's only about 2 MB in size) for Java connections without having to install a DB2 client.

Changes in FixPak 8

Although the images were made available on January 28th, 2005 (shortly after this FixPak was made generally available), this FixPak delivers 64-bit instance support to all DB2 server editions at no extra charge. For example, this means that a DB2 Express on Windows server can leverage a 64-bit memory addressability model for high performance applications. Keep in mind however that both DB2 Express and the DB2 Workgroup Edition Servers have server memory limitations which you still must adhere to. In addition to this, the ability to run a 32-bit instance of DB2 on an AMD 64-bit processor was made available for Windows (it already existed for Linux).

Changes in DB2 V8.2.2 (also known as FixPak 9)

This update of DB2 was inspired by SAP and provides a number of autonomic, concurrency, and scalability enhancements that all DB2 users will appreciate. This technology was used to break a world record TPC-C benchmark on a 4-way SMP server.

Changes in FixPak 10

This FixPak was a maintenance release, so there isn't really any new function here. However, it's worth noting the following packaging changes:

  • DB2 now supports the V11.23 release of HP-UX on PA-RISC.
  • The platforms that Query Patroller can run on has been expanded to include 64-bit Linux on X86-64 platforms (both Intel EM64T and AMD Opteron) and Linux for i5/OS and Power-based deployments.
  • A new version of DB2 Connect called DB2 Connect Unlimited Edition for iSeries is available, giving environments that seek an unlimited deployment license for i5/OS and AS/400 bound connections from distributed workstations a very cost effective option.
  • A 31-bit version (there is no 32-bit memory model on System z) of the DB2 Run-Time Client is available on Linux for zSeries. Previously, only the 64-bit version was available on this platform.

While there were no significant features added to this FixPak, there was a very significant change in the area of licensing. DB2 ESE can now be licensed on a per user basis using the new authorized user license. The new authorized user license is different than the named user and registered user models used by DB2 Express and DB2 Workgroup Server Editions respectively in that it doesn't require an associated server license. This greatly simplifies the licensing of DB2 ESE for environments where per user pricing is appropriate. The details of this new license are covered in the DB2 Enterprise Server Edition section.

Changes in FixPak 11

This FixPak was a maintenance release, so there isn't really any new function here. However, it's worth noting that integration of DB2 into the Microsoft Visual Studio 2005 and Microsoft .NET 2.0 framework environments has been made available in a special Developers Release.

Changes after FixPak 11

A freely downloadable version of DB2 called DB2 Express-C was made available. DB2 Express-C is a special version of the DB2 Express Edition offering that's designed to provide an up-and-running in minutes, full-featured, self-maintaing database environment. More details on this new package are available in the DB2 Express-C section, later in this paper.


DB2 Everyplace

The true power of mobile computing lies not in the device itself, but rather in its ability to tap into data from other sources. DB2 Everyplace brings the power of DB2 to mobile devices, leveraging their ability to synchronize data with other systems - literally putting your enterprise data in the pockets of your mobile workforce and giving them the ability to update your data from the field (even in an occasionally connected environment).

DB2 Everyplace is more than just a mobile computing infrastructure. It's a complete development environment that includes the tools you need to build, deploy, and support powerful e-business applications. DB2 Everyplace features a tiny "fingerprint" engine (about 250 KB) which is packed full of security features like table-level and wire-level (including SSL) encryption and advanced indexing techniques that lead to high performance. It can comfortably run on a wide variety of handheld devices, with support for Palm OS, Microsoft Windows CE/PocketPC/Windows Mobile, Microsoft Windows 32-bit operating systems (such as Windows XP and Windows Tablet PC Edition), Symbian, QNX Neutrino, Java 2 Micro Edition (J2ME) devices like RIM's Blackberry pagers, embedded Linux distributions (for example, BlueCat Linux), and more. The SQL API used to develop DB2 Everyplace applications is a subset of that used in DB2, so this means that enterprise applications, for the most part, can be easily extended to include mobile devices.

DB2 Everyplace is very simple to use - users do not need any database management skills as it is 100% self managing. DB2 Everyplace is also extremely flexible for developers, with support for Open Database Connectivity (ODBC), Java Database Connectivity (JDBC), .Net, and the DB2 Call Level Interface (CLI) APIs.

Licensing and pricing

DB2 Everyplace can be licensed as a fully synchronized environment or as a stand-alone embedded database. DB2 Everyplace comes in three editions: DB2 Everyplace Database Edition, DB2 Everyplace Express Edition (new as of DB2 V8.1.4), and DB2 Everyplace Enterprise Edition.

DB2 Everyplace Database Edition has no synchronization middleware to extend data to backend enterprise servers, although it does come with command line-based Import and Export utilities. DB2 Everyplace Database Edition is primarily used for applications that require an embedded database or a local relational storage facility that is exposed to endusers through some sort of application (they never really see the database). There is special OEM pricing available to encourage OEMs and ISVs to develop applications based on DB2 Everyplace. Please contact your IBM representative for these special rates.

DB2 Everyplace Express Edition was added to the packaging lineup in DB2 V8.1.4 - it's functionality the same as DB2 Everyplace Enterprise Edition (differences are licensing restrictions in that is it limited to the DB2 Everyplace Synchronization Server running on an SMP server with no more than two processors; this product can be licensed on a per user basis along with a base server charge too, just like DB2 Express Edition).

A DB2 Everyplace Enterprise Edition license provides customers with an unlimited number of DB2 Everyplace database engines to deploy on their mobile devices for synchronization with the accompanying DB2 Everyplace Synchronization Server, which handles synchronization between DB2 Everyplace and IBM Cloudscape/Apache Derby databases with your corporate back-end databases. The list price for DB2 Everyplace Enterprise Edition was reduced by 25% in DB2 V8.1.4 from its original DB2 V8.1 price level.

DB2 Everyplace can synchronize data to any JDBC-compliant database (that is, all editions of DB2, Oracle, Informix, SQL Server, and so on) and members of the DB2 family through a native DB2 family adapater that uses the Data Propagator replication technology (which is free in the distributed version of DB2). The number of concurrent synchronizations a DB2 Everyplace Synchronization Server can support is dependent on the hardware configuration of that server, the associated workload, and data change rates. With that said, the DB2 Everyplace Synchronization Server comes with a built-in application server that you can use to manage data transfer. If you need to scale to handle very large concurrent synchronizations, you can install any Java application server (like IBM WebSphere Application Server).

The licensing rules associated with DB2 Everyplace Enterprise Edition provides a framework such that you don't have to worry about who is using what, or where, or who installed or uninstalled the software, and so on. A DB2 Everyplace Enterprise Edition license is more consistent with the "no need to count users" approach that most Internet-based applications now use for pricing.

Consider it....

If you need a relational engine (and perhaps synchronization services) on a mobile device with limited resources (for example, a PDA or a mobile phone), you likely need to use DB2 Everyplace. However, this product should also be considered for occasionally connected mobile users on laptops, if their applications don't need advanced features (like triggers or stored procedures) that are not part of the DB2 Everyplace engine, yet require a "black box" database on their machines or PDAs (you don't want merchandisers having to collect statistics or build indexes).

If you need to leverage a richer featured database that supports triggers, stored procedures, etc., and have devices or workstations capable of running Java, you may also want to consider IBM Cloudscape/Apache Derby which has a footprint of about 2 MB. IBM Cloudscape/Apache Derby databases can act as a synchornization client, back end data store, or both in a DB2 Everyplace environment.

Changes from DB2 Everyplace Version 7.2

DB2 Everyplace Enterprise Edition used to be licensed with a base processor license, plus an additional charge for each deployed device that synchronizes through the DB2 Synchronization Server. The DB2 Version 8 licensing terms for DB2 Everyplace Enterprise Edition allow for an unlimited deployment of engines on mobile devices by eliminating the need to count individual users with its altered processor license.

Changes in DB2 Everyplace Version 8.1.4

The most significant change to DB2 Everyplace product packaging and pricing in DB2 V8.1.4 was the addition of DB2 Everyplace Express Edition. DB2 Everyplace Express Edition is a member of the IBM Express family which means it has passed strict guidelines with respect to ease of use, setup, and so on.

DB2 Everyplace Express Edition uses a licensing model that is consistent with DB2 Express Edition. It is designed to provide an attractive price point for smaller installations, while still providing a full function mobile data solution. Mobile database users are licensed individually as registered users, along with a base server charge. DB2 Express Edition truly opens up leading-edge application deployments to all businesses -- big and small.

DB2 Everyplace Express Edition can be deployed in Linux or Windows environments on systems with up to two CPUs. Complete server-based synchronization capability is included with support for data sources such as DB2, Informix®, Domino®, and other JDBC-based data sources including Oracle, Microsoft, IBM Cloudscape, Apache Derby, and Sybase.

In DB2 V8.1.4, IBM introduced a new option for enabling mobile computing and data management called DB2 Mobility on demand. DB2 Mobility on demand is the combination of the DB2 Everyplace database and the DB2 Everyplace Synchronization Server. It is offered as part of any DB2 server at no extra charge and allows for the deployment of the DB2 Everyplace components in the same fashion that the DB2 server is licensed (provided the data and transactions on these devices are synchronized through the DB2 server that delivered the function - more on this in a bit).

Changes in DB2 Everyplace Version 8.2

There were no major packaging or platform changes in this point release, but there were a number of new features. It's worth noting that the DB2 Mobility on demand feature was added to all DB2 Conect servers, allowing DB2 for OS/390 and z/OS and DB2 for i5/OS and OS/400 users to extend their applications to mobile devices at no extra charge.

The DB2 Everyplace pricing model as of DB2 V8.2.3 is summarized in the table below. However, depending on your needs, you may want to investigate obtaining this product through a DB2 purchase: in many cases, it will save you money and give you a full-featured database at the same time.

Figure 4. DB2 Everyplace pricing model
DB2 Everyplace pricing

DB2 Personal Edition (DB2 PE)

DB2 PE is a single user RDBMS that runs on desktop-based commodity hardware. DB2 PE is available on Windows ME, Windows NT® (SP6 or later), Windows 2000 (SP2 or later recommended), Windows XP, Windows Server 2003, and Linux on Intel/AMD-based workstations. DB2 PE has most of the features that you'll find in DB2 Workgroup Server Edition, but it can not be used as a database server (for example, remote clients cannot connect to databases that are running this edition of DB2). However, workstations with the Control Center can connect to these databases to perform remote administration. This edition of DB2 also includes support for 64-bit instances (assuming the underlying operating system has a 64-bit memory model available to it) and has no memory limits.

Apache Derby and IBM Cloudscape Version 10

At Linux World 2004, IBM announced that it has donated the IBM Cloudscape code to the Apache Software Foundation as the Apache Derby database. This open source database is available at no cost and can be repurposed and used for profit. IBM Cloudscape is the open source Apache Derby code, and also available at no extra charge, but comes with an optional (it's chargeable) support contract and various proprietary add-ons like an ODBC driver, the DB2 Java Common Client, and more. The Apache Derby SQL API is fully compatable with the DB2 for Linux, UNIX, and Windows servers, making it a seamless transition if or when you need to rely on a functionally richer database management system. Learn all about Apache Derby and IBM Cloudscape at the Developer Works Web site.

Because DB2 is built on a common code base, applications that are developed for DB2 PE will run on any other edition of DB2. DB2 PE is often a good choice for developers to build applications for any DB2 server before rolling them out into a production environment, for pseudo-mobile environments that require a full-featured enterprise-class database, point-of-sale machines, and so on.

Licensing and pricing

DB2 PE is licensed very much like most PC workstation software. In other words, each workstation where the product is installed must be licensed. If multiple users were using the same workstation where the DB2 PE database was installed, you would still only require one license.

DB2 PE is also available at no charge for developers and ISVs through DB2 Personal Developers Edition (PDE). Don't forget that developer-based editions of DB2 are restricted to the development, evaluation, demonstration, and testing of application programs. DB2 PDE provides users with all the flavors of DB2 PE, plus connectivity options to mainframe-based DB2 data with the inclusion of DB2 Connect PE and additional extenders.

Consider it....

DB2 PE is an excellent choice for applications that require a personal single-user data store for a large number of PC workstations. Consider DB2 PE over DB2 Everyplace and IBM Cloudscape/Apache Derby when 100% compatibility with the distributed DB2 servers is required beyond the SQL API and into specific features (like MDC tables and so on). Also consider DB2 PE for occassionally connected environments.

Occasionally connected users may want to take advantage of DB2 PE's built-in replication feature and the DB2 Control Server to set up a synchronized environment where mobile workers or remote servers can keep in touch with their enterprise. Of course, this would only be suitable for laptop users and certain workstations, such as those running point-of-sale (POS) applications.

DB2 PE also comes within the DB2 Warehouse Center, allowing users to perform key business intelligence processes like extract, transform, and load (ETL) operations. It also includes SQL-based replication and READ/WRITE federation support to any DB2 family member and Informix IDS. DB2 PE is extensible with support for most of the DB2 Extenders®: XML (now bundled into a DB2 installation as of V8), Spatial, and Net Search.

Changes from DB2 Version 7.2

DB2 PE is now more extensible. The XML Extender is part of the installation (as it is for all DB2 installations). DB2 PE can create 64-bit instances, and can be used with the DB2 Spatial and Net Search Extenders (in fact it comes with free copies of these Extenders). The functionality in DB2 Satellite Edition has been moved to DB2 PE, which makes it well suited for the occasionally connected user who needs a richer feature set engine than what DB2 Everyplace offers.


DB2 Express-C

On January 30th, 2006, IBM announced a special free version of DB2 Express edition called DB2 Express-C. You'll note that I refer to this as a version, as it's not an edition of DB2. DB2 Express-C was designed for the partner and devleopment communities, but as you get to know this version, you'll start to realize it has applicability almost anywhere. Unlike some of our competitor Express offerings that have non-production limits on RAM, parallelism, database objects, autonomics, automated maintenance, the memory bit model, high availability, and more, as you investigate this version of DB2, you will become pleasantly surprised. In fact, DB2 Express-C is perfect for developers and small and medium deployments, academic communities, and more.

In a nutshell, DB2 Express-C has all the resiliency and robustness of DB2 Express, but without some of the extended features with the fee-based DB2 Express offering.

Features that are not included in DB2 Express-C include:

  • Data Warehouse Manager
  • Ability to install DB2 Connect on top of it
  • Various DB2 Extender support
  • APPC and NetBIOS protocol support
  • Capability to run HADR
  • Replication
  • Informix Data Source Replicaton and Federation support
  • 24x7 IBM Passport Advantage support model

If you want to leverage any of these features in your environment, you need to at minimal purchase DB2 Express Edition.

DB2 Express-C can be installed on any server with up to two dual-core processors (including Linux on pSeries, for example). That provides your application with up to four cores of processing power, double the amount that competitors' offerings currently provide. With DB2 Express-C you can leverage a 64-bit memory model, which isn't available in some of our competitors' offerings either. In addition to this, you find no database limits, no object limits, no parallelism limits for utilities or query, no automated management limits, no instance limits, and more -- generally it's just DB2. This isn't the case when you look beneath the marketing of the Oracle and SQL Server 2005 Express Editions. However, this is outside the scope of this article.

One key difference with DB2 Express-C is that it doesn't come with the award winning 24x7 telephone support that the purchasable editions of DB2 come with. Don't get that confused with maintenance -- all Fix Paks for this product are free. The DB2 Express-C support model lies within the strength of its community. Part of this community are some of the worlds most experienced DBAs from the world's largest companies (and small ones too), and a legion of DB2 developers and engineers monitoring your questions. You can tap into this rich community at:https://www.ibm.com/developerworks/forums/dw_forum.jsp?forum=805&cat=19.

DB2 Express - C is available on the same platforms available for DB2 Express. For Linux, this means (for the most part): x86 (32-bit), x86_64 (32-bit and 64-bit), IA64 (64-bit), PPC (Power 32-bit), PPC64 (Power 64-bit) architectures. For Windows, it is available on the following architectures: x86 (32-bit), x86_64 (32-bit and 64-bit), IA64 (64-bit). A complete list of supported platforms is available at the IBM DB2 Express forum.

Developers will love DB2 Express-C because it allows them to develop and deploy applications free. And remember, since DB2 Express-C is DB2, it means that you can deploy these applications on any edition of DB2 and even move them to DB2 for z/OS with no changes (assuming you write your applications to the 90+% common SQL API set for DB2). Like the rest of the DB2 server family, DB2 Express-C has leading application development plug-in support for .NET and Visual Studio (including ADO.NET 2.0 and Visual Studio 2005), Java and the Eclipse-based Rational Application Developer product, and PHP and Zend Studio. In addition to this, developers can learn or leverage DB2 Express-C's support for Service-Oriented Architecture (SOA) technologies that are built into DB2.

In the academia world, educators have an opportunity to extend the value of the DB2 Scholar's program, which offers them access to DB2 technlogy for free by having their students used DB2 Express-C free. There's a whole support community built for DB2 Express-C installation that you can leverage to further explore databsae technologies.

Ever wonder what the C stands for in DB2 Express-C? Me too! But with all the features that come in this version of DB2 Express, it could stand for a number of things like:

  • Community support
  • Choice of operating system, architecture, and development API
  • Costless deployment
  • Compact footprint
  • Common open standards-based engine and business logic engine
  • Cee all the things you can do with a full featured database

Want to test drive DB2 Express-C for yourself? Download a copy today.

Licensing and pricing

DB2 Express-C is free for use and download. Subsequently there is no licensing or pricing associated with this version of DB2.

Consider it....

DB2 Express-C can be used for a wide array of different applications and projects -- especially since it has so many features that are available in the chargeable DB2 editions and not available in competitive Express projects.

Specifically, DB2 Express-C is well suited for:

  • Developers that want to get up and running quickly and start developing with no costs. They can choose the development environment and IDE that best meets their needs, be it J2EE, PHP .NET, SOA, and more.
  • ISV and business partners that want to increase busines flexibility and product value without incurring upfront costs. Investments into DB2 Express-C for their applications are protected as the DB2 family (which is a seamless migration) extends the reach of propective clients to virtually any IT environment.
  • Mid-market solution providers who want no upfront licese fee for their small-medium business (SMB) sized applications that can use a self managing database for data persistence.
  • Academic community for faculty and students to get direct access to software that is not limited for classroom use only. Furthermore, educational materials are available on Web sites like Developers' Domain.

DB2 Express Edition

DB2 Express Edition is an offering that became generally available on May 1st, 2003. DB2 Express Edition is an entry level database server that is a specially tailored low cost, full feature, industrial strength, and open industry standards-based relational database. The target users of this edition of DB2 are SMBs (small and medium businesses) and ISVs.

DB2 Express Edition provides a very attractive entry and competitive price point for businesses that choose to leverage the benefits of inexpensive servers running Linux on AMD, Intel, Power-based (as of DB2 V8.2) or Windows-based servers. It can be installed on servers that have no more than 2 CPUs. On January 28th, 2005 as part of Fix Pak 8 (although the images were made available shortly after) 64-bit instance support was added to this edition of DB2 (although it has a memory limite of 4 GB).

DB2 Express Edition also provides a wide selection of business partner applications, services, and support. There is an accompanying set of pricing programs that partners can leverage to generate significant revenue flows into their businesses. Of course, businesses can choose to deploy DB2 Express for their own environments as well - and often do.

Because it is a full-fledged DB2 server at its core (you won't find all sorts of technical restrictions here as you will with other competitor offerings), DBAs can leverage its built-in autonomic manageability features such as IBM's self-tuning optimizer, the Configuration Advisor, the Health Center, autonomic maintenance plans, and more. These tools help to increase the performance and reliability of a DB2 solution, while at the same time minimizing administration complexity, required skills, and overall total cost of ownership.

DB2 Express Edition supports high availability architectures like clustering technologies, log shipping, and the new High Availability Disaster Recovery (HADR) option that's new in DB2 V8.2. Taking into account that other popular SMB-targeted databases only have advanced high availability functions in their Enterprise-based editions, and combining that with its price point and autonomic capabilities, you may never even know DB2 Express is there - and that includes your pocketbook!

This edition of DB2 is fully compatible with the rest of the scalable DB2 family of relational databases for Linux, Windows, and UNIX platforms. Business partners can pre-configure DB2 Express Edition to transparently install within their applications for easy deployment in customer engagements. Customers will love it because all they see is a solution; Business partners will love it because they can trust it to run virtually unattended.

DB2 Express Edition supports the following key capabilities and benefits:

  • Easy to install and deploy. The database installs silently within your application,and has autonomic features that minimize complexity, skills requirements, and resource for installation and management. DB2 Express Edition unobtrusively installs itself within applications and can be easily pre-configured in offerings for key vertical markets such as finance, insurance, retail, and so on.
  • Accelerates time to value. Easily integrates with applications and comes with IBM's PartnerWorld® support structure that enables faster time to market for chosen solutions.
  • Lowest price full-function database. DB2 Express Edition is very competitively priced to meet the needs of today's challenging budgets while at the same time, refuses to compromise key functions like high availability, materialzied query tables, and so on.
  • Avoids lock-in with a single vendor. DB2 Express Edition is based on open industry standards, and is portable across Linux (Intel/AMD/Power-based workstations) and other platforms.
  • Protects your existing investment. There is no need to "rip-and-replace" because DB2's open standards and federation capabilities give you faster, more effective insight into your data across multiple platforms and data stores.
  • Scalable on demand. As your business grows, so can the underlying database.
  • Development freedom. You choose the data access API and IDE, and DB2 will provide rich and integrated tooling within the native environment.

For complete details on the differences between DB2 Express and the other DB2 servers, read "Comparing the distributed DB2 servers".

Licensing and pricing

A DB2 Express Edition server can be licensed through a processor entitlement (as of DB2 V8.1.4), or an environment where users are named (there is no concurrent pricing model for DB2 Express Edition - all users must be identifiable). With the named user model (which is analogous to DB2 Workgroup Server Edition's registered user license), a DB2 Express Edition base server license must be acquired, as well as additional licenses for each registered user. For example, if you wanted to license DB2 Express Edition for 5 users, you would need to pay for a single base server license, plus an additional 5 named user licenses for these 5 users.

As of DB2 V8.1.4, DB2 Express Edition can also be licensed using a processor entitlement. This option alleviates the need to count or know your users. DB2 Express also supports high availability licensing. There are special considerations that you should be aware of when licensing DB2 Express in a high availability environment. Refer to Licensing Distributed DB2 Version 8 Servers in a High-Availability Configuration for more information.

DB2 Express Edition (as of DB2 V8.2) has a memory limitation of 4 GB on the server, but can support 64-bit instances as of January 28th.

DB2 Express Edition customers are also entitled to the DB2 Everyplace components, through the DB2 Mobility on demand feature, in a manner that is consistent with the way they have licensed their DB2 Express Edition server. For example, if you licensed your DB2 Express database server for one processor, you can deploy DB2 Everyplace on an unlimited number of mobile devices, and the DB2 Everyplace Synchronization Server on the same machine where the copy of the DB2 Express Edition license you purchased resides. All of your DB2 Everyplace databases must be synchronized through this server.

Consider it...

DB2 Express Edition is an entry level DB2 server that should be considered for workloads that can be accommodated on inexpensive Linux and Windows 2-CPU servers that have 4 GB or less of memory on the server.

More specifically, DB2 Express Edition has many possibilities for a wide variety of customers and is especially well suited for:

  • Integrated Solution Vendors (ISV) whose applications run on a Linux or Windows-based server and require a quiet, secure, yet powerful "behind-the-scenes" scalable database to power their solutions.
  • Anyone who needs a database server on a Linux or Windows-based workstation for small to medium workloads and need all the power and flexibility of an industrial strength database (like high availability, parallelism, and so on).
  • Anyone who wants to deploy a mobile solution to a line of business or an small-medium business (SMB) shop.

Changes in DB2 Version 8.1.4

A new processor licensing option was added to DB2 Express Edition. This allows you to not have to identify, name, and license each user that will connect to or use the database. Instead, as with traditional processor license-based models, your DB2 server is licensed for unlimited connections. Before this update, you could only license DB2 Express Edition for InTERnet applications if you could identify a specific user. Today, you can still use the named user license of Web-based applications where you can fully identify the user (for example, an online banking applications). But for the most part, the processor license is the best aproach for Web-based applications that need to access data in a DB2 Express Edition database.

Although not a change in licensing, there are some perceived misconceptions about DB2 Express Edition's licensing terms and DB2 Connect. You can purchase and install any server edition of DB2 Connect (DB2 Connect Personal Edition does not qualify here) and install it on a DB2 Express Edition server for connections to iSeries- and zSeries-based DB2 databases. For more information on how to license DB2 Connect, refer to "Which edition of DB2 Connect is right for you?."

DB2 Mobility on demand

A new feature included in all DB2 servers -- DB2 Mobility on demand -- was added and is available free of charge with any DB2 server as of V8.1.4 (this feature is also included with any DB2 Connect server as of DB2 V8.2).

DB2 Mobility on demand includes the complete DB2 Everyplace mobile database with a server-based synchronization architecture that supports data sources such as members of the DB2 family, Informix, Lotus Domino, IBM Cloudscape, Apache Derby, and other vendor's JDBC-enabled databases including: Oracle, Microsoft, Sybase, and so on.

Although free, the DB2 Mobility on demand feature must be licensed in the same manner as the DB2 server (or DB2 Connect server as of DB2 V8.2) upon which it is installed. (Hint: In many cases, it may be cheaper to actually buy a DB2 server than to separately purchase a DB2 Everyplace solution.)

Quite simply, the DB2 Mobility on demand licensing terms entitle you to use DB2 Everyplace and its components for any users you have licensed for your DB2 server. For example, if you purchased a DB2 Express Edition server and licensed it for ten named users, you could deploy copies of DB2 Everyplace to those ten users, on a myriad of pervasive devices, and synchronize their data to your back-end data store. In this scenario, the DB2 Everyplace Synchronization Server and the DB2 Express Edition server must be collocated on the same box - unless of course you have other DB2 licenses.

Changes in DB2 Version 8.2

As noted in the previous section, the DB2 Mobility on demand feature has been extended to DB2 Connect. For example, if you bought a DB2 Connect Enterprise Edition server, you would be licensed to collocate the DB2 Everyplace Synchronization Server on the same server where the DB2 Connect software was installed and deploy DB2 Everyplace databases across your enterprise.

As of DB2 V8.2, DB2 Express for Linux can be installed on an AMD/Intel-arhictected system, as well as iSeries and pSeries (Power-based) servers. Before DB2 V8.2, support for DB2 Express on Linux was solely limitd to AMD/Intel-based servers.

DB2 V8.2 introduced a new feature called High Availability Disaster Recovery that can literally provide a zero-transaction loss turnkey high availability environment. This product is free with DB2 Enterprise Server Edition, but can be additionally purchased for a DB2 Express Edition server on a per processor basis. Even if your DB2 Express Edition server is licensed using a named user metric, you must license the HADR add-on product using a processor license.

DB2 V8.2 also introduces a memory limitation for the server box that hosts a DB2 Express Edition server. As of DB2 V8.2, you can only have a maximum of 4 GB of RAM on the hosting server.

The DB2 Spatial Extender, which provides spatial analysis and data geodcoding features for DB2 databases is now provided free of charge for DB2 Express servers (previously this was a priced add-on product).

To simplify and enhance high availability, DB2 Express Edition for Linux V8.2 comes with a free 2-node license of Tivoli System Automation for Linux (TSA4L). TSA4L provides failover support (amongst other things) for DB2 for Linux servers. TSA4L is similar to clustering software available on other platforms (for example: AIX HACMP, SUN Cluster, Windows Cluster Server, etc.) - it looks for a heartbeat, can recover from one system to another, and so on. This is a chargeable product, but with DB2 V8.2, we give a copy of it away for free with all DB2 servers (not just DB2 Express Edition) which is limited to a maximum of 2-node clusters. Specifically, TSA4L provides:

  • Mainframe-like high availability for Linux applications through policy-based self-healing.
  • Increased efficiency and Linux application availability with policy-based healing characteristics.
  • Reduced coding and support efforts.
  • Reduced complexity by operations at the application level, not at the resource level.

Changes in DB2 Fix Pak 8

64-bit instance support was added to DB2 Express - there is no cost for this option. Additionally, 32-bit instances on a 64-bit X86 chip was now supported.

Changes in DB2 Verson 8.2.2

64-bit instance support for Windows on AMD and Intel (X86) chips is now supported.


DB2 Workgroup Server Edition (DB2 WSE)

DB2 WSE is a DB2 server that provides the same features as the DB2 Express server but is designed for higher demand workloads that need the power of 4-CPU systems and performance improvements possible with larger amounts of memory (up to 16 GB - a new restriction as of DB2 V8.2) and can also leverage a 64-bit memory model (as of January 28th, 2005 with Fix Pak 8). DB2 WSE is a full function client/server RDBMS. It is available on all supported flavors of UNIX (AIX, Solaris, and HP-UX - both Intel and PA RISC), Linux, Windows NT (SP6 or later), Windows 2000 (SP2 or later recommended), Windows XP, and Windows Server 2003.

DB2 WSE provides a low cost entry-level database server that is intended primarily for small business and departmental computing. It is functionally equivalent to DB2 ESE with the exception that there is no integrated mainframe connectivity (through the DB2 Connect component that comes with DB2 ESE), it does not include HADR (though you can buy this as an add-on), and has some limits with respect to extensibility (for example, it doesn't support DB2 Data Links File Manager). As previously stated, an application written for any edition of DB2 is transparently portable to other editions on any distributed platform. For complete details on the differences between DB2 WSE and the other DB2 servers, read "Comparing the distributed DB2 servers."

Licensing and pricing

DB2 WSE can be installed on machines that are powered by a maximum of a 4 CPU servers for UNIX, Linux, and Windows-based installations. DB2 WSE can only be licensed by the Client-to-Server model using either an optional concurrent (sometimes referred to as capacity) or registered (this term is synonymous with the DB2 Express named user license) user license.

The concurrent user license is appropriate for applications or devices that have established a connection to one or more databases on one server. A user with multiple connections to a single server counts as only one concurrent user. The one exception is the case where multiple connections are made by a multiplexing program, application server, or other program that connects to DB2, and provides access on behalf of other users. In this case, you have to consider the concurreny of users before the concentration of the connection. For example, imagine having fifty users accessing a database through IBM WebSphere Application Server which inturn makes connections to DB2 using a single connection ID. Since those connections are really being concentrated to one ID, you are still responsible to license all fifty of them. You cannot license a concurrent user for Internet or Intranet access.

In the concurrent user model, you must ensure that each server is licensed for the maximum number of users that will use that server product at any one time. A base service license must be purchased, as well as additional concurrent user licenses that define the capacity of the server. For example, if you had 100 employees in your company, but only 20 had connections to the database at any one time, you would be required (so long as they were not accessing the database over the Internet), 1 DB2 WSE server license and 20 concurrent user licenses.

A registered user license can be used with DB2 WSE when each user of the database is well known. Again, a base server license must be purchased, however, each user now must be identified and accounted for. These licenses are not transferable. Each registered user license grants access to any DB2 WSE server that is licensed through the registered model in the enterprise (each of those servers need DB2 server licenses however). For example, if you had three different DB2 servers, and ten users that needed access to all three of them, you would need to purchase 10 registered user licenses along with the 3 DB2 WSE base server licenses.

DB2 WSE customers are also entitled to the DB2 Everyplace components through the new DB2 Mobility on demand feature in a manner that is consistent with the way they have licensed their DB2 WSE server.

Consider it....

DB2 WSE can play many roles in a business. It is very appropriate for small to medium businesses that need a full-fledged relational database store that is scalable and available. It is also useful for enterprise environments that need "silo" servers for lines of business applications, or for departments that need the ability to scale in the future. It is not appropriate for InTERnet (access outside a company's firewall) Web-based usage because its licensing options do not allow for it; the exception may be a special case of a registered user that is identifiable - like an online tracking system for a company's supply chain.

For the most part, if you want an SMB-targetted edition of DB2 for use over the Web, you should consider DB2 Workgroup Server Unlimited Edition (DB2 WSUE). Again, because the DB2 code is common, applications built on DB2 WSE can run on any edition of DB2. DB2 WSE should also be strongly considered for departmental mobile data application deployments where the number of users can be counted, or it is not administratively prohibitive to do so.

Changes from DB2 Version 7.2

DB2 WSE can now run on a 4-way CPU UNIX-based server. In DB2 V7.2, the limit for UNIX processor-based servers was 2 CPUs. In addition to this, the Internet processor license is no longer available for this offering (you should use DB2 WSUE instead). All licensing for DB2 WSE V8 must be through the registered or concurrent user model.

In addition to this, OS/2 and NUMA-Q/PTX are no longer supported platforms.

Changes in DB2 Version 8.1.2

The licensing terms that went along with the DB2 WSE Version 8 release stated that a DB2 Connect server could not be installed on a DB2 WSE server. This was incorrect and was subsequently removed from the licensing agreement in this release.

Changes in DB2 Version 8.1.4

DB2 server customers could now freely extend their solutions to include mobile data by leveraging the new DB2 Mobility on demand capability available with the DB2 V8.1.4 Update. This feature gives free access to the high performance, robust, and scalable DB2 Everyplace database engine (and its associated bullet-proof synchronization solution) for use with the licensed DB2 WSE server deployment. The free-of-charge entitlement for DB2 Mobility on demand is the same as the license purchased for the underlying DB2 server. For example, if you purchased a DB2 WSE server and licensed it for fifty registered users, you could deploy fifty copies of DB2 Everyplace on a myriad of pervasive devices and synchronize them to a back-end data store after installing the DB2 Everyplace Synchronization Server on the same licensed DB2 WSE server.

Changes in DB2 Version 8.2

DB2 V8.2 introduces a new feature called the DB2 High Availability Disaster Recovery (HADR) Option that can literally provide a zero-transaction loss turnkey high availability environment. This product is free with DB2 Enterprise Server Edition, but can be additionally purchased for a DB2 WSE server on a per process basis. Even if your DB2 WSE server is licensed using a registered or concurrent user metric, you must license this add-on option using a processor license.

DB2 V8.2 also introduces a memory limitation for the server where DB2 WSE is installed. As of DB2 V8.2, you can only have a maximum of 16 GB of RAM on the hosting server

To simplify and enhance high availability, DB2 WSE V8.2 for Linux comes with a free 2 node license of Tivoli System Automation for Linux.

As of DB2 V8.2, you could optionally purchase DB2 Query Patroller for a DB2 WSE server (previously, it was only available for DB2 ESE servers). This product is licensed on a per processor basis and shares the same licensing considerations that a DB2 WSE server does with the HADR Option detailed earlier in this section. In addition to this, DB2 Query Patroller was also made available for 64-bit databases on Linux- and Windows-based systems, in addition to the 64-bit UNIX-based systems supported since DB2 V8.1.4 (although you couldn't leverage a 64-bit memory model on this edition of DB2 until January 28th, 2005 with Fix Pak 8).

Finally, the DB2 Spatial Extender was provided free of charge for DB2 WSE users. Previously, a trial license with a limit of 5 registered users was provided and if you wanted to support more users, you had to buy the DB2 Spatial Extender and a DB2 Workgroup Server Unlimited Edition or DB2 Enterprise Server Edition server.

Changes in DB2 Fix Pak 8

64-bit instance support was added to DB2 Workgroup Edition - there is no cost for this option. Additionally, 32-bit instances on a 64-bit X86 chip was now supported.

Changes in DB2 Verson 8.2.2

64-bit instance support for Windows on AMD and Intel (X86) chips was supported.


DB2 Workgroup Server Unlimited Edition (DB2 WSUE)

DB2 WSUE is really DB2 WSE with different licensing terms. For a complete description of the functionality available with this product, see the DB2 WSE section.

DB2 WSUE can only be licensed with a processor entitlement and is the right choice for small to medium businesses that want to use the Web to conduct and accelerate business or find it inconvienent (or impossible for that matter) to count users.

Licensing and pricing

A processor license enables DB2 WSUE to serve up Internet and Intranet requests that come to the database manager through an application server without consideration for the number of users, if they are concentrated, how they got there, and so on. This licensing model eliminates the need to count users accessing the database.

DB2 WSUE customers are also entitled to the DB2 Everyplace components, through the new DB2 Mobility on demand feature, in a manner that is consistent with the way they have licensed their DB2 WSUE server.

Consider it....

DB2 WSUE differentiates itself from DB2 WSE with the availability of a processor-based license. IT managers will typically look at this edition of DB2 if they need to serve up DB2 data over the Internet or Intranet, but do not need the added functions, features, and benefits of a DB2 Enterprise Server Edition (DB2 ESE) solution, or are using servers with less than or equal to 4 processors. DB2 WSUE should also be strongly considered for department-sized mobile data applications where the number of users cannot be counted, or it is administratively prohibitive to do so.

Changes from DB2 Version 7.2

DB2 WSUE used to have a 4-way CPU UNIX and an 8-way CPU Intel/AMD server restriction with respect to the number of processors used on the hosting server. The INTEL/AMD processor limit has been lowered to 4, so that it is identical to DB2 WSE. The processor license had a price reduction of almost 50%!

Changes in DB2 Version 8.1.2

The licensing terms that went along with DB2 WSUE when the Version 8 release became generally available stated that a DB2 Connect server could not be installed on a DB2 WSUE server. This was incorrect and was subsequently removed from the licensing agreement in this version.

Changes in DB2 Version 8.1.4

DB2 server customers could now freely extend their solutions to include mobile data by leveraging the new DB2 Mobility on demandfeature available with the DB2 V8.1.4 Update. This feature gives free access to the high performance, robust, and scalable DB2 Everyplace database engine, and its associated bullet-proof synchronization solution, for use with the licensed DB2 server deployment. The free-of-charge entitlement for the DB2 Mobility on demand feature is the same as the license purchased for the underlying DB2 server. For example, if you installed a DB2 WSUE server on a 4-way SMP server, you could deploy as many DB2 Everyplace databases as you want (since it is a processor-based license) and have them synchronize through this same server to back-end data stores.

Changes in DB2 Version 8.2

DB2 V8.2 introduced a new feature called the High Availability Disaster Recovery (HADR) Option that can literally provide a zero-transaction loss turnkey high availability environment. This option is free with DB2 Enterprise Server Edition, but can be additionally purchased for a DB2 WSUE server on a per processor basis.

As of DB2 V8.2, you could optionally purchase DB2 Query Patroller for a DB2 WSUE server (previously, it was only available for DB2 ESE servers). This product is licensed on a per processor basis. DB2 Query Patroller was also made available for 64-bit databases on Linux- and Windows-based systems, in addition to the 64-bit UNIX-based systems supported since DB2 V8.1.4 (although this edition of DB2 doesn't support 64-bit instances until January 28th, 2005 with Fix Pak 8).

DB2 V8.2 also introduced a memory limitation for the server box that hosts a DB2 WSUE server. As of DB2 V8.2, you can only have a maximum of 16 GB of RAM on the hosting server.

To simplify and enhance high availability, DB2 WSUE for Linux V8.2 comes with a free 2 node license of Tivoli System Automation for Linux.

Finally, the DB2 Spatial Extender was provided free of charge for DB2 WSUE users. Previously, you had to buy the DB2 Spatial Extender for use with this edition of DB2.

Changes in DB2 Fix Pak 8

64-bit instance support was added to DB2 Workgroup Server Unlimited Edition - there is no cost for this option. Additionally, 32-bit instances on a 64-bit X86 chip was now supported.

Changes in DB2 Verson 8.2.2

64-bit instance support for Windows on AMD and Intel (X86) chips is now supported.


DB2 Data Warehouse Standard Edition (DB2 DWSE)

Note: Refer to DB2 Data Warehouse Enterprise Edition (DB2 DWEE) for complete details on this package. This section only covers the packaging differences between DB2 DWEE and DB2 DWSE.

DB2 DWSE is intended for small to medium size businesses that want to deploy data warehouses or data marts. DB2 DWSE includes the following products:

All of these DB2 data warehousing oriented products are also available as separately licensed features of DB2.

Licensing and pricing

DB2 DWSE is charged on a per processor basis and includes the use of any of its packaged components. If you were to add up the cost of all the DB2 products included in this package, you would see that DB2 DWSE offers all of these products at over an 80% discount of the retail price. Because this package comes with a copy of DB2 WSUE, you are also entitled to the DB2 Mobility on demand feature.

Consider it...

Consider this product when you need to build a data warehouse or data mart of small to medium size and complexity. This will often occur for small and medium sized business, departmental deployments, IT developer systems, or business partner developer systems.

Changes Between DB2 FixPacks, Updates, and Point Releases

Refer to the changes for DB2 WSUE for complete details. In DB2 V8.2, the Alphablox reporting toolkit was added to this package.


DB2 Enterprise Server Edition (DB2 ESE) and the Optional Database Partitioning Feature

DB2 ESE is IBM's full function premier Web-enabled client/server RDBMS. It is available on all supported flavors of UNIX (AIX, Solaris, and HP-UX - including HP-IA64), Linux, Windows NT (SP6 or later), Windows 2000 (SP2 or later), and Windows Server 2003. DB2 V8 ESE does not run on Windows XP for production purposes, but can be licensed for user acceptance testing, test, and application development on this platform (this restriction is in accordance with Microsoft's direction for this operating system and therefore applications running on a Windows XP box can be adequetly serviced by DB2 Express, DB2 WSE, or DB2 WSUE servers).

DB2 ESE is meant for large and mid-sized departmental servers. In addition to the functionality provided by DB2 WSUE, DB2 ESE includes 5 free registered users for DB2 Connect which enables you to connect to iSeries- and zSeries-based DB2 databases, as well as non-database host resources like CICS, VSAM, and IMS (note that these 5 free users are for actual people and cannot be attributed to programs, batch jobs, and so on). Connectivity to zSeries- and iSeries-based data provided by the DB2 Connect component of the DB2 ESE server is ideal for certain data replication scenarios, and some remote administration work. For application workloads that need access to zSeries- and iSeries-based data, a DB2 Connect product (not the DB2 Connect component of DB2 ESE) should be purchased and installed.

DB2 ESE has the ability to partition data within a single server or across multiple servers "out of the box" with the Database Partitioning Feature (DPF). While this capability is available with DB2 ESE, it must be properly licensed by purchasing the optional Database Partitioning Feature license for every CPU that will be used by the partitioned database.

In DB2 Version 5, the DB2 Common Server code base merged with DB2 Parallel Edition to become DB2 Universal Database. In DB2 V6 and V7, the clustering (for scalability) feature of DB2 was offered as a separate DB2 edition called DB2 Enterprise - Extended Edition (DB2 EEE). This was largely a packaging decision because DB2 EE and DB2 EEE always shared the same code base and functionality. In DB2 V8, the clustering for scalability capability delivered by DB2 V7 EEE comes in the DB2 ESE installation. It merely needs to be licensed through the DPF option.

DB2 ESE supports 64-bit instances, all extensible add-ons like Data Links File Manager, security plug-ins, and the connection concentrator (which is critical for high volumne Web-like transactional systems - this feature is not available on any other edition of a DB2 server), and more.

In short, there are no restirctions what-so-ever with this edition of DB2 In fact, this edition was used to set the world record TPC-C single system benchmark (over 3,000,000 tpmC) using 2 TB of memory!

Licensing and pricing

DB2 ESE can be licensed by a processor entitlement or an authorized user license (which is new as of DB2 V8.2.3). No matter how you license your DB2 ESE server, there is no limit to the number of processors (or memory) that you can use.

DB2 ESE should be used for businesses that require premier scalability, accessibility, availability, and extensibility features and want to satisfy data requests through either the Internet or Intranet, or that have so many users that it is more practical to purchase a processor license. This is the DB2 edition of choice for most enterprises. In addition to this, DB2 ESE also support subcapcity pricing which allows you to leverage the latest partitoining capabilities of today's hardware.

DB2 ESE also supports different maintenance levels of the same release of DB2 for UNIX and Linux-based systems (in other words, you can have multiple FixPaks and Updates on the same machine - this feature is only available with DB2 ESE on UNIX and Linux-based workstations).

Consider it....

DB2 ESE is a great option for IT managers that want to leverage all the capabilities of their data environments without compromise.

DB2 ESE with the DPF gives you the ability to partition your database across multiple computers (which all have to be running on the same operating system). This means that your databases can grow to sizes that are limited only by the number of computers you have. DB2 ESE with the DPF is meant for larger data warehouses and for online analytical processing (OLAP) workloads, or for high performance complex online transaction processing (OLTP) requirements. DB2 ESE with the DPF also allows multiple SMPs to be clustered together under a single database image for very large-scale volumes.

As of the DB2 V8.1.4 update, DB2 ESE should also be strongly considered for extensions of enterprise applications to pervasive devices.

For developers only

For application development, a special offering called DB2 Universal Developer's Edition (DB2 UDE) is available. This is a reduced price offering that gives application developers access to the DB2 Extenders and all flavors of DB2 and DB2 Connect. DB2 UDE is licensed on a per developer basis and is restricted to the development, evaluation, demonstration, and testing of application programs.

In DB2 V8.2, the Data Partitioning Facility was added to this edition of DB2.

Changes from DB2 Version 7.2

The functionality of DB2 EEE is now part of DB2 ESE and merely needs to be licensed through an additional licensing of the DPF option. This means that if you want to cluster together multiple DB2 ESE servers for scalability, you don't need to install any additional code.

The complimentary DB2 Connect functionality has been extended to five registered users per server. Additional usage will require the purchase of a separately licensed DB2 Connect server. In DB2 V7, you got one free connection per licensed processor, with the ability to purchase additional connections if required; this is no longer the case in DB2 V8.

Changes in DB2 Version 8.1.2

DB2 server customers can now freely extend their solutions to include mobile data by leveraging the new DB2 Mobility on demandcapability available with the DB2 V8.1.4 Update. This feature gives free access to the high performance, robust, and scalable DB2 Everyplace database engine (and its associated bullet-proof synchronization solution) for use with the licensed DB2 server deployment. The free-of-charge entitlement for the DB2 Mobility on demand feature must be deployed in the same manner of the underlying DB2 server. For example, if you purchased a DB2 ESE server using the processor metric, you could deploy an unlimited number of installations of DB2 Everyplace, but you would be required to synchronize through this specific DB2 ESE server. In contrast, if you licensed your DB2 ESE server using the authorized user metric (new as of DB2 V8.2.3), you could only deploy DB2 Everyplace on those authorized user's devices (and of course all synchronization work would have to be performed by your licensed DB2 ESE server).

Changes since DB2 Version 8.1.4 but before Version 8.1.5

As of December 12th 2005, a copy of DB2 ESE was made available for HP-UX IA64. For more information, see: http://www.ibm.com/software/data/hp/ega.html

Changes in DB2 Version 8.2

DB2 V8.2 introduces a new feature called the High Availability Disaster Recovery (HDAR) Option. HADR provides a turnkey zero-transaction loss availability environment. This feature is free with DB2 Enterprise Server Edition (it still needs to be licensed correctly according to DB2's high availability pricing rules).

To simplify and enhance high availability, DB2 ESE for Linux V8.2 comes with a free 2 node license of Tivoli System Automation for Linux.

The DB2 Spatial Extender is now provided free of charge for DB2 ESE users. Previously, you had to buy the DB2 Spatial Extender. There is also a new richer featured spatial analysis tool called the DB2 Geodetic Extender. This extender can be additionally purchased on a per processor basis. The DB2 Geodetic Extender is designed for applications where curvature of the Earth is of vital importance. Examples include geological explorations and military applications.

A security plug-in feature is available free-of-charge (it isn't available for use with any other edition of DB2). This plug-in allows your to write customized authentication schemes for DB2. For example, you could write a plug-in to leverage LDAP authentication, or any GSS API compliant mechanism. In addition to this, the DPF feature is now included in DB2 Universal Developer's Edition (DB2 UDE).

Changes in DB2 Verson 8.2.2

64-bit instance support for Windows on AMD and Intel (X86) chips was supported.

Changes in DB2 Verson 8.2.3

The DB2 ESE pricing options have been expanded beyond the per processor metric to include a new per user pricing metric called an authorized user.

An authorized user license is somewhat similar to the DB2 Express named user and DB2 WSE registered user licenses in that they are used to identify specific individuals that access the DB2 ESE software. Authorized user licenses cannot be multiplexed or concentrated into a single ID (if you are using this kind of software, you have to name the actual users before such activities occur), and so on.

When licensing a DB2 ESE server with an authorized user license, you must license all of the users that will access the server software or a minimum of 25 users per processor on the server that hosts the DB2 ESE server (whichever is greater). For example, if you installed DB2 ESE on an 8-way server and you had 100 users, you would need to purchase 200 authorized user licenses because of the minimum amount of users that must be licensed for each processor in this model. For high availability environments, assuming you are licensing an idle standby server, you need to only license 25 users (the equivalent of 1 processor, which is consistnent with DB2's high availability pricing model). For more information about licensing DB2 ESE with an authorized user license in an high availability environment, read "Licensing distributed DB2 Universal Database (DB2) Version 8 servers in a high availability environment" by Paul Zikopoulos.

If you are using the DPF feature for scalability clustering, you cannot use the authorized user model to license your DB2 ESE+DPF environment. You must use the per processor metric.

Although the authorized user license is similar to other per user licensing metrics in the DB2 family, there are some significant differences that can yield terrific benefits to IT environments where appropriate. For example:

  • There is no requirement for a base server license. Unlike the named and registered user metrics with DB2 Express Edition and DB2 WSE Edition respectively (which require you to license all users and an additional server license), the authorized user metric solely requires identification of users. There is no additional base server license to buy.
  • Unlike named and registered user licenses, authorized user licenses can be used for InTERnet connections (outside your company's firewall) as long as you can identify each and every user of the database software. For example, an online high-value wealth application could be an ideal candidate for such a license since each banking client enters their unique CIN (customer identification number) and corresponding PIN (personal identification number) to gain access to the system. This gives IT departments a very flexible trade-off between the economics of low-use systems, and the ability to not worry about users (using a processor license).

DB2 Data Warehouse Base Edition (DB2 DWBE)

Note: Refer to DB2 Data Warehouse Enterprise Edition (DB2 DWEE) for complete details on this package. This section only covers the packaging differences between DB2 DWEE and DB2 DWBE.

DB2 DWBE is intended for businesses that want to deploy data warehouses or data marts. DB2 DWSE includes DB2 Enterprise Server Edition server and DB2 Cube Views.

DB2 DWBE provides mid- to large-scale enterprises with a database warehouse and data mart infrastructure that includes DB2 ESE and integrated OLAP capability that can support departmental warehouses or lines of business, or enterprise data warehouses where there is a need for scalability and performance with speed of thought-like response times.

All of the products in DB2 DWBE are also available separately.

Licensing and pricing

DB2 DWSE is charged on a per processor basis and includes the use of any of its packaged components. If you were to add up the cost of all the DB2 products included in this package, you would see that DB2 DWSE offers all of these products at a very significant discount of the retail price. Because this package comes with a copy of DB2 ESE, you are also entitled to the DB2 Mobility on demand feature.

Consider it...

Consider this product when you need to build a data warehouse or data mart and you want to leverage OLAP capabilities without the burden of a MOLAP engine.

Changes Between DB2 FixPacks, Updates, and Point Releases

Refer to the changes for DB2 ESE for complete details on changes with the DB2 server included in this package.


DB2 Data Warehouse Enterprise Edition (DB2 DWEE)

DB2 Data Warehouse Enterprise Edition (DB2 DWEE) combines a carefully selected set of DB2 business intelligence (BI) features to provide a comprehensive BI platform with everything needed by customers to deploy, and partners to build, the next generation of analytic solutions. DB2 DWEE ensures that a complete set of features are always available for building data warehouses, including the RDBMS, ETL, OLAP, data mining, and simple query.

Underlying database objects in DB2, such as multidimensional clustering (MDC) tables, materialized query tables (MQTs), and the DPF feature, provide a scalable environment that makes this database engine the one to deliver on fast query execution. BI-focused infrastructure technologies that are driven deep into the DB2 engine are exposed through open standard interfaces such as SQL, PMML, and XML. The advantage of this is that they inherit attributes from DB2 such as parallelism, high availability, security, distributed processing, and any new innovations, but are available to a wide array of application development methodologies.

DB2 DWEE includes a product first introducted in the DB2 V8.1.2 time frame called DB2 Cube Views. This product enhances analytical productivity in the relational engine. DB2 Cube Views allows database administrators (DBAs) to model multidimensional summary tables in the database once, and reuse them everywhere. With its open framework, you can alternatively model cubes in a chosen design tool and import that model into DB2. The DB2 Cube Views topology is shown in Figure 5.

Figure 5. DB2 Cube Views metadata management
DB2 Cube views

DB2 Cube Views gives the ability to model hierarchical relationships in summary tables that deliver very fast response times. An advisor wizard is included to assist the designer in building the multidimensional summary table. The benefits of this capability is to allow high speed summary reporting that leverages DB2 parallelism plus the ability to share rollup report designs through metadata with popular query and reporting tools such as Brio, Cognos, MicroStrategy, or Business Objects, and more.

The end result is MOLAP-like speed and flexibility from first class relational database objects without any need to install, manage, and program to a separate MOLAP engine.

DB2 DWEE includes the following products:

  • DB2 Enterprise Server Edition 8.1
  • Data Partitioning Feature (DPF)
  • DB2 Cube Views
  • DB2 Intelligent Miner Modeling, Visualization, and Scoring
  • Native drivers (from DB2 Information Integrator) are included for use with Warehouse Manager for ETL operations
  • DB2 Office Connect Web Enterprise Edition
  • DB2 Query Patroller
  • DB2 Warehouse Manager Standard Edition
  • Alphablox

Most of these products are also available separately for the different editions of DB2.

In short, DB2 DWEE delivers fundamental architectural advantages with a platform-neutral model underscored by proven linear scaling, with a unified real-time data warehouse engine, all wrapped in a comprehensive BI platform that includes support for OLAP, mining, statistical analysis, transformation, federation, and replication. Learn more about DB2 DWEE at: http://www.ibm.com/software/data/bi/.

Licensing and pricing

DB2 DWEE is charged on a per processor basis and includes the unlimited use of any of its packaged components on the machine for which it is licensed for use. If you were to add up the cost of all the DB2 products included in this package, you'd find that DB2 DWEE offers all of this software at a more than 60% discount. Because this package comes with a copy of DB2 ESE, you are entitled to the DB2 Mobility on demand features that are are included in that package as well (like HADR, Mobility-on-Demand, and so on).

Consider it...

DB2 DWEE is the choice for building a medium to large data warehouse with a design that is of moderate to high complexity. This all-inclusive portfolio of products ensures that DBAs and developers have all the necessary components to develop CRM-analytics (things like consumer segmentation and cross-sell prediction), supply chain inventory analysis (like category management and inventory forecasting), financial analysis (like profit analysis, business performance metrics), and much more.

Changes in DB2 Version 8.1.4

Query Patroller is now available for 64-bit databases on UNIX-based systems.

Changes in DB2 Version 8.2

Query Patroller is now available for 64-bit databases on Linux- and Windows-based systems, in addition to the 64-bit UNIX-based systems supported since DB2 V8.1.4.

Additionally, Alphablox was added to the package to provide a reporting infrastructure for your applications.


Miscellaneous packaging changes

This section describes various differences in packaging and pricing between DB2 Version 8 and DB2 Version 7.2.

  • DB2 Net Search Extender (DB2 NSE) V7 and DB2 Text Information Extender V7 have merged into DB2 Net Search Extender V8, with the richer searching features of DB2 Text Information Extender V7 now part of DB2 NSE V8. For linguistic searches, you must still use DB2 Text Extender V7, which is part of the DB2 Net Seach Extender package. If you had DB2 V7, you will get a free copy of DB2 Net Search Extender V8. For new customers, DB2 Net Search Extender V8 is a chargeable feature.

    The Net Search Extender is shipped with DB2 WSE with a 5-user limit for free. If you wish to exceed this limit, you will need to upgrade the server to DB2 WSUE or DB2 ESE and acquire a DB2 NSE processor licenses. DB2 PE customers will also receive a single user copy of this product. DB2 Express does not come with a limited use license for DB2 NSE and cannot be used with this product. A new product called WebSphere Information Integrator Omnifind is now available - think of it as Google for your enterprise.

  • The DB2 OLAP Starter Kit is no longer shipped with editions of DB2.
  • The DB2 Data Warehouse Center that is shipped as part of the free data warehousing tools with DB2 is now available on AIX as well as Windows.
  • DB2 Relational Connect and DB2 Life Sciences Data Connect are not offered with DB2 Version 8. These features are now included in IBM WebSphere Information Integrator.

Changes in DB2 Version 8.1.2

When DB2 became generally available, its published terms and conditions indicated that a DB2 Connect server could only be installed on a DB2 ESE server. This was never the intention of the licensing terms, and the misleading text was updated in the DB2 V8.1.2 licensing terms. This restriction will not be enforced. In addition to this, the charge for the MSU unit in DB2 Connect Unlimited Edition has been reduced by a whopping 90%. To learn more about DB2 Connect, check out "Which edition of DB2 Connect is right for you?" (developerWorks, September 2005) by Paul C Zikopoulos and Leon Katsnelson.


Conclusion

As you can see, DB2 not only runs on many platforms, but also has many packaging options that allow you to choose the right edition for your business. DB2 V8 introduces more flexible and cost effective deployment options. These options go hand in hand with a host of new functionality that not only cuts the time to value of a DB2 solution but also makes DB2 the most effective database management system available today.

Scaling DB2 is seamless from edition to edition, and this gives you the ability to leverage your DB2 investment as your business grows. Whether you are an SMB tracking sales over the Internet, a mobile solutions provider, or a Fortune 500 company trying to analyze sales data to put the right products into the right hands at the right time, there is an edition of DB2 that's right for you!


Quick reference

Table 1 briefly describes some business scenarios mapped to the DB2 product that is a "best fit" for each scenario. Use this table as a quick guide to determine which DB2 edition is right for you.

Table 1. Choosing the right distributed edition for you
ScenarioSuggested DB2 Edition
A municipal agent who issues parking tickets has a need to store and retrieve data on a mobile device. The agent needs to record information that relates to each ticket issued. Once information is entered into the system, a ticket can be printed. When the agent returns to his home office, he prints out all the tickets that he has issued that day for consolidation with the enterprise database. Technical requirements for this solution include an embedded database, a small footprint for the mobile device, and no need for database maintenance.DB2 Everyplace Database Edition or IBM Cloudscape
A financial company wants to deliver Wealth Management services to all of its customers over the Web. Downloadable software (that embeds DB2 Everyplace) will be available that runs on PDAs, laptops, cellular phones, and so on. This software will be used by each client to track individual portfolios. The financial company does want to count the users that download and use the software.DB2 Everyplace Enterprise Edition or IBM Cloudscape
A traveling insurance agent requires access to insurance quotation data. She has an application that accepts information as input and then generates a quote for a policy. The agent has no idea that DB2 is installed on the system, and that her application and data must be periodically updated. The agent operates in an occasionally connected environment.DB2 Everyplace Database Edition, IBM Cloudscape, or DB2 Personal Edition
The application that the agent in the previous scenario uses must now be able to leverage all of the features and functionality of DB2 (including triggers, stored procedures, and so on). Some agents will operate in an occasionally connected environment in which backend data consolidation is automatic, and other agents will manually consolidate their data.IBM Cloudscape or DB2 Personal Edition
You are a developer that wants a free database that is self managing and tuning, yet suitable and feature rich enough for production. In addition to this, you may require seamless portability to a fully supported database in the future.DB2 Express - C
You own a small company with around 1,000 employees and have an application that runs on Windows that the entire sales force of 40 must access. DB2 Express or perhaps even DB2 Express - C
You are an ISV or IBM Business Partner that makes or resells software on Linux and Windows. You are concerned about the effect an outlay of high database costs has on your bottom line as you try to seed your applications in the marketplace. You need software that powers your solution, has the flexibility to run on the operating systems that dominate your environment, but comes at a minimized upfront cost. DB2 Express or DB2 Express - C
A developer wants to download and develop applications for DB2. She wants to build these applications only on Linux or Windows, and understands that DB2 applications are portable between different editions of DB2. She does not need to test for connectivity.DB2 Personal Developer's Edition
A business operates in multiple locations across the country. Each location has a point-of-sale (POS) workstation that records transaction information. This information is fed into a data warehouse at the end of each week. Some form of remote management is needed for these POS workstations, because local employees do not have database skills.DB2 Workgroup Server Edition
A small-to-medium business wants to sell widgets over the Internet. They do not expect thousands of Web hits per day, but require the reliability and performance of an enterprise database solution. They want to have the option of growing into a more scalable solution if the business thrives.DB2 Workgroup Server Unlimited Edition
You are a business that wants to leverage OLAP in your environment. In fact, chances are you use some hyrbid tool like Cognos or Microstrategies to power up your data mart or warehouse. You want a a strong engine that is OLAP aware, without requiring the administration and costs of a separate MOLAP engine.DB2 Data Warehouse Base Edition
You are a small to medium business that wants to deploy a small to medium data mart or warehouse. You want a complete BI foundation (process) from ETL operations through integration of the front-end analytic tools. You need to quickly build and deploy line-of-business analytical applications or data marts to help the business become more dynamic and agile, but you'd also like to establish a comprehensive platform for BI to deploy increasingly sophisticated BI solutions (involving data mining) over time. Essentially you want it all for as little cost as possible.DB2 Data Warehouse Standard Edition
A company wants to use DB2 to power their business. They only have 100 users, but they require all the capablities of DB2 ESE. They can identify all users and found it to make more economic sense to license DB2 ESE on a per user basis using the authorized user (new as of DB2 V8.2.3) metric.DB2 Enterprise Server Edition
A company wants to use DB2 to power their business. They need a robust and scalable database management system for both internal business processes and external procurement applications. They do not want to count users for licensing purposes, because the number of users changes each day. The database will have multiple uses, both transactional and analytic (through data marts), and may need to leverage the power of 64-bit computing.DB2 Enterprise Server Edition
A company maintains both zSeries and pSeries environments. The pSeries workstations act as data marts and are populated from the transaction systems that reside on the zSeries hardware. At the end of the month, each data mart is loaded through an APPLY process that replicated changes recorded by the CAPTURE process that runs on the zSeries hardware. (These processes are part of the DB2 replication solution called DB2 Data Propagator). A connection is needed to the zSeries hardware so that the APPLY and CAPTURE processes can talk. This functionality is provided through the embedded DB2 Connect component in DB2 Enterprise Server Edition.DB2 Enterprise Server Edition
Independent Software Vendors (ISVs) want to write and develop applications that run on DB2, including partitioning. Because they are developing applications, and not running the database engine in a production environment to power a business, they need a cost-effective solution that will allow them to build and test their applications on DB2. They need access and connectivity to all members of the DB2 family (including zSeries and iSeries workstations).DB2 Universal Developer's Edition
A company requires the ultimate in scalability for both data warehousing (including OLAP and data mining) and transactional processing. This company needs a way to seamlessly scale to multiple terabytes and beyond. Management of this system is extremely important. Because it is resource-intensive, the database must be presented as a single image. There is a requirement to transparently scale-up (SMP) and scale-out (cluster) the database solution.DB2 Enterprise Server Edition with the Database Partitioning Option
You require a complete business intelligence infrastructure that allows you to proactively control your data warehouse, provides a robust and scalable query, analytic, and mining environment (or any combination thereof), and combines with best-of- breed partner tools and applications to offer the best overall value for a BI platform (surfaced to users through popular end-use analytic tools). DB2 Data Warehousing Enterprise Edition

Disclaimer

Prices are US-based list and are current as of the publication date of this article; they exclude applicable taxes, and are subject to change by IBM without notice. The information in this article is submitted as a best effort basis as the author understands it and does not represent an official communication from IBM. Neither IBM nor the author is responsible for the information in this article.

Resources

Learn

Get products and technologies

  • Build your next development project with IBM trial software, available for download directly from developerWorks.

Discuss

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Information management on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=23534
ArticleTitle=Which distributed edition of DB2, Version 8 is right for you?
publish-date=03232006