Informix 14.10 tuning tips to go beyond secondary performance improvements
Webcast: Dec 5, 2019 from 10:00 AM to 11:00 AM (ET) / 17:00 (CET)
In Informix 14.10, the logical log transfer and replay mechanism was completely overhauled, resulting in greatly improved speed!
Informix 14.10 now supports replication with no delay for the transactional rates of up to 5 - 8 times higher compared to previous Informix releases (v.12.10 and earlier).
Performance improvements in 14.10.xC1 will be discussed and tips for tuning performance of the Informix RSS, SDS, HRD cluster clusters will be provided.
Informix Performance Engineer
Vladimir Kolobrodov is a Performance Architect at HCL Software. He's an Informix and hardware guru with over 20 years of experience running Informix in various environments, including PlayStation 3, Raspberry Pi, enterprise POWER, SPARC and Intel systems.
Informix V14.10.xC2 Editions offer extended Limits
Informix 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.
Announcement of IBM price adjustments for Informix 14.10
IBM 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:
Informix 14.10 - Client-SDK support for 32-bit applications
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.
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.
Setting up a secure SSL connection for Informix servers
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.
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.
Informix Virtual Processor Core Licensing
Simplified licensing of CPU cores with Informix 14.10
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.
European IBM Informix Days 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!
IBM Informix 14.10 - Overview / IBM Solution Brief
Just in time for the release of Informix 14.10, IBM has published a new data sheet for Informix. Read an introduction to performance, enterprise replication, security or smart triggers enhancements - and why Informix is the key database for IOT projects!
You can also download and view the data sheet here.
The high-performance, low-footprint
database for analytics on the edge,
in the cloud and on premises
IBM Informix delivers:
- Powerful, optimized time series and geospatial data management
- Automated administration and self-management features
- Footprints under 100 MB for easy IoT gateway embedding
- IBM InformixHQ for collaboration and management across multiple instances
- Integrated in-memory warehouse accelerator (Advanced Enterprise)
Enterprise databases have always been strong when it comes to fast transaction processing and continuous data availability. Informix does this with minimal administration and the highest level of security - in a legendary way.
The Internet of Things (IoT) means new challenges, also for databases. In the future, companies will be confronted with a flood of different data and formats that can be used for analytical monitoring or as a controlling resource.
Many companies have chosen Informix, a solution capable of meeting all their transactional and analytical needs in the enterprise environment as well as in the Internet of Things context. IBM Informix is an easy to integrate, powerful database for processing SQL, NoSQL, JSON, time series or geodata as they occur in the IoT environment. Informix is up and running in minutes and accessible from virtually any desktop, laptop or mobile device. Even when deployed on thousands of devices worldwide, Informix is easy to install and manage. Minimal installation sizes - in some cases less than 100 MB - and the ability to run on distributed devices with a variety of automated management capabilities, make Informix ideal for integration into embedded systems or IoT edge gateways.
Download the IBM Informix 14.10 data sheet here!
In addition to detailed information on the new features, you will also find a table that compares the current editions, Express, Workgroup, Enterprise and Advanced Enterprise.