How Informix can fit Your Database Needs
IBM Systems Magazine Article - Ken Milberg (March 2018)
When most people hear that an IBM database is being evaluated, they naturally think of Db2. While that may be a natural reflex of sorts, IBM has expanded its database offerings over the years with Informix, Netezza and Cloudant—the first of which will be discussed in this article.
Informix is perhaps best known best for being used in high transaction OLTP application environments. In recent years it has been enhanced to support the largest of data warehouse workloads. In 2017, IBM and HCL technologies agreed to a 15-year partnership to co-develop and support the product.
- Why use Informix and what does it do for you?
- How has it evolved and what is it today?
IBM Db2 Warehouse on Cloud adds a new plan offering
independent, on-demand scaling of storage and compute,
enhanced backup and restore, and significant improvements in high availability
(IBM Europe Announcement ZP18-0072, dated January 30, 2018)
IBM Db2 Warehouse on Cloud is a fully managed, enterprise-grade cloud data warehouse service that enables true hybrid data warehousing. To complement the existing SMP and MPP plans, a Flex plan is available that offers the performance of MPP with greater flexibility for consumption and deployment of storage and compute resources. The Flex plan packages three key capabilities: independent scaling of storage and compute, self-service backup and restore, and significant improvements in high availability.
With the Flex plan, clients can fully customize their data warehouse, with the option to increase compute cores during heavy database use. Once the extra demand on the warehouse has subsided, clients can scale back down to reduce their costs. In addition, the Flex plan offers immediate storage expansion, so clients can start with the initial storage they need and increase capacity with a few clicks at a later date to accommodate data growth.
The new Flex plan also gives clients more control over their database backups. With self-service backups, clients can keep up to seven backups of their database. They can choose the time of day their backups are taken, and restore from one of these backups whenever they choose. Significant improvements in service availability have also been made through the IBM Cloud Container Service.
IBM Db2 Enterprise Family Bundle
offers deployment flexibility and a powerful analytics engine to optimize data management within hybrid data environments
(IBM Europe Software Announcement ZP17-0708, dated December 12, 2017)
IBM(R) Db2(R) Enterprise Family Bundle V1.0 brings a new licensing option to increase flexibility and enable you to deploy a combination of offerings to better manage your hybrid data environment. This flexibility helps to optimize the investment associated with shifting data back and forth within the hybrid data environment. Based upon deployment needs, a combination of the following offerings can now be deployed to the extent covered by the specific entitlement:
• IBM Db2 Enterprise Server Edition
• IBM Db2 Warehouse
• IBM Db2 Event Store
Software withdrawal and support discontinuance:
IBM Cognitive Solutions, IBM Hybrid Cloud & Managed Services, IBM Watson & Cloud Platform, IBM Industry Platforms, and IBM Z select products and part numbers - Some replacements available
(IBM Europe Software Announcement ZP17-0450, dated September 12, 2017)
Part of this withdrawal:
Informix Workgroup Limited Use Socket License from marketing
IBM Informix WRKGRP Edition
CPU Option Limited Use Socket License + SW Subscription & Support 12 Months
December 12, 2017
IBM Informix WRKGRP Edition
CPU Option Limited Use Socket SW Subscription & Support Reinstatement 12 Months
December 12, 2017
IBM Db2 on Cloud
enables larger database workloads on Bluemix Dedicated private cloud infrastructure service, bringing public cloud service to private cloud clients
(IBM Europe Software Announcement ZP17-0470, dated September 5, 2017)
IBM Db2 on Cloud (previously known as dashDBTM for Transactions) now offers larger database workloads on IBM Bluemix(R) Dedicated private cloud infrastructure service. Previously available for Db2 on Cloud on the Bluemix public cloud, this new IBM Cloud Service enables sensitive industries using IBM's private cloud service to leverage a simplified database solution that is fully managed and designed for massive amounts of data. IBM Db2 on Cloud is designed to provide private cloud clients with:
• An easy, problem-free way to run Db2. No setup is required and IBM handles maintenance and updates, such as backups and security.
• Optimized storage capacity of up to 48 cores, 1 TB of RAM, and 11 TB of storage space
• An easy-to-use web console for importing and running SQL and administrating the system.
• High availability plans that can minimize downtime. These plans offer a 99.99% uptime Service Level Agreement and rolling updates for security patches.
Revised naming for IBM Db2 family products
(IBM Europe Software Announcement ZP17-0457, dated July 18, 2017)
IBM(R) Db2 is the database of choice for enterprise-wide solutions because it offers extreme performance, flexibility, scalability, and reliability for any size organization. IBM is organizing around the Db2 brand and, as a result, there will be name changes to all of the Db2 offerings. The dashDBTM family will now be renamed to Db2 and DB2(R) will now be referred to as Db2.:
The program numbers, part numbers, terms and conditions, and pricing will remain the same. The program names, service descriptions, and license information documents are updated to reflect the new names. The part number descriptions are updated to reflect the changes to the program names embedded in the descriptions.
IBM IoT Service Offerings
help you design and build Internet of Things solutions
(IBM Europe Software Announcement ZP17-0313, dated June 13, 2017)
With IBM(R) IoT Service Offerings, IBM provides remote consulting based on the IBM Design Thinking methodology to help you identify Internet of Things (IoT) solution areas that have the greatest value. Design Thinking is the IBM approach to developing solutions at the speed and scale the modern enterprise demands. It is a framework for teaming and action.
IBM IoT Service Offerings consists of two offerings:
• In the IBM IoT Design Thinking Workshop, IBM will help you identify your highest-priority IoT use cases and define a minimum viable product (MVP).
• With the IBM IoT MVP Build-up, IBM will help you validate your IoT solution and create an implementation plan for your MVP.
These offerings are delivered remotely.
Informix Technology Day 2017
Pradeep Muthalpuredathe / Director - WW Informix Engineering
Pradeep Muthalpuredathe present the basics of the collaboration between IBM and HCL and the roadmap for the coming years at the Informix technology day.
HCL has taken over development and support on May 1. Most of the development and support staff have agreed to a change to HCL so that the usual contacts and existing structures are available to customers.
For IBM Informix customers nothing changes in the licensing or maintenance. IBM will continue to sell Informix through the IBM channel.
We asked Informix users, IBM partners and employees about their views on the IBM/HCL partnership. The responses were very positive because it is a long-term partnership and a god perspective for the future of Informix.
Key Highlights / part of presentation Pradeep Muthalpuredathe