DB2 Editions

DB2 11.1 for Linux, UNIX, and Windows makes it easier to choose the DB2 editions with the capabilities and tools required to meet your organization’s data management needs:

  • DB2 Advanced Enterprise Server Edition
  • DB2 Enterprise Server Edition
  • DB2 Advanced Workgroup Server Edition
  • DB2 Workgroup Server Edition
  • DB2 Direct Advanced Edition
  • DB2 Direct Standard Edition
  • DB2 for Big Data
  • DB2 Developer Edition

With this packaging structure you choose one or two DB2 Editions that fulfill all of your enterprise’s data management requirements. For example, DB2 Advanced Enterprise Server Edition and DB2 Advanced Workgroup Server Edition can be deployed in a single-server or multi-server clustered environment and can handle OLTP, warehouse, and mixed workloads. As a result, both the DB2 Advanced Enterprise Server Edition and DB2 Advanced Workgroup Server Edition give you deployment flexibility without having to compromise on function or performance.

Hassle-free DB2 Edition upgrades

If you already use DB2 for Linux, UNIX, and Windows and would like to upgrade to a more functional edition, certain DB2 11.1 for Linux, UNIX, and Windows editions share a common install image. This means that you can move between those DB2 editions with a simple license key update. You do not need to install new DB2 code on these DB2 11.1 edition upgrades. Furthermore, test cycles are reduced because the edition upgrade unlocks new capabilities in your existing DB2 installation. The following upgrade paths can all be achieved with a license update. To acquire the appropriate trade-up license entitlement, trade-up parts corresponding to these paths are available for purchase.

Source edition Target DB2 edition
DB2 Workgroup Server Edition DB2 Advanced Workgroup Server Edition

DB2 Enterprise Server Edition

DB2 Enterprise Server Edition DB2 Advanced Enterprise Server Edition


Supporting program information

Previous versions of DB2 listed as a supporting program for any DB2 11.1 Edition can be used instead of the DB2 11.1 program, provided the cumulative deployment of DB2 is within the customer’s entitlements of DB2. For supporting programs included as part of DB2 11.1, support and maintenance for the supporting programs are included as part of Software Subscription and Support for DB2 11.1, and will only be available until the announced end of support date for the listed supporting program. Therefore, the supporting program may not be supported for the full support period of DB2 11.1. After the end of support date for the supporting program, extended support for the supporting program may be available for purchase.

DB2 Performance Management Offering (includes IBM Data Server Manager)

DB2 Performance Management Offering delivers enterprise-class performance management capabilities to the non-Advanced DB2 Editions that helps you manage performance across all of your DB2 deployments. Data Server Manager Enterprise V2.1 can be obtained through the Performance Management Offering and is included as part of the DB2 Advanced Editions. Data Server Manager V2.1 is a simple, scalable, and smart solution to administer, monitor, manage, and optimize the performance of DB2 for Linux, UNIX, and Windows databases across the enterprise. It is easy to deploy and cloud-ready. It simplifies database administrative tasks for both expert and novice users. New features include more robust pureScale monitoring and database administration enhancements.

Advanced tools for DB2 Linux, UNIX, and Windows

Database tools for DB2 for Linux, UNIX, and Windows are updated in this release to accelerate adoption and enhance the value of key DB2 features, including BLU Acceleration, pureScale, and compression.

The following releases support DB2 11.1 Linux, UNIX, and Windows:

  • Data Server Manager V2.1
  • Data Studio V4.1
  • InfoSphere® Data Architect V9.1
  • InfoSphere Optim pureQuery Runtime V3.3
  • InfoSphere Optim High Performance Unload V6.1
  • DB2 Merge Backup V3.1
  • DB2 Recovery Expert V5.1
Get a unified view of your heterogeneous data with DB2 11.1

DB2 11.1 now includes data federation and virtualization through a robust SQL interface and a full relational database engine designed for global optimization of data access. This capability offers homogeneous or heterogeneous federation (depending on the DB2 Edition) between select IBM and non-IBM database products. You can quickly prototype and implement solutions involving disparate databases by virtualizing access and optimizing performance. Data can remain in place for both transactional as well as analytical workloads.

DB2 Connect 11.1

DB2 Connect 11.1 delivers fast and robust connectivity to DB2 databases deployed on either IBM System z or IBM i. DB2 Connect includes several editions to best meet your company’s needs. With most editions, DB2 Connect client components can be used to directly connect applications running on Linux (including Linux on System z), UNIX, and Windows to DB2 servers on System z or IBM i. All editions also include an optional DB2 Connect server component that can be used as a gateway to concentrate and manage connections from multiple desktop clients and applications to DB2 databases on IBM System z or IBM i servers.

DB2 Connect 11.1 enables client applications to create, access, update, control, and manage DB2 databases on host systems using the following:

  • SQL
  • DB2 APIs
  • Open Database Connectivity (ODBC)
  • Java™ Database Connectivity (JDBC)
  • SQLJ (embedded SQL for Java )
  • DB2 Call Level Interface (CLI)
  • Ruby
  • pureQuery
  • .NET
  • PHP
  • Python
  • Perl
High availability and performance enhancements
  • Improved serviceability with first failure data capture
  • Improved load from client side files
  • Support for passive connect (connect without activating the database)
New platform enhancements
  • Mac OS 64-bit support
  • Java 8 support
  • Microsoft™ Windows 10 support
  • Node.js support
  • Microsoft VisualStudio 2015 and Entity framework updates
  • .Net 4.5 Asynch support
Manageability enhancements
  • SSL simplification and PKI card support
  • OSGI compliance
  • Simplify migration from instance based clients, Gateway Server
  • Simplify client deployment
  • Security enhancements
  • SQLJ support with COBOL

Contact Datasync for more information.