Actual news from CURSOR Service Distribution
|
|
||
  |
Informix News
|
|
  |
IBM Db2 News
|
|
  |
Admin-Tools News
|
|
  |
Service News
|
|
  |
Archived articles
|
|
View the latest articles here |
|
|
||
| |
Informix News
|
|
| |
IBM Db2 News
|
|
| |
Admin-Tools News
|
|
| |
Service News
|
|
| |
Archived articles
|
|
View the latest articles here |
Informix 271 could not insert new row -
|
Informix 14.10 tuning tips to go beyond secondary performance improvementsSummary:
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.
Speaker:
Vladimir Kolobrodov
Informix Performance Engineer
HCL Software
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.
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?
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.
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.
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.
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!
Below mentioned list contains the basic product prices of the IBM.
The download of the document "PA-COG-19-01-01-XLS" is only for registered users available. You can register or subscribe here. The download link appears here after a reload.
The download of the document "PA-COG-19-01-01-PDF" is only for registered users available. You can register or subscribe here. The download link appears here after a reload.
The 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.
The 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.
Below mentioned list contains the basic product prices of the IBM.
The download of the document "PA-IFX-19-05-01-XLS" is only for registered users available. You can register or subscribe here. The download link appears here after a reload.
The download of the document "PA-IFX-19-05-01-PDF" is only for registered users available. You can register or subscribe here. The download link appears here after a reload.
The download of the document "PA-IFX-19-10-01-XLS-2020.xlsx" is only for registered users available. You can register or subscribe here. The download link appears here after a reload.
The download of the document "PA-IFX-19-10-01-A4-2020.PDF" is only for registered users available. You can register or subscribe here. The download link appears here after a reload.
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
|
 |
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.
IBM software withdrawals for various Informix versions - ENUSZP19-0171 (2019-04).With the 137-page Announcement of April 9. 2019, IBM announces new End-of-Marketing (EOM) and End-of-Support (EOS) dates for a variety of products. Informix 11.7.x versions and Informix Advanced Workgroup Edition 12.10 will also be affected.
For the 11.7.x versions Informix 12.10 or Informix 14.10 are available as replacements.
| Progr. ID | Name | Version | End-of-Service | Replacement |
| 5725-D14 | IBM Informix Ultimate Warehouse Edition | 11.7.x | Sept. 30. 2020 | 14.1 |
| 5725-A39 | IBM Informix Ultimate Edition | 11.7.x | Sept. 30. 2020 | 14.1 |
| 5725-A40 | IBM Informix Growth Edition | 11.7.x | Sept. 30. 2020 | 14.1 |
| 5724-Z04 | IBM Informix Express Edition | 11.7.x | Sept. 30. 2020 | 14.1 |
| 5724-C41 | IBM Informix CISAM | 7.24.x | April 30. 2020 | 7.25 |
| 5724-C43 | IBM Informix SE | 7.24.x | April 30. 2020 | 7.25 |
| 5724-C55 | IBM Informix SQL | 7.32.x | April 30. 2020 | 7.50 |
| 5724-C66 | IBM Informix 4GL Complier | 7.32.x | April 30. 2020 | 7.50 |
| 5724-C66 | IBM Informix 4GL Rapid Development System | 7.32.x | April 30. 2020 | 7.50 |
| 5724-D27 | IBM Informix DataBlade Workgroup bundle | 1.0.x | April 30. 2020 | No replacement |
IBM Informix V14.10 enhances all editions, bringing improvements to performance, security, administration, and core database capabilitiesIBM Informix V14.10 provides a powerful, reliable, and low-cost data platform for mission-critical business environments. Informix V14.10 builds on its powerful feature set with new capabilities and improvements in various areas, including support for online transaction processing (OLTP) and replication workloads, time series and spatial data, and enhancements to data security. Informix continues to provide optimized performance and reliability in a cost-effective and simple-toadminister database platform that is designed for continuous availability of critical data resources.
IBM Informix V14.10:
• Enhances performance of secondary backups and OLTP transactions
• Provides higher security for encryption keys and Transport Layer Security (TLS)
• Enhances usability, streamlines administration, and increases uptime
• Provides new graphical administration tool called InformixHQ
• Enhances Unicode support to current V11 specifications
• Enhances time series granularity and spatial projection systems
• Updates platform support to current 64-bit OS levels
• Increases hardware limits at the Workgroup Edition level
• Includes storage optimization at the Enterprise Edition level
Giessen, February 2019
CURSOR Service Distribution is part of the Informix 14.10 beta testing team. The impression we have of version 14.10 can only be revealed after the official release. Some details have already been published by the International Informix User Group (IIUG). We will take this generally available information as a starting point and briefly present the most important new features.
Allowed resources increased from 16 GB to 32 GB main memory and from 16 CPU cores to 24 cores.
Especially technology partners will be pleased with this long-awaited expansion as it significantly improves the performance and scope of the Workgroup Edition, which is an important edition for integrators.
Storage Optimization (data compression) becomes a general part of the Enterprise Edition.
All Informix 14.10 Enterprise Edition deployments now benefit from the long-established Storage Optimization feature. For customers already using data compression, the average database size has been reduced to a quarter, resulting in faster I/O operations and faster backups.
Data compression reduces storage requirements for primary-, secondary-, backup-, and log-data while improving performance by reducing I/O operations.
Improved replication enables client applications to maintain virtually latency-free connectivity between primary and secondary servers. This enables faster recovery in the event of server failure.
Set up enterprise level replication of Informix instances or databases with Enterprise Replication.
It is a single command that automates enterprise replication setup and data migration between two Informix server instances, on-premise or in the cloud. This command automates tasks such as defining the enterprise replication domain between the two servers, adding key columns for the tables, creating the required storage space for the databases, copying database schemas from the source server to the target server, creating replication definitions, and finally synchronizing data between source and target server instances, all in a transactional, flexible, tiered manner with no downtime.
InformixHQ is the new web console for visualizing, monitoring and managing Informix server instances. InformixHQ is specifically designed for easy operation, scaling and optimization of development and administration requirements and is shipped as part of version 14.10.
InformixHQ provides capabilities for monitoring critical performance parameters. The monitoring system can be integrated directly into an alarm system so that administrators can be notified immediately by e-mail, Twilio or PagerDuty.
InformixHQ is scalable and can efficiently monitor all Informix database server instances within an organization.
As an Informix service and support provider, we paid special attention to the new administration tool during the beta test. We will report in detail in a later article about the state of "the emperor's new clothes".
Informix 14.10 improves the granularity of time series and spatial projection.
By supporting subsecond time stamps, it can be used in environments with a very fast sequence of events.
For logistics, support for additional geodetic and projective systems will be introduced. This makes it possible, for example, to track shipments in their own coordinate system.
Informix 14.10 provides increased security for encryption keys and integrated backup encryption.
By supporting the Remote Key Management Server to generate encryption keys and reducing the DBA effort required to encrypt Informix backups, data protection on backup media is increased without the risk of key loss. The encryption key itself is encrypted (Envelope Encryption).
The implementation of the SQL standard CTE improves the readability and maintenance of complex queries for application developers. Developers can use CTE results multiple times in a query, perform pipeline aggregations, and write powerful recursive queries. Complex queries can be divided into simple, ad hoc logical building blocks.
IBM and HCL have not yet published a release date. Informix insiders expect release 14.10 in Q1-2019 or latest in Q2-2019.
If you don't want to miss the new release, simply register for our
Informix Release Newsletter - we will keep you up to date by e-mail.
|
Software (16.11.2018) IBM My Notifications Check out the IBM Electronic Support |
|
Informix Servers |
|
After installing SUSE Enterprise Linux SP4 kernel 3.0.101-108.57 through 3.0.101-108.71 (inclusive), Informix Dynamic Server versions 11.50, 11.70 and 12.10 will encounter various memory corruption assertion failures and ultimately crash. |
