5765-F41 IBM Db2 Enterprise Server Edition V11.1

IBM Canada/Latin America Sales Manual
Revised:  July 18, 2017.

Table of contents
TOC Link Product life cycle dates TOC Link Description
TOC Link Program number TOC Link Operating environment
TOC Link Abstract TOC Link Planning information
TOC Link Product positioning TOC Link Publications
TOC Link Highlights TOC Link Security, auditability, and control

 
Product life cycle dates
Program NumberVRM Announced Available Marketing Withdrawn Service Discontinued
5765-F4111.01.002016/04/122016/06/15 - -
5765-F4110.05.002013/04/232013/06/14 2016/09/30 -
5765-F4110.01.002012/04/032012/04/30 2016/04/122017/09/30
5765-F4109.07.002009/05/192009/06/19 2013/11/122017/09/30
5765-F4109.05.002007/10/162007/10/31 2013/02/132015/04/30
5765-F4109.01.002006/06/072006/07/28 2008/05/302012/04/30
5765-F4108.02.002004/08/172004/09/17 2008/01/252009/04/30
5765-F4108.01.002002/09/172002/11/21 2007/01/192009/04/30
5765-F3511.01.002016/04/122016/06/15 - -
5765-F3510.05.002013/04/232013/06/14 2016/09/30 -
5765-F3510.01.002012/04/032012/04/30 2016/04/122017/09/30
5765-F3509.07.002009/05/192009/06/19 2013/11/122017/09/30
5765-F3509.05.002007/10/162007/10/31 2013/02/132015/04/30
5765-F3509.01.002006/06/072006/07/28 2008/05/302012/04/30
5765-F3508.02.002004/08/172004/09/17 2008/01/252009/04/30
5765-F3508.01.002002/09/172002/11/21 2007/01/192009/04/30
5725-L4711.01.002016/04/122016/06/15 - -
5725-L4710.05.002013/04/232013/06/14 2016/09/30 -
5725-L1611.01.002016/04/122016/06/15 - -
5725-L1610.05.002013/04/232013/06/14 2016/09/30 -
5725-L1511.01.002016/04/122016/06/15 - -
5725-L1510.05.002013/04/232013/06/14 2016/09/30 -
5725-E8911.01.002016/04/122016/06/15 - -
5725-E8910.05.002013/04/232013/06/14 2016/09/30 -
5725-E8910.01.002012/04/032012/04/30 2016/04/122017/09/30
5725-B7610.01.002012/04/032012/04/30 2013/11/122017/09/30
5725-B7609.07.002010/10/052010/10/22 2013/11/122017/09/30
5724-T1910.01.002012/04/032012/04/30 2014/04/302017/09/30
5724-T1909.07.002009/05/192009/06/19 2014/04/302017/09/30
5724-T1909.05.002007/11/132007/11/30 2014/04/302015/04/30
5724-S4010.01.002012/04/032012/04/30 2016/04/122017/09/30
5724-S4009.07.002009/05/192009/06/19 2013/11/122017/09/30
5724-S4009.05.002007/10/162007/10/31 2013/02/132015/04/30
5724-S4009.01.002007/04/302007/06/01 2008/05/302012/04/30
5724-R2811.01.002016/04/122016/06/15 - -
5724-R2810.05.002013/04/232013/06/14 2016/09/30 -
5724-R2810.01.002012/04/032012/04/30 2013/11/122017/09/30
5724-N9711.01.002016/04/122016/06/15 - -
5724-N9710.05.002013/04/232013/06/14 2016/09/302017/09/30
5724-N7810.01.002012/04/032012/04/30 2013/11/122017/09/30
5724-N7809.07.002009/05/192009/06/19 2013/11/122017/09/30
5724-N7809.05.002007/10/162007/10/31 2013/02/132015/04/30
5724-N7809.01.002006/06/072006/07/28 2008/05/302012/04/30
5724-N7611.01.002016/04/122016/06/15 - -
5724-N7610.01.002012/04/032012/04/30 2016/04/122017/09/30
5724-N7609.07.002009/05/192009/06/19 2013/11/122017/09/30
5724-N7609.05.002007/10/162007/10/31 2013/02/132015/04/30
5724-N7609.01.002006/06/072006/07/28 2008/05/302012/04/30
5724-E4911.01.002016/04/122016/06/15 - -
5724-E4910.05.002013/04/232013/06/14 2016/09/30 -
5724-E4910.01.002012/04/032012/04/30 2016/04/122017/09/30
5724-E4909.07.002009/05/192009/06/19 2013/11/122017/09/30
5724-E4909.05.002007/10/162007/10/31 2013/02/132015/04/30
5724-E4909.01.002006/06/072006/07/28 2008/05/302012/04/30
5724-E4908.02.002004/08/172004/09/17 2008/01/252009/04/30
5724-E4908.01.002003/05/202003/05/30 2007/01/192009/04/30
5724-Y6910.01.002012/04/032012/04/30 2013/11/122017/09/30
5724-Y6909.08.002009/10/272009/12/11 2013/11/122016/04/30
5725-Z9811.01.022017/06/202017/06/23 - -
5725-Z9811.01.012016/04/122016/06/15 - -
5725-Z9911.01.022017/06/202017/06/23 - -
5725-Z9911.01.012016/04/122016/06/15 - -

Back to topBack to top
 
Program number
  • IBM Db2 Enterprise Server Edition V11.1.0 (5765-F41)
  • IBM Db2 Workgroup Server Edition V11.1.0 (5765-F35)
  • IBM Db2 Advanced Enterprise Server Edition V11.1.0 (5725-L47)
  • IBM Db2 Advanced Recovery Feature V11.1.0 (5725-L16)
  • IBM Db2 Advanced Workgroup Server Edition V11.1.0 (5725-L15)
  • IBM Db2 Advanced CEO V11.1.0 (5725-E89)
  • IBM Db2 Advanced Enterprise Server Edition V10.1.0 (5725-B76)
  • IBM Homogeneous Replication Feature for Db2 Enterprise Server Edition V10.1.0 (5724-T19)
  • IBM Db2 Express Edition Fixed Term License V10.1.0 (5724-S40)
  • IBM Db2 CEO V11.1.0 (5724-R28)
  • IBM InfoSphere Federation Server V10.5.0 (5724-N97)
  • IBM Db2 Developer Edition V11.1.0 (5724-N76)
  • IBM Db2 Storage Optimization Feature V10.1.0 (5724-N78)
  • IBM Db2 Express Server Edition V10.5.0 (5724-E49)
  • IBM Db2 pureScale Feature V10.1.0 (5724-Y69)
  • IBM Db2 Direct Standard Edition V11.1.2 (5725-Z98)
  • IBM Db2 Direct Advanced Edition V11.1.2 (5725-Z99)

Back to topBack to top
 
Abstract

IBM Db2 is the transformation data platform for transactional and analytical workloads in the era of digital, cloud, and cognitive. It provides continuous availability of data to keep transactional and analytics operations at maximum efficiency to ensure access to data is not impacted by any planned or unplanned downtime. Db2 11.1 scales to new heights of performance by enabling its BLU Acceleration capability to be deployed across a massively parallel processing (MPP) network cluster architecture to improve response time. In addition, Db2 11.1 enhances the simplicity of pureScale deployments for transactional workloads and the administration of pureScale clusters. The native encryption feature has also been enhanced to support the industry ISKLM standard for key management across the organization.

New sources of data. Leveraging all data. With the flexibility and simplicity of Db2, clients can deploy the software on- premises or/and on the cloud to leverage data from the next generation type of applications, born-on-the-cloud applications, sensors, web, and mobile-based applications.

Actionable insight. Capture the time value of data. The dynamic in-memory column-organized table technology is designed to yield faster analytics from data warehousing without the costs or limits of in-memory only systems. It speeds analytics and reporting with a combination of in-memory and column store data retrieval, optimized use of CPU resources, and data skipping that allows for faster input/output, thus resulting in faster response time and quicker actions for the line of business.

New users, new buyers, and new ways of working. Providing insights everywhere. Db2 provides the ability for having always available business data to keep your businesses up and running with Db2 pureScale clustering technology. It helps to ensure that your transaction processing is highly available and extremely scalable. It is designed to avoid both planned and unplanned outages and ensure disaster recovery up to thousands of miles/kilometers, which means virtually no costly downtime even with maintenance, thus providing an agile platform for the always on business.

New Economics. Lowering the barriers to new business models. With the different deployment options that Db2 provides be it on-premises, on cloud, or hybrid, along with integrated security and manageability, Db2 provides organizations greater flexibility to extend the reach of the enterprise beyond the walls of the enterprise. Also, unlike other in-memory data store alternatives, Db2 11.1 with BLU Acceleration uses a dynamic in-memory hybrid column-organized table approach that places only frequently used data in memory to accelerate queries which means unnecessary data is not consuming memory resources.

Transformative Platform. Making the infrastructure adapt with your business. Businesses need to adapt their business processes to changing consumer behavior. Therefore they need to eliminate barriers for their developers to innovate quickly and promptly to stay ahead of the competition. Db2 on-premises or on the cloud provide the same experience and features to leverage the skills and help with transitions between ground and cloud business.

IBM Db2 Direct Standard Edition 11.1 and IBM Db2 Direct Advanced Edition 11.1

IBM Db2 Direct Standard Edition and IBM Db2 Direct Advanced Edition introduce a set of new license metrics to facilitate hybrid cloud deployments. The Db2 Direct Editions provide the same Db2 functionality but add ease of purchase and licensing flexibility using a newly introduced simplified license metric, the Virtual Processor Core (VPC) sold as a monthly license charge. Clients can acquire the product directly online and have the option to deploy either on- premises or on cloud.

Available in two editions. Db2 Direct Standard Edition encompasses all database features of Db2 Workgroup Server Edition. Db2 Direct Advanced Edition has all of the database features of Db2 Advanced Enterprise Server Edition.

Db2 product family, V11.1.2.2 includes defect fixes and security patches along with new features and functionality. The changes help you:

  • Manage enterprise data
  • Improve programmer productivity
  • Enhance tooling capabilities
  • Deliver fast and robust connectivity to Db2 databases

Db2 continues to enhance features and functionality, offering:

  • Database Management System for the always available, mission- critical transactional, analytical, and mixed workload applications with security-rich features that protect data at rest or in-flight
  • A database that is designed to be simple to deploy, upgrade, and maintain, with continuous availability for transactional workloads of any size
  • Expanded, in-memory columnar technology that offers the improved scalability and performance for analytics and warehousing workloads
  • Significant feature enhancements to improve connectivity, with ease of application deployment, availability, and security for applications
  • Enhanced tooling capabilities to monitor, administer, and tune the performance of database environments
  • Updates to advanced recovery capabilities

Back to topBack to top
 
Product positioning

IBM Db2 Editions for production deployment

IBM Db2 Advanced Enterprise Server Edition 11.1

Db2 Advanced Enterprise Server Edition includes the functionality and tools needed for large, complex enterprise environments, and is ideal for both transactional and data warehouse workloads. This edition enriches all the functionality from the Db2 Enterprise Server Edition with full data compression functionality, BLU Acceleration, pureScale clustering, workload management, distributed partitioning functionality (DPF), federation between Db2 databases and databases from other vendors including Oracle database and SQL Server, queue-based replication (Q Replication) between three Db2 systems, Change Data Capture (CDC) replication between a Db2 source and another Db2 11.1 target for the purpose of HADR, Cognos Analytics as well as the following rich set of tools:

  • IBM Data Server Manager Enterprise Edition
  • IBM Data Studio
  • InfoSphere Data Architect (10 authorized users)

The tools listed above can be used with any supported version of Db2 Advanced Enterprise Server Edition. Similarly, any of these tools that were included with prior versions of Db2 Advanced Enterprise Server Edition can be used with Db2 Advanced Enterprise Server Edition 11.1, if supported.

Db2 Advanced Enterprise Server Edition can be deployed on Linux, UNIX, or Windows servers of any size, from one processor to hundreds of processors, and on both physical and virtual servers.

Program charges: Db2 11.1 Advanced Enterprise Server Edition is available on a PVU, per Authorized User Single Install (AUSI), or per Terabyte charge metric.

IBM Db2 Enterprise Server Edition 11.1

Db2 Enterprise Server Edition is designed to meet the data server needs of midsize to large-size businesses and is ideal for transactional and mixed workloads. It can be deployed on Linux, UNIX, or Windows servers of any size, from one processor to hundreds of processors, and on both physical and virtual servers. The edition includes IBM Data Studio, IBM Data Server Manager Base Edition, Label Based Access Control, Row and Column Access Control, Multi-Temperature Data Management, Time Travel Query, Table Partitioning, High Availability Disaster Recovery, Online Reorganization, Materialized Query Tables (MQTs), Multidimensional Clustering (MDC), Query Parallelism, Scan Sharing, Connection Concentrator, pureXML, backup compression, and Tivoli System Automation for Multiplatforms for use with high availability. The product also includes Db2 Homogeneous Federation and Homogeneous SQL Replication allowing federated data access and replication between Db2 servers.

Program charges: Db2 11.1 Enterprise Server Edition is available on a PVU or per Authorized User Single Install (AUSI) charge metric.

IBM Db2 Advanced Workgroup Server Edition 11.1

Db2 Advanced Workgroup Server Edition includes the capabilities needed for medium-sized business environments, and is ideal for both transactional and data warehouse workloads. The edition includes largely the same functionality and tools as Db2 Advanced Enterprise Server Edition. The main difference is that Db2 Advanced Workgroup Server Edition has processor core, socket, memory and Terabyte restrictions described below.

Program charges: Db2 11.1 Advanced Workgroup Server Edition is available on a PVU, per Authorized User Single Install (AUSI), or per Terabyte charge metric. Under the PVU and AUSI charge metrics, you are restricted to 16 processor cores and 128 GB of instance memory while under the per Terabyte charge metric, you are restricted to 4 processor sockets. These restrictions are per physical or, where partitioned, virtual server except in a pureScale or DPF cluster where the restrictions apply to the entire cluster.

IBM Db2 Workgroup Server Edition 11.1

Db2 Workgroup Server Edition is suitable for transactional database workloads in a departmental, workgroup, or medium-sized business environment. The edition shares significant functionality with Db2 Enterprise Server Edition but has processor core, memory restrictions described below.

Program charges: Db2 11.1 Workgroup Server Edition is available on a per PVU, Virtual Server (VS), or Authorized User Single Install (AUSI) charge metric. Under all metrics, you are restricted to 16 processor cores and 128 GB of instance memory.

IBM Db2 Direct Advanced Edition 11.1

Db2 Direct Advanced Edition includes all the database functionality from the Db2 Advanced Enterprise Server Edition for digital delivery.

Db2 Direct Advanced Edition can be deployed on Linux, UNIX, or Windows servers of any size, from one processor to hundreds of processors, and on both physical and virtual servers.

Program charges: Db2 11.1 Advanced Enterprise Server Edition is available on per Virtual Processor Core (VPC) charge metric as a monthly license charge.

IBM Db2 Direct Standard Edition 11.1

Db2 Direct Standard Edition includes all the functionality from the Db2 Advanced Workgroup Server Edition for digital delivery.

Program charges: Db2 Direct Standard Edition is available on a Virtual CPU charge metric. You are restricted to 16 virtual processor cores and 128 GB of instance memory. These restrictions are per physical or virtual server except in a pureScale or DPF cluster where the restrictions apply to the entire cluster.

IBM Db2 Edition for non-production deployment

IBM Db2 Developer Edition 11.1

IBM Db2 Developer Edition offers a package for a single application developer to design, build, test, and prototype applications for deployment on any of the IBM Db2 client or server platforms. This comprehensive developer offering includes Db2 Workgroup Server Edition, Db2 Advanced Workgroup Server Edition, Db2 Enterprise Server Edition, Db2 Advanced Enterprise Server Edition, Db2 Connect Enterprise Edition, and all of the built-in Db2 11.1 capabilities, allowing you to build solutions that utilize the latest data server technologies.

Program charges: The software in this package cannot be used for production systems. You must acquire a separate Authorized User license for each unique person who is given access to the Program.

IBM Db2 11.1 purchasable features

IBM Db2 Advanced Recovery Feature 11.1

Db2 Advanced Recovery Feature 11.1 is made available in conjunction with the Db2 11.1 database release. This Feature is a bundle of advanced database backup, recovery, and data extraction tools that can help you improve data availability, mitigate risk, and accelerate crucial administrative tasks when time is of the essence. New features of the tools include support for Db2 11.1, including using the tools with Db2 native encryption. The Advanced Recovery Feature bundle contains the following new releases of the included tools:

  • IBM Db2 Merge Backup V3.1
  • IBM Db2 Recovery Expert V5.1
  • IBM Optim High Performance Unload for Db2 V6.1

Trial versions of the Db2 Advanced Recovery Feature are available on developerWorks or as part of the Db2 Advanced Editions/Db2 Developers Edition packages.

Program charges: Db2 11.1 Advanced Recovery Feature is available under Authorized User Single Install, PVU, per Terabyte, and new Db2 Flex charge metrics. You must acquire the same Metric and number of entitlements as you have acquired for the Db2 server that you will be running this feature against.

IBM Db2 Performance Management Offering

Db2 Performance Management Offering helps organizations manage their IBM Db2 databases across the enterprise through tooling that has a common integrated console, enhanced simplicity, improved performance and scalability, and simplified workflow with actionable recommendations. Organizations can:

  • Simplify database administration and reduce errors with integrated web console to view and monitor the health of databases across the enterprise.
  • Identify, diagnose, prevent, and solve performance problems with a more predictable database server execution environment.
  • Track and manage client/server and database environment efficiently with centralized management.
  • Optimize database performance with expert recommendations on query design, unique indexes, and statistics quality.

In the past, these performance management tools were primarily available with Db2 Advanced editions. However, now with Db2 Performance Management Offering, organizations can get access to these tools for Db2 Enterprise Edition and Db2 Workgroup Server Edition.

Detailed Db2 11.1 package comparison

The following table summarizes the functionality available in each edition of Db2 11.1:

WSE = Db2 Workgroup Server Edition
AWSE = Db2 Advanced Workgroup Server Edition
DSE = Db2 Direct Standard Edition
ESE = Db2 Enterprise Server Edition
AESE = Db2 Advanced Enterprise Server Edition
DAE = Db2 Direct Advanced Edition
Developer = Db2 Developer Edition
--------------------------        ------- ---- ---- -------- ---------
Function                          WSE/DSE AWSE ESE  AESE/DAE Developer
--------------------------        ------- ---- ---- -------- ---------
BLU Acceleration                     -     Yes   -   Yes     Yes
pureScale                           Yes    Yes  Yes  Yes     Yes
                                    (9)         (9)
Data Partitioning                    -     Yes   -   Yes     Yes
pureXML Storage                     Yes    Yes  Yes  Yes     Yes
Time Travel Query                   Yes    Yes  Yes  Yes     Yes
Compression                          -     Yes   -   Yes     Yes
  (row, Adaptive, index)
Compression (Backup)                Yes    Yes  Yes  Yes     Yes
Row & Column Access Control         Yes    Yes  Yes  Yes     Yes
Label Based Access Control          Yes    Yes  Yes  Yes     Yes
SQL Replication (1)                 Yes    Yes  Yes  Yes     Yes
Federation Capabilities (3)         Yes    Yes  Yes  Yes     Yes
                                    (2)    (4)  (2)  (4)     (4)
WebSphere MQ                        Yes    Yes  Yes  Yes     Yes
High Availability                   Yes    Yes  Yes  Yes     Yes
  Disaster Recovery
Tivoli System Automation            Yes    Yes  Yes  Yes     Yes
Online Reorg                        Yes    Yes  Yes  Yes     Yes
Advanced Copy Services              Yes    Yes  Yes  Yes     Yes
Multi-temperature Storage           Yes    Yes  Yes  Yes     Yes
Materialized Query Tables            -     Yes  Yes  Yes     Yes
Multi-Dimensional Clustering        Yes    Yes  Yes  Yes     Yes
Query Parallelism                   Yes    Yes  Yes  Yes     Yes
Connection Concentrator             Yes    Yes  Yes  Yes     Yes
Table Partitioning                  Yes    Yes  Yes  Yes     Yes
Plan Lockdown                       Yes    Yes  Yes  Yes     Yes
Scan Sharing                        Yes    Yes  Yes  Yes     Yes
Workload Management                 Yes    Yes  Yes  Yes     Yes
                                    (8)         (8)
MQ Replication (5)                   -     Yes   -   Yes     Yes
CDC Replication (5, 6)               -     Yes   -   Yes     Yes
Continuous Data Ingest               Yes   Yes  Yes  Yes     Yes
Db2 Connect                          -     Yes   -   Yes     Yes
                                           (7)       (7)

Notes:

  1. To Db2 for LUW data source only. Requires Db2 Connect or InfoSphere Replication when replicating with Db2 for z and/or Db2 for i.

  2. Federation includes only Db2 and Informix data sources.

  3. Requires Db2 Connect when federating with Db2 for z and/or Db2 for i.

  4. Federation includes all supported IBM and non-IBM data sources.

  5. Restricted to a source Db2 server and no more than two other Db2 servers.

  6. Restricted to unidirectional replication without data transformations between Db2 servers of the same version for the purpose of high availability / disaster recovery and for supporting shadow table functionality between a single Db2 for LUW instance to replicate from row-organized tables into column-organized tables.

  7. For the purposes of using SQW tooling to access Db2 for z and Db2 for i.

  8. Available with the Performance Management Offering.

  9. Only to allow for an idle standby member within a pureScale cluster.

The following table summarizes the tools available in each edition of Db2 11.1:

WSE = Db2 Workgroup Server Edition
AWSE = Db2 Advanced Workgroup Server Edition
DSE = Db2 Direct Standard Edition
ESE = Db2 Enterprise Server Edition
AESE = Db2 Advanced Enterprise Server Edition
DAE = Db2 Direct Advanced Edition
Developer = Db2 Developer Edition
 
--------------------------    -------- ---- ---   --------- ---------
Feature / Tool                WSE/DSE  AWSE ESE   AESE/DAE  Developer
--------------------------    -------- ---- ---   --------  ---------
Advanced Recovery Feature      OPT     OPT  OPT   OPT       OPT
(1)
Db2 Performance Management     OPT     Yes  OPT   Yes       Yes
  Offering
WHS Design Studio               -      Yes   -    Yes       Yes
WHS SQW                         -      Yes   -    Yes       Yes
Cognos Analytics (3)            -      Yes   -    Yes/No    Yes
Data Studio                    Yes     Yes  Yes   Yes       Yes
Data Server Manager            Yes     Yes  Yes   Yes       Yes
  Enterprise                   (4)          (4)
Data Server Manager Base       Yes      -   Yes    -        Yes
InfoSphere Data Architect       -      Yes   -    Yes       Yes
  Capabilities                         (2)        (2)

Notes:

  1. Optional, separately priced Db2 feature.
  2. Limit to 10 authorized users in Data Architect.
  3. Limit to 5 authorized users in Cognos Analytics.
  4. Available with the Performance Management Offering.

The following tables summarize the charge metrics and resource limits applicable to each edition of Db2 11.1:

WSE = Db2 Workgroup Server Edition
AWSE = Db2 Advanced Workgroup Server Edition
ESE = Db2 Enterprise Server Edition
AESE = Db2 Advanced Enterprise Server Edition
Developer = Db2 Developer Edition
--------------------------         ------ ------ ----- ----- ---------
Attribute                          WSE    AWSE   ESE   AESE  Developer
--------------------------         ------ ------ ----- ----- ---------
Pricing Metric (1)                 AUSI   AUSI   AUSI  AUSI  AU
                                   VS     PVU    PVU   PVU
                                   PVU    TB           TB
 
 
--------------------------         ------ ------ ----- ----- ---------
Processor Core Limit               16     16     N/A   N/A   N/A
  (number of cores)                       (2)
 
--------------------------         ------ ------ ----- ----- ---------
Processor Socket Limit             4      4      N/A   N/A   N/A
  (number of sockets)                     (3)
 
--------------------------         ------ ------ ----- ----- ---------
Db2 Instance Memory                128 GB 128 GB N/A   N/A   N/A
  Limitation                              (2)
--------------------------         ------ -----  ----- ----- ---------
TB Limit                           15     15     N/A   N/A   N/A
  (terabytes of user data          (3)    (3)
  per database)
--------------------------         ------ -----  ----- ----- ---------

Notes:

  1. Key:
    AUSI - Authorized User Single Install
    VS - Virtual Server
    PVU - Processor Value Unit
    FTL - Fixed Term License
    TB - Terabyte
    AU - Authorized User

  2. Applies to the AUSI and PVU metrics only

  3. Applies to the TB metric only
DSE = Db2 Direct Standard Edition
DAE = Db2 Direct Advanced Edition
 
--------------------------         ------    ------
Attribute                          DSE       DAE
--------------------------         ------    ------
Pricing Metric (1)                 VPC       VPC
--------------------------         ------    ------
Processor Core Limit               16        N/A
 (number of cores)
--------------------------         ------    ------
Db2 Instance Memory                128 GB    N/A
 Limitation
--------------------------         ------    ------
TB Limit
 (terabytes of user                15        N/A
  data per database)
--------------------------         ------    ------

Notes:

  1. Key:
    VPC -Virtual Processor Core

Product positioning - globalization:

Menus and messages displayed by the product and publications have been translated for the following languages:

CAN--->

English and French.
<---CAN

LA--->

English, Brazilian Portuguese, and Spanish.
<---LA
Back to topBack to top
 

Highlights

IBM Db2 11.1

IBM Db2 11.1 delivers the following capabilities:

  • A hybrid database software for the always available mission- critical transactional, analytical, and mixed workload applications with end-to-end security that protects data at rest or in-flight.
  • A simple to deploy, upgrade, and maintain database with continuous availability for transactional workloads of any size.
  • Expanded in-memory columnar technology that offers the ultimate scalability and performance for analytics and warehousing workloads.

Db2 product family, V11.1.2.2 offers enhancements for recoverability, performance, and JSON.
Back to topBack to top
 

Description

IBM Db2 Version 11.1

Whether your business strategy is to drive growth, improve operational results, reduce costs, attract new or retain existing customers, improve IT applications and infrastructure performance, or innovate and create new products, Db2 11.1 with BLU Acceleration offers features and the flexibility that are uniquely designed to help you accomplish more with less.

New and improved capabilities

Analytics at the speed of thought

Db2 BLU Acceleration delivers query results at in-memory speed, leading to faster insights for business analytics, allowing you to react more quickly and have an immediate impact to your business results. Db2 11.1 now enables you to run Db2 BLU Acceleration as a multi-terabyte data warehouse on either a single server or clustered MPP set of servers, providing unprecedented scale for your analytics at in-memory speeds to meet your business needs.

Db2 BLU Acceleration is designed to be transparent, which means it can be deployed with a wide variety of data warehouse applications. Db2 11.1 with BLU Acceleration uses a dynamic in-memory hybrid column- organized table approach that places only frequently used data in memory to accelerate queries which means unnecessary data is not consuming memory resources.

For optimal implementation of BLU Acceleration, the enhancements to the Data Server Manager tool help you to analyze your workload and decide which tables would yield the greatest benefits when converted to BLU Acceleration column-oriented tables. A management reporting tool is also included that helps you track the percentage of your user data that resides in BLU Acceleration column-oriented tables.

BLU Acceleration is included in Db2 Advanced Enterprise Server Edition, Db2 Advanced Workgroup Server Edition, Db2 Direct Advanced Edition and Db2 Developer Edition.

Always available transactions

The pureScale clustered database technology for 'always on' data access now includes support for high availability disaster recovery (HADR). Use HADR to mirror data from your primary pureScale database cluster to a second local or remote standby pureScale cluster. If your entire primary cluster goes offline, the standby cluster is fully synchronized and is designed to take over the load in seconds, minimizing impact on your business and your end customers.

The pureScale capability also now includes online fix pack update support. You can apply Db2 11.1 fix packs to individual members running Db2 11.1 in a pureScale cluster without having to take the entire cluster offline. With this enhancement you can now perform fix pack maintenance operations on your pureScale cluster with minimal impact to your users.

The pureScale clustered database technology is included in Db2 Advanced Enterprise Server Edition, Db2 Advanced Workgroup Server Edition, Db2 Direct Advanced Edition, and Db2 Developer Edition.

Easy Choices

Db2 11.1 makes it easier to choose the edition 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 Standard Edition
  • Db2 Direct Advanced Edition
  • 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 functionality or performance.

Hassle-free Db2 Edition upgrades

If you already use Db2 and would like to upgrade to a more functional edition, certain Db2 11.1 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 simply 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 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

Prior versions of Db2 listed as a Supporting Program for any Db2 11.1 Edition may 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 IBM Db2 11.1, and will only be available until the announce 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 Advanced Recovery Feature 11.1

Db2 Advanced Recovery Feature 11.1 is also available in conjunction with the Db2 11.1 database release. This feature is a bundle of advanced database backup, recovery, and data extraction tools that can help you improve data availability, mitigate risk, and accelerate crucial administrative tasks when time is of the essence. New features of the tools include support for Db2 11.1, including using the tools with Db2 native encryption. The Advanced Recovery Feature bundle contains the following new releases of the included tools:

  • IBM Db2 Merge Backup V3.1
  • IBM Db2 Recovery Expert V5.1
  • IBM Optim High Performance Unload for Db2 V6.1

Trial versions of the Db2 Advanced Recovery Feature are available on developerWorks or as part of the Db2 Advanced Workgroup Server Edition, Db2 Advanced Server Edition, and Db2 Developer Edition.

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 allows you to 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 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

Database Tools for Db2 are updated in this release to accelerate adoption and enhance the value of key Db2 features, including BLU Acceleration, pureScale, and compression. Refer to the Product positioning section for details about which tools are included in each Db2 edition.

The following releases support Db2 11.1:

  • 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 will provide homogeneous and/or heterogeneous federation (depending on the Db2 Edition) between select IBM and non-IBM database products. This federation capability helps you quickly prototype and implement solutions involving disparate databases by virtualizing access and optimizing performance, so that data can remain in place for both transactional as well as analytical workloads.

Db2 V11.1.2.2 delivers new functional enhancements to the products identified below:

  • Recoverability enhancements:
    • A database can be connectable during the backward phase of crash- recovery
    • Improved rollback performance
    • Eliminated bottlenecking of DGTT log-records
    • Global Lock Manager recovery design improvements, including improved hashing algorithms and increased parallelism for reducing the recovery window
    • New recovery design benefits pureScale deployments, particularly large clusters configured with huge lock list, Global Lock Manager, and global buffer pool
    • Ability to recover an erroneous tablespace on the HADR Standby
  • Performance enhancements:
    • Parallel insert for BLU (columnar) data
    • Faster query performance with BLU synopsis tables
    • Improved text search performance
    • Runtime improvements for SAP Core Data Services
  • JSON enhancements:
    • Full support for direct SQL access to underlying JSON interfaces

New Db2 Developer-C Edition V11.1.2.2: This new community-supported edition enables developers to utilize all advanced features and functionality of Db2 to develop new innovative applications for database environments supporting pureScale, BLU Acceleration, compression, encryption, and database partitioning.

Db2 Connect V11.1.2.2 integrates IBM Db2 for z/OS, IBM Db2 for i, and other enterprise data with client/server, web, and service-oriented architecture (SOA) applications. This solution is designed to manage access to your enterprise information wherever it is stored. For those enterprises that rely on Db2 for z/OS and Db2 for i servers as the cornerstone of their agile business, Db2 Connect delivers improved application enablement and a robust, highly scalable communications infrastructure for connecting web, Windows, UNIX, and Linux applications to data. Db2 Connect 11.1.2.2 improves connectivity, including updates for:

  • Expansion of .NET environments:
    • .Net Core and EF Core support
  • Manageability enhancements:
    • Increasing diagnostic data to serviceability log
    • Options to Limit CLI trace size
  • Performance improvements
    • Data Access Accelerator Support in JCC with JDK1.8
  • Security enhancements
    • PKICard Client certificate support in JCC
    • New configuration property for TLS Support in JCC
    • Configurable property for KeyStoreLocation Password Type in JCC
  • Expanded IBM environments
    • IMS T4 Connectivity enables communication from IMS to distributed applications
    • Support for IBM i 7.3

Db2 Advanced Recovery Feature V11.1.2.2

Db2 Advanced Recovery Feature is a bundle of advanced database backup, recovery, and data extraction tools that can help you improve data availability, mitigate risk, and accelerate crucial administrative tasks when time is of the essence. A new feature is support for Db2 native encryption.

The Advanced Recovery Feature bundle contains releases of the following tools:

  • IBM Db2 Merge Backup V3.1.0.1
  • IBM Db2 Recovery Expert V5.1.0.1
  • IBM Optim High Performance Unload for Db2 V6.1.0.1

Db2 Performance Management Offering V11.1.2.2 with Data Server Manager V2.1.4 is a streamlined, scalable solution that can be used to administer, monitor, manage, and optimize the performance of Db2 databases across the enterprise. New features include:

  • Easy setup for cross-enterprise federated data sources
  • Data Server Manager Security enhancements for:
    • Kerberos
    • Multifactor authentication
  • Accelerate hybrid problem determination
    • Redesigned home page card and grid views for faster hot spot identification and large data enterprise management
    • Additional Key Performance Indicator -- Data Server CPU
    • Active hotspot drilldown for in-depth historical monitoring
    • Statement history for MPP by member
    • Enhanced Db2 privilege and authority management

For more information on the specific details of the enhancements and new features, see IBM Knowledge Center.

Accessibility by people with disabilities

A US Section 508 Voluntary Product Accessibility Template (VPAT) containing details on accessibility compliance can be requested at

http://www.ibm.com/able/product_accessibility/index.html

A US Section 508 Voluntary Product Accessibility Template (VPAT) can be requested via the IBM website at

http://www.ibm.com/able/product_accessibility/index.html



Back to topBack to top
 
Operating environment

Hardware requirements

The hardware requirements of Db2 products may be occasionally updated. To obtain the current information for supported hardware, visit

http://www.ibm.com/software/data/db2/udb/sysreqs.html

Software requirements

This section indicates the minimal requirements for operating systems at the time of this announcement.

The operating system support level for various Db2 products is frequently updated. To obtain the current information for supported software levels, including recommended maintenance levels, refer to

http://www.ibm.com/software/data/db2/udb/sysreqs.html

For more information, refer to the installation prerequisites in the documentation accompanying each product.
Back to topBack to top
 

Planning information

Customer responsibilities

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
Back to topBack to top
 

Publications

No publications are shipped with these products.

The IBM Publications Center portal is located at

http://www.ibm.com/shop/publications/order

The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided. Payment options for orders are via credit card (in the US) or customer number for 20 countries. A large number of publications are available online in various file formats, and they can all be downloaded by all countries free of charge.

News of many publications may be subscribed to via Mysupport.

https://www-1.ibm.com/support/mysupport/us/en/?OpenDocument

IBM Redbooks

IBM Redbooks offer deep technical insight from IBM and industry experts. These books highlight real-time experiences, and include sample code, typical scenarios and step-by-step, "how-to" guidelines.

For IBM Redbooks portal is located at

http://www.redbooks.ibm.com/


Back to topBack to top
 
Security, auditability, and control

IBM Db2 V11.1 uses the security and auditability features of the host hardware or software.

To protect data and resources associated with a database server, Db2 uses a combination of external security services and internal access control information. To access a database server, the user must pass some security checks before being given access to database data or resources.

Db2 products interface with external security mechanisms available with operating systems on which Db2 products are supported as well as support for the Kerberos security mechanism. Db2 has an integrated audit facility that can be used to track data access by users. The subsequent analysis of an audit log can lead to improvements in the control of data access and the ultimate prevention of malicious or careless unauthorized access to the data.

Trademarks

(R), (TM), * Trademark or registered trademark of International Business Machines Corporation.

** Company, product, or service name may be a trademark or service mark of others.

Windows is a trademark of Microsoft Corporation.

UNIX is a registered trademark in the United States and other countries licensed exclusively through X/Open Company Limited.
 © IBM Corporation 2017.
Back to topBack to top

Contact IBM

Considering a purchase?