CURSOR Service Distribution


  • Db2 Edition V11.5 (18.10.2019)
  • Db2 WE Withdrawal (04.10.2019)
    Withdrawal IBM Db2 Workgroup Server Edition - replacement by Db2 Standard Edition (VPC)
  • Db2 Workgroup VPC (18.10.2019)
  • Informix 14.10 Limits (25.10.2019)
    Extension of limits for Developer-, Express- and Innovator-C Edition
  • Informix 14 CSDK 32-Bit Support (05.08.2019)
    Support for 32-bit applications continued under Informix 14.10 - CURSOR contributes to clarification
  • Informix SSL Connection (15.05.2019)
    How to set up a secure SSL connection for Informix servers and clients with a few commands
  • Informix VPC Lizenzierung (03.05.19)
    Virtual Processor Core - the most useful alternative in processor licensing Informix
  • Informix 14 Datenblatt (12.04.19)
    Actual IBM Solution Brief for Informix 14.10 - download here!
invispix 10x10

New posts

Informix license calculation

Informix Licence Calculator

Sprache/Language Deutsch English

You wonder which Informix Edition is the right one for your application?

Our Licence Calculator provides a decision support.

Indicating the target platform and the requested features, you will receive an assessment of possible editions. Please note that the named prices are base prices and serve your orientation. We will provide individual prices and offers to you on request.

All data are based on the Informix version 14.10.xC2

Description of Hardware and Scope of Use
Operating System used
Please select CPU and Server type
and number of sockets in the server
Sockets used
Cores per Socket used
required Users (Authorized User)
Which of the following features do you want to use in your instance?
Info Shared Disk Secondary Info Enterprise Replication
Info High Avalibility Data Replication Info updateable Secondary-Server
Info several RSS/HDR Server Info Fragmentation
Info Parallel Processing Info Data Warehouse Feature
Info Storage Optimization/Compr. Info Advanced Access Control (LBAC)
Info DML, DDL, SQL access to other instances   
Results:
PVU Value per Core   PVU-Value total  
You can use the following editions:
 
Results:
 

* All prices refer to one license of the particular edition according to our price list.

** The base price of new licenses includes 12 months of initial maintenance. The maintenance prices given refers to a period of 12 months of maintenance renewal.

*** The maintenance for a Innovater-C installation can be ordered optional.

All prices are exclusive of VAT.

All prices are non-binding. The Informix license calculator has been tested thoroughly. Nevertheless, incorrect calculations can not be excluded. We assume no responsibility for the accuracy of the information and prices. Please seek personal advice from us if interested.

Read more

Db2 license calculation

DB2 Licence Calculator

Sprache/Language Deutsch English

You wonder what DB2 Edition is the right one for your application?

Our Licence Calculator provides a decision aid.

Specifying the target platform and the features you want, you will receive an assessment of the editions. Please note that the output prices are base prices and are for your orientation. Individual prices and offers we provide you on request.

Information gathered based on: DB2 11.5

Description of Hardware and Scope of Use
Operating System used
Used CPUs
Sockets used
Cores per Socket used
required Users or Sessions
Results:
PVU Value per Core   PVU-Value total  
You can use the following editions:
 
Results:
 

* All prices are for a license of the particular edition according to our price list.

** The base price of a new license includes 12 months of maintenance. The price for mainanance (for 1 year) is the price after the first 12 months of maintenance.

All prices are exclusive of VAT.

All prices are non-binding. The DB2 license calculator has been tested thoroughly. Nevertheless, incorrect calculations can not be excluded. We assume no responsibility for the accuracy of the information and prices. Please seek personal advice from us if interested.

All prices are non-binding. The DB2 license calculator has been tested thoroughly. Nevertheless, incorrect calculations can not be excluded. We assume no responsibility for the accuracy of the information and prices. Please seek personal advice from us if interested.

Read more

IBM Informix webcasts and online presentations

Streaming Analytics Using Asynchronous Post Commit Triggers

Informix 14.10. WebcastsIBM Community Informix Webcast:
Tuesday, April 21, 2020, 19:00 (CEST) / (01:00 PM EDT)

Summary:

Aggregate and generate real-time reports on OLTP data with zero impact to OLTP applications and without polluting buffer pool with expensive analytic queries.

Other use cases include:

  • Data transformations
  • Update external systems like MQTT, Hadoop and Graph databases
  • Replicate data for tables that do not have primary key, unique index or ER key

Speaker:

Nagaraju Inturi
Informix Software Engineer
HCL Software

Read more

Admin-Scout 2.4 - Development and Release Steps

Admin-Scout 2.4
Development and Release Steps

feature 100x100
New features
improved 95x100
Improved properties
changed 107x100
Important amendments
bugfix 100x100
Bug fixes
   

Read more

IBM Sub-Capacity licensing for Informix and Db2

IBM Sub-Capacity licensing for Informix and Db2

Processor-based licensing with full- and sub-capacity in virtual environments

processor sub-capacityIf Informix or DB2 are to be used in virtual environments, the question of how to calculate licenses quickly arises with processor-dependent licenses. Is a calculation based on logical resources sufficient or must the physical hardware be fully licensed?

IBM offers two concepts for this: Full-capacity for the licensing of the entire physical resources, sub-capacity for licensing using the resources of a virtual environment.

This article is a brief summary of the various IBM sources for licensing Informix or Db2 in virtual environments. It introduces the common processor-based licensing and the associated definitions for full- and sub-capacity. This article also provides a summary of the general requirements and important information about the verification requirements when using sub-capacity licensing.

Overview
  • Introduction Processor Core

  • VPC - Virtual Processor Core licensing

  • PVU - Processor Value Unit licensing
    PVU - licensing with full-capacity
    PVU - licensing with sub-capacity

  • LUS - Limited Use Socket licensing
    LUS - licensing, full- and sub-capacity

  • Sub-capacity licensing, general requirements and important verification requirements

Read more

Informix 271 Could not insert new row - downtime prevented

Informix 271 could not insert new row -
downtime prevented

For our customers, we monitor existentially important and time-critical database systems.
For comprehensive monitoring and alerting, we naturally use our own tool, the Admin Scout for Informix.

In this real-life example, a parameter has reached the defined alarm threshold.
The Admin-Scout sends an e-mail to CURSOR Informix Support:

**************************************************

Notification Type: PROBLEM
Service: informix-checkalert
Alert color: RED

Message:
database: tablename has 16777215 pages, free are 1248744 pages
pagesisze is 2k maximum is 16.7 Mio pages

**************************************************

Meaning of the alarm

A table has allocated the maximum number of pages and the free pages are less than 10%.
As soon as the free pages are already used, all attempts to write to this table are aborted.

Read more

References and examples for Informix Monitoring with CURSOR

Zufriedener Administrator, Informix Support mit CURSOR

Informix Monitoring - References and Examples

Here you will find special problems and their solutions - get an idea of our services!
  • We support customers who are active in security-relevant areas or customers who use Informix as a central and sensitive part of their data infrastructure. In this context, all examples were made anonymous.
  • For a personal reference, we will be happy to arrange direct contact for you - please contact us!

Read more

IBM Db2 V11.5 Revised information - Announcement ENUSZP19-0640 (2019-10)

IBM Announcement ENUSZP19-0081IBM Announcement ZP19-0640 with revised information about IBM Db2 11.5. This announcement replaces the previous announcement ZP19-0261, dated 4 June 2019
(IBM Europe Software Announcement ZP19-0640, dated October 29, 2019)

This announcement offers:

  • Introduction of the new Db2 editions for production and non-production deployment.
  • Correction of the data for the Db2 Community Edition,
    allowed for productive use but no support, replacement of the Db2 Lite Edition.
  • Overview about Db2 11.5 enhancements and improvements.
  • Program charges – Description of Virtual Processor Core Licensing.
  • Migration Entitlements and movement of previous editions to Db2 11.5.
  • Supporting program update (Advance Recovery Feature, Q-Replication Feature …)
    and a list of discontinued features (IBM MQ, IBM Cognos Analytics, …).
  • Db2 and hybrid data management (Hybrid Data Management Platform offering).
  • Charge metric and License Information.

Read the excerpts about the new editions and the replacement of the Db2 Workgroup Edition
(For a complete overview please use the link to the PDF download at the end of this article)

Read more

Informix V14.10.xC2 Editions offer extended Limits

Informix V14.10.xC2 Editions offer extended Limits

Informix 14.10. extended limitsInformix Release 14.10.xC2 of September 2019

For the Informix Developer, Informix Express and Informix Innovator-C Editions, IBM increases CPU and memory usage limits with release 14.10xC2.

The increase makes Informix even more attractive for small and medium-size applications.

The upgrade was made without a special announcement - through changes in the license terms with the release of Informix 14.10.xC2.

Customers who upgrade to this version with a new license or an update as part of their product maintenance, will benefit from the enhancements. The extensions do not apply to older releases, also because the limits are fixed in the source.

Read more

IBM Db2 Workgroup replaced by Db2 Standard Edition V11.5

IBM Db2 Workgroup replaced by Db2 Standard Edition V11.5

IBM announces important changes in the Db2 portfolio with Announcement  ZP19-0261 and  ZP19-081 of June 4, 2019

IBM will offer the Db2 database system only over three editions:

The Db2 Standard and Db2 Advanced Edition will be licensed only through the Virtual Processor Core Metric (VPC)
(or for non-productive systems by Authorized Users). For existing licensing, conversions to VPCs will be provided.

The Db2 Workgroup Edition is currently in conversion. No new licenses will be offered for it and from 1.11.2019 no maintenance extensions will be offered. There will be a conversion to the Db2 Standard Edition and VPC licensing.

Customers using Db2 Workgroup Edition now have to check their current and future licensing.
After a conversion to VPC licensing, they may be significantly underlicensed!

Read more

IBM Db2 V11.5 Enhancements - Announcement ENUSZP19-0261 (2019-06)

IBM Announcement ENUSZP19-0081IBM Db2 V11.5 delivers enhancements to help automate data management, eliminate ETL, and support artificial intelligence data workloads
(IBM Europe Software Announcement ZP19-0261, dated June 4, 2019)

The IBM Db2 family of hybrid data management solutions is built on an intelligent common SQL engine that is designed for scalability and flexibility and to run on premises, in private, and on any public cloud. Db2 uses open source technology and provides a singular view of data, enabling businesses to automate data management, eliminate ETL, and support artificial intelligence (AI) data workloads.

IBM Db2 V11.5 offers database efficiency, simplicity, and reliability in the form of new features and enhancements that address a wide variety of business requirements. Robust enterprise security, simplified installation and deployment, improved usability and adoption, a streamlined upgrade process, enhancements to large databases, and improvements to BLU Acceleration are the key benefits of this technology:

  • 4K sector support
  • Improved CF recovery time
  • New monitoring metrics
  • Automatic Recompress feature for tables
  • Call level interface (CLI) driver enhancements

Other enhancements to the IBM Hybrid Data Management Platform include:

  • New version of IBM Db2 Event Store 2.0.
  • Application compatibility, standardized API, flexible licensing, and operational compatibility with the Db2 family (now part of the same Common SQL Engine capabilities).

One of the most significant impacts for Db2 customers is the introduction of three new editions that will gradually replace the existing editions from summer 2019. The Db2 portfolio will be based on the Db2 Lite Edition, Db2 Standard Edition and Db2 Advanced Edition. Besides Authorized User Licensing for non-production environments, Virtual Processor Client Licensing will be an unified licensing metric.

Part number description
Part number
Pogram ID
IBM Db2 Advanced Edition
VPC Option Virtual Processor Core
License + SW Subscription & Support 12 Months
D233MLL 5737-K73
IBM Db2 Advanced Edition
VPC Option Virtual Processor Core
Annual SW Subscription & Support Renewal 12 Months
E0Q5ULL 5737-K73
IBM Db2 Standard Edition
VPC Option Virtual Processor Core
License + SW Subscription & Support 12 Months
D233RLL 5737-K74
IBM Db2 Standard Edition
VPC Option Virtual Processor Core
Annual SW Subscription & Support Renewal 12 Months
E0Q5WLL 5737-K74
IBM Db2 Lite Edition
VPC Option Virtual Processor Core
Monthly License
D233XLL 5737-K75
IBM Db2 Developer C
Authorized User
Monthly License
D2340LL 5737-K75
IBM Hybrid Data Management Platform
On-Premise Authorized User
License + SW Subscription & Support 12 Months
D233VLL 5737-K76
IBM Hybrid Data Management Platform
On-Premise Authorized User
Annual SW Subscription & Support Renewal 12 Months
E0Q5YLL 5737-K76
Examples for some selected DB2 products, please read the full announcement for a complete overview!

Read more

IBM Software Withdrawal ZP19-0081 (2019-06)

IBM Announcement ENUSZP19-0081Software withdrawal: IBM Db2 product family selected part numbers
(IBM Europe Withdrawal Announcement ZP19-081, dated June 4, 2019)

Clients with existing entitlements to the Db2 Workgroup Server Edition will receive a corresponding number of entitlements to the Db2 Standard Edition. For some clients, these entitlement ratios will potentially not be sufficient to cover the current set of Db2 deployments. For these clients, contact an IBM representative to ensure the correct number of entitlements for your current deployments as of April 30, 2019 are fully licensed.

Effective June 4, 2019, IBM will withdraw from marketing part numbers from the following programs licensed under the IBM International Program License Agreement:

Examples for some selected DB2 products, read the full announcement for a complete overview!
Withdrawn part number description
Part number
Withdrawal
Replacemet part number description
Part number
Avialability
IBM Db2 Workgroup Server Edition
Authorized User Single Install
License + SW Subscription & Support 12 Months
D5B77LL Sept. 2, 2019 IBM Db2 Standard Edition
VPC Option Virtual Processor Core
License + SW Subscription & Support 12 Months
D233RLL June 27, 2019
IBM Db2 Workgroup Server Edition
Authorized User Single Install
Annual SW Subscription & Support Renewal
E1B79LL Nov. 1, 2019 IBM Db2 Standard Edition
VPC Option Virtual Processor Core
Annual SW Subscription & Support Renewal 12 Months
E0Q5WLL June 27, 2019
IBM Db2 Workgroup Server Edition
Limited Use Socket
License + SW Subscription & Support 12 Months
D0A1LLL Sept. 2, 2019 IBM Db2 Standard Edition
VPC Option Virtual Processor Core
License + SW Subscription & Support 12 Months
D233RLL June 27, 2019
IBM Db2 Workgroup Server Edition
Limited Use Socket
Annual SW Subscription & Support Renewal
E07BQLL Nov. 1, 2019 IBM Db2 Standard Edition
VPC Option Virtual Processor Core
Annual SW Subscription & Support Renewal 12 Months
E0Q5WLL June 27, 2019
IBM Db2 Workgroup Server Edition
Processor Value Unit (PVUs)
License + SW Subscription & Support 12 Months
D55TWLL Sept. 2, 2019 IBM Db2 Standard Edition
VPC Option Virtual Processor Core
License + SW Subscription & Support 12 Months
D233RLL June 27, 2019
IBM Db2 Workgroup Server Edition
PVU Option Processor Value Unit (PVU)
Annual SW Subscription & Support Renewal
E024RLL Nov. 1, 2019 IBM Db2 Standard Edition
VPC Option Virtual Processor Core
Annual SW Subscription & Support Renewal 12 Months
E0Q5WLL June 27, 2019
IBM Db2 Workgroup Server Edition
Virtual Server
License + SW Subscription & Support 12 Months
D1MHTLL Sept. 2, 2019 IBM Db2 Standard Edition
VPC Option Virtual Processor Core
License + SW Subscription & Support 12 Months
D233RLL June 27, 2019
IBM Db2 Workgroup Server Edition
Virtual Server
Annual SW Subscription & Support Renewal 12 Months
E0MKTLL Nov. 1, 2019 IBM Db2 Standard Edition
VPC Option Virtual Processor Core
Annual SW Subscription & Support Renewal 12 Months
E0Q5WLL June 27, 2019
Examples for some selected DB2 products, read the full announcement for a complete overview!

Read more

Announcement of IBM price adjustments for Informix 14.10

Announcement of IBM price adjustments for Informix 14.10

PreisupdateIBM announces worldwide price adjustments for its software portfolio with an announcement on September 10th. This includes Informix products from January 1, 2020.

For sales within the Federal Republic of Germany, Informix prices will be increased by approximately 3%. This applies to both new licenses and product maintenance (renewals).

Registered visitors can view IBM's prices for Informix 14.10 here!

An excerpt from the announcement can be found here:

Read more

Informix 14.10 - Informix Client-SDK support for 32-bit applications

Informix 14.10 - Client-SDK support for 32-bit applications

toolsMany applications based on Informix have two things in common: existential importance for the company and exceptionally long periods of use. It is not surprising that many long-established solutions are available as 32-bit versions.

With the introduction of Informix 14.10 in April 2019 and the current Client-SDK 4.5, HCL and IBM no longer offer 32-bit portings for the new versions.

For software engineering reasons, many 32-bit applications can only be ported to 64-bit with great effort. Will these applications not be able to run on Informix 14.10 in the future?

The main question is, will 32-bit applications continue to be supported, and if so, for how long?

CURSOR recognized this problem early and pointed out the need for a solution to IBM and HCL.

Read more

Admin-Scout 2.3 - New Scheduler Module

Admin-Scout 2.3 - New Scheduler Module

schweissen 600x400cWe asked the question, which areas of an Informix database system have to be administered manually and where is it possible to set up an automated administration? The goal is to achieve increasing automation and independent optimization of the system through an interaction of sensors and tasks.

An important aspect here is the administration of the internal database processes. Senior administrators still know how to set up recurring tasks via a cronjob. Today's Informix editions offer independent job management, including the creation of custom tasks and sensors with dedicated result tables and reports.

Informix provides an SQL API and corresponding commands as a basis for setting up tasks. If you are an Informix administrator and are rarely concerned with setting up and managing tasks and sensors, you will find that this can quickly become a complex challenge. Therefore, in the new version of our Admin-Scout, we have intensively addressed the topic of a task scheduler and developed a new Admin-Scout module for the administration of tasks and sensors.

The new Admin-Scout 2.3 Scheduler module offers a centralized administration of all tasks and sensors

Read more

Admin-Scout 2.3 - Overview new features in version 2.3

Admin-Scout 2.3 - Overview new features in version 2.3

Informix secure SSL connectionAlready in the last versions many improvements were introduced for the security of the Admin Scout. It was very important for us that during a login no more passwords are transferred between Admin-Scout and the browser.

Version 2.3 continues our efforts to provide increased security against data spying between Informix Server and client or our Admin-Scout.

Overview of the new features:
  • https port is now active - generating of a self-signed certificate.
  • Setting up an encrypted SSL connection on the database port.
  • Easier selection of instances - access to instances of different groups.
  • Autologon-Feature – automatic connection to a standard instance.
  • New Scheduler module - all Scheduler modules are now available in one place.
  • New module Cluster Configuration.
  • New module DBSpace Layout History.
  • Backup/Restore now with SQL Editor Files.
  • Additional reporting on the InformixHQ Monitoring Database.

Read more

Setting up a secure SSL connection for Informix servers and clients

Setting up a secure SSL connection for Informix servers
and clients

Informix SSLIn public, but also in private networks, there is a potential risk that a connection between a database server and a client can be intercepted.

The best way to prevent eavesdropping is to establish an encrypted connection. Informix provides an easy way to set up secure SSL connections. Server and clients have a private key that is exchanged before the connection is established. The key is stored both on the server and on the client in an encrypted keystore.

This article describes how to set up a secure SSL connection for Informix servers and clients with a few commands.

The starting point for this article is based on the development of the CURSOR Admin-Scout. Informix administration with the Admin-Scout is done classically via a server-client connection. For us it was an important concern to secure this connection according to approved techniques. The second part of this article therefore describes how to set up an SSL connection between the database server and the Admin-Scout.

Read more

Informix Virtual Processor Core Licensing

Informix Virtual Processor Core Licensing

Simplified licensing of CPU cores with Informix 14.10Informix Virtual Processor Core Licensing

With the release of Informix 14.10, IBM offers a new licensing option. Except for special licensing models for ASL/ESA resellers, Informix installations are usually licensed by user or processor power.

Many sales partners criticize the licensing according to Processor Value Unit calculation (PVU licensing), as too complicated and too little comparable in their calculations. In software projects, the target platform is often still uncertain in the offer phase. PVU licensing cannot be offered to potential customers because the basis for a calculation is not known at this point.

Here, the new licensing of processor cores now offers a more reasonable alternative, which impresses with its simplicity of evaluation and price advantages over PVU licensing.

Read more

European IBM Informix Days 2019

European IBM Informix Days 2019IBM Informix Tage 2019

June 3 and 4 at the IBM Watson IoT Center in Munich

This year IBM is offering an international event for Informix customers from the European countries.

The two-day event scores with contributions directly from the Informix development and support departments. Among others, Informix Chief Architect, Shawn Moe, will present new features that are included in the recently released Informix Version 14.10.

Like the Informix Technology Days of the last few years, there will be in-depth lectures on technical topics. This also includes examples of new applications from Informix - especially from the Internet of Things (IoT) area. Best practice reports, directly from Informix users, complete the conference program.

On the evening of the first day a dinner is planned to enhance the networking between the participants.

Take advantage of the many opportunities to share experiences not only with other Informix customers and partners, but also with IBM and HCL employees.

Invited are all customers, partners and interested parties who are in contact with IBM Informix. As this year's event is aimed at participants from all over Europe, the presentations will be in English.

The event is free of charge, no participation fees will be charged.
Please register as soon as possible for the European IBM Informix Days 2019!

Of course the Informix team of CURSOR Service Distribution will also participate in this event.

We look forward to meeting you and invite you to join us for some exciting discussions about the use and the administration of Informix!

Read more

IBM Cognos pricing information 2020

IBM Cognos - price information 2020

Below mentioned list contains the basic product prices of the IBM.

2020

iconThe download of the document "PA-COG-20-01-01-XLS" is only for registered users available. You can register or subscribe here. The download link appears here after a reload.

iconThe download of the document "PA-COG-20-01-01-PDF" is only for registered users available. You can register or subscribe here. The download link appears here after a reload.

Read more

IBM DB2 V11.1 Packaging and Pricing Update July 2016

Main changes announced in ZP16-0191 and ENUS916-003 in July 2016 released.
Short overview about the important impacts:

 Main changes
  • New Packaging Enhancements
  • DB2 Enterprise and Advanced Enterprise Edition price increase (about 10%)
  • DB2 Workgroup Edition includes additional features at a much lower price (decrease about 36%)
  • DB2 Workgroup Edition Socket pricing metric is no longer available
  • DB2 Express Edition is no longer available, migration path is DB2 Workgroup Edition
  • DB2 Express-C (Community Edition) will still be provided
  • DB2 Direct license offers an attractive price for deploying DB2 in the cloud or on premise using a Virtual Processor Core Metric
  • Database Encryption is now included in all DB2 V11.1 editions with no additional charge
  • Base Federation is included in all DB2 Editions (DB2 and Informix)

 Withdrawals
  • DB2 Version 10.5 and all Business Value Offerings are being withdrawn from marketing on September 30th, 2016
  • DB2 V9.7, 10.1 will be end of service on September 30th, 2017
  • DB2 Express Server Edition withdraw from marketing on September 30th, 2016 – Replacement part: DB2 Workgroup Server Edition

 DB2 V11 major features included
  • Improved enterprise encryption support
  • Faster up and running for pureScale installation
  • New Sync and Near-Sync support for HADR in a pureScale environment
  • Additional support for Power Linux Little-endian (LE) and pureScale
  • Virtualization support of RDMA adapters in a VMWare environment
  • Higher throughput in large database systems
  • Easier upgrade process and direct upgrade from 9.7 systems
  • BLU support on MPP clusters
  • Faster query processing for BLU queries and support for generated columns, row and column access control and additional functions pushed down into the columnar engine
  • Additional SQL support in DB2 including some Postgres syntax, new data types and many new functions
  • A new code page for BLU systems (Codepage 819 for European languages)

DB2 11.1 Packaging news & changes

Database Encryption
  • Database Encryption is now included in all DB2 V11.1 editions with no additional charge
Base Federation
  • Base Federation is now included in all DB2 Editions (DB2 and Informix)

    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 Advanced Server editions include all of the wrappers that are part of the federation support. The DB2 Workgroup and Enterprise Edition products only include support for connecting to DB2 and Informix targets.
DB2 Express & Express-C Edition
  • The DB2 express version will no longer be offered in DB2 V11.
    Existing customers will be migrated to the DB2 Workgroup Edition.
  • DB2 Express-C (Community Edition - free and unsupported version) will still be provided.
    For customers who need support Workgroup Server Edition is the entry point.
DB2 Workgroup Server Edition
  • In order to make the Workgroup Edition more appealing to customers, the price has been reduced significantly (decrease about 36%) and
  • numbers of additional features have been included into the package including:
    - pureScale Standby Node Option
    - Table partitioning, Encryption
    - Multi-dimensional Clustering
    - Federation (DB2 & Informix only)
  • The one big change in the licensing of DB2 Workgroup Edition is that there is no longer a cap on the size of database. The core limit remains the same (16 cores), but the amount of main memory has increased to 128GB.
  • The Socket pricing metric for Workgroup Edition is no longer available in this release.
    However, existing customers will continue to pay S&S on this metric, but new customers will not be able to purchase this feature.
Enterprise Edition
  • There are no limits on the cores, memory or database size with Enterprise Edition.
  • In order to make the Enterprise Edition more appealing to customers a number of additional features have been included into the package including:
    - pureScale Standby Node Option
    - Table partitioning, Encryption
    - Materialized Query Tables
    - Multi-dimensional Clustering
    - Federation (DB2 & Informix only)
Optional products

There are two optional products that customers may want to purchase for Workgroup or Enterprise Edition:

  • DB2 Performance Management Offering (WLM)
    which is part of the Data Server Manager Enterprise Edition. This offering helps organizations manage their 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.
  • DB2 Advanced Recovery Feature for Linux, UNIX, and Windows 11.1
    is available in conjunction with the DB2 11.1 database release. This feature consists 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.
Advanced Workgroup and Advanced Enterprise Edition
  • As with the prior release of DB2 Version 10.5, the Advanced versions of Workgroup and Enterprise Edition include all features for one single price.
  • New in this release is the Federated feature which includes connectivity to DB2, Informix, and a large number of other relational and unstructured data sources.
  • There are three products that are included as part of the Advanced Editions that have limits on the amount of users that they can have. These features are:
    - DB2 Connect included for using SQW tooling to access DB2 for z and DB2 for i
    - InfoSphere Data Architect limited to 10 authorized users
    - Cognos Analytics limited to 5 authorized users
  • The only optional product that customers may want to consider is the Advanced Recovery Feature.
    This feature consists 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.
DB2 Direct Editions
  • DB2 Version V11.1 includes a new delivery mechanism for licensing.
  • The DB2 Direct Editions are intended to make it easier for a customer to acquire DB2 licenses for cloud deployments. It doesn't matter where the customer places their DB2 server, on premise or on cloud. They are licensed by the number of Virtual Processor core (VPC). The license is totally flexible and can be moved between platforms without any change in license fees. Note that this license is an OPEX (Operating Expense) license. The customer is renting or leasing the DB2 license. The price includes the use of the product as well as service and support. If the license is not renewed, the customer has no valid license to run the database.
  • There are two DB2 Direct editions, depending on what the database requirements are:
    - DB2 Direct Standard Edition 11.1 - has all of the database features of DB2 Workgroup Server Edition
    - DB2 Direct Advanced Edition 11.1 - has all of the database features of DB2 Advanced Enterprise Server Edition

Pricing Juli 2016

  • The price increase announced in June 2016 include a 10% increase for DB2 Advanced Server Edition and DB2 Enterprise Server Edition.
  • The price decrease for DB2 Workgroup Edition (PVU) & (AUSI) is about 36% to offer this Edition as a new entry point for DB2.

End of Marketing for DB2 Version 10.5 and Features

End of marketing means that customers will not be able to purchase DB2 Version 10.5 after the end of September, 2016. At that time they will only be able to purchase DB2 Version 11.1.

End of Marketing for DB2 Version 10.5 (September 30th, 2016)
  • All DB2 Editions and features/offerings
  • Performance Management Feature Version 10.5
  • Tools and DB2 Connect Version 10.5
End of Marketing for DB2 Business Value Offerings
  • IBM DB2 Encryption Offering Provides data encryption at rest, and
  • IBM DB2 Business Application Continuity Offering
    both now included in Workgroup and Enterprise Editions in 11.1 without charge
    Existing customers will drop S&S on feature once Instance upgraded to 11.1
  • IBM DB2 BLU Acceleration In-Memory Offering
    Provides columnar and dynamic in-memory acceleration
    Existing customers get a license exchange to Advanced Workgroup (AWSE) or Advanced Enterprise Server Edition (AESE)

For those customers who purchased any of the Business Value Offerings, they will be migrated to a different license of DB2 depending on which license they had when they purchased the BVO. The Encryption and BAC Offering will bundled with every version of DB2, so customers that purchased that feature will no longer have to pay service and support on it. Customers with the DB2 BLU BVO can request a manual license migration from WSE/ESE + BLU to AWSE/AESE.


Announcements

view blue 64x64IBM DB2 11.1 with BLU Acceleration,
the multiworkload database software for the next generation of database deployments
ENUSZP16-0191, dated April 12, 2016

view blue 64x64Software withdrawal and support discontinuance: IBM DB2 selected products
ENUSZP16-0003, dated April 12, 2016


invispix 10x10
invispix 10x10
OEM/ESA licensingOEM/ESA licensing

IBM OEM licensing

Informix for purchaserInformix for purchaser

Informix for purchasers

IBM Db2 for purchasersIBM Db2 for purchasers

IBM Db2 for purchasers

Service und SupportService und Support

Service and Support

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.