News for IBM Informix, Db2, Tools and Services
  |
Informix News
|
|
  |
IBM Db2 News
|
|
  |
Admin-Tools News
|
|
  |
Service News
|
|
  |
Archived articles
|
|
New posts |
IBM Db2 Base Edition Overview
Db2 11.5.4 extends its offering portfolio with the introduction of the new IBM Db2 Base Edition V11.5.4 as perpetual and monthly software licenses for production and nonproduction use. Db2 Base Edition is designed for small-to-medium-sized projects and to help developer and business partner communities. While Db2 Base Edition offers the same functionality as the IBM Db2 Advanced and IBM Db2 Standard editions, it is restricted in the size of the deployment.
Db2 Base Edition can use a maximum of 8 Virtual Processor Cores and 64 GB of RAM.
Db2 11.5.4 for Linux, UNIX, and Windows brings more flexibility with an improved portfolio that features a simplified set of four editions with one charge metric for production. The four editions are:
All four editions have the full feature capabilities of Db2, making it easier to choose the right edition with the capabilities and tools that are required to meet your organization's data management needs.
For more details and the limits of each edition, please download and read the full Announcement here.
Hello IIUG Members and Informix Enthusiasts!You are invited!
Join IBM for User Group Day, a unique virtual experience. IBM is uniting over a dozen IBM User Groups for a 2-day virtual conference with 6 tracks each day featuring user groups, offering management, developers and support staff with expert advice, lessons, demos, keynotes, feedback sessions, and more. Learn more about the technologies you use every day, start a conversation, ask questions, or find new User Groups to connect with.
Technical sessions, more than 15 different areas, ranging from AI, Automation, Cloud Integration, Cloud Pak for Data, Cognos, DataOps, Data Science, Db2, IBM Z, Informix, Maximo, Netcool, Netezza, Open Source, Planning Analytics, Public Cloud, Security, Storage and Websphere and more. This may be the largest IBM Community Virtual event all year! No matter your technology, tool, or proficiency, you will find something here to grow your skill set.
Summary
Live sessions will be from 8 AM (08:00) to 4:30 PM (16:30) Eastern Time US and replays of all sessions will be available.
Please share this event and leverage your co-workers, friends and online social channels to help us promote IBM User Group Day.
Get the full IBM User Group Day agenda and register for free visit here!
IBM Community Informix Webcast:Summary:
Common Table Expressions (CTE) are a SQL standard feature, CTE simplify queries and make queries more readable. Use recursive CTE to query hierarchical data, and tree/graph structured data. Also, you can do programming tasks with CTE.
Join this session to hear more about and see a demo with Informix 14.10 release support of:
Speaker:
Jinming Xiao
Informix SQL/Optimizer Engineer
HCL Software
Jinming Xiao joined Informix on 1999, has been working on different Informix components like security, networking, and SQL/optimizer.
Planning for Q2 and the second half of 2020
Innovations for 2021 (under investigation)
Admin-Scout 2.4
|
 |
New features |
 |
Improved properties |
 |
Important amendments |
 |
Bug fixes |
If 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.
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
Here you find a selection of actual license texts to the IBM DB2 products.
When it comes to the details licensing can be a complicated, yet rewarding subject. The right licensing creates security for the application and cost benefits in their use.
If for existing or planned installations, we advise you willingly if you have license questions to DB2.
Informix 271 could not insert new row -
|
IBM Announcement ZP19-0640 with revised information about IBM Db2 11.5. This announcement replaces the previous announcement ZP19-0261, dated 4 June 2019This announcement offers:
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)
Informix Release 14.10.xC2 of September 2019For 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.
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.
IBM Db2 V11.5 delivers enhancements to help automate data management, eliminate ETL, and support artificial intelligence data workloadsThe 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:
Other enhancements to the IBM Hybrid Data Management Platform include:
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 |
Software withdrawal: IBM Db2 product family selected part numbersClients 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:
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 |
IBM announces worldwide price adjustments for its software portfolio with an announcement on September 10th. This includes Informix products from January 1, 2020.
Registered visitors can view IBM's prices for Informix 14.10 here!
An excerpt from the announcement can be found here:
Many 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.
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?
We 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.
Already 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.
In 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.
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.
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.
| |
Informix News
|
|
| |
IBM Db2 News
|
|
| |
Admin-Tools News
|
|
| |
Service News
|
|
| |
Archived articles
|
|
