• Informix 14.10 (21.03.2019)
           

    Informix 14.10 - available now!

    pfeil  
     
    •   CURSOR Admin-Scout: Ready for Informix 14.10
    •   Interesting insights into the new „Informix-HQ“
           
  • Admin-Scout (21.02.2018)

    CURSOR Admin-Scout for Informix

    pfeil  
     
    Database- and System-Monitoring
    with one central tool
           
  • Monitoring ( 3 ) (06.02.2018)
             
     

    Informix Monitoring

    pfeil  
       
    direct supported by CURSOR
  • IIUG 2019 (02.07.2019)
           

    IIUG World 2019

    pfeil  
     
    International Informix Users Group
           
invispix 10x10

IBM Informix

first class enterprise database for OLTP, embedded solutions and IoT

Informix is a secure embeddable database, optimized for OLTP, IoT and is forging new frontiers with its unique ability to seamlessly integrate SQL, NoSQL/JSON, time series and spatial data. Reliability, flexibility, ease of use, and low total cost of ownership makes Informix the best in class enterprise database available in the market (IBM).

 
db oltp 400x200 high end 400x80  

High-End for Online Transaction Processing & Data Warehouse

  • OLTP database for highest demands on performance, transaction security and high availability.
  • Industry-proven in companies with very high transaction volumes: trade, telecommunication, transportation.
  • High availability solutions and cluster concepts.
  • Extremely fast business analytics and warehouse analyses through in-memory technology.
 
db iot 400x200 industrie 40 400x80  

IoT - minimal footprint for the Internet of Things

  • Minimal footprint, server installation from 80 MB.
  • Native Smart-Meter / Time-Series functionality.
  • NoSQL, REST- and MongoDB APIs.
  • Ports for Edge processors (Intel/ARM64).
 
db embedded 400x200 isv ready 400x80  

The embedded database for software vendors and solution providers

  • Easy installation and configuration.
  • Minimal effort for administration and maintenance.
  • Infinitely scalable, from free editions to the high-end enterprise requirements of global enterprises.
  • Customized license and pricing models for software vendors and solution providers.
     

Latest articles about Informix

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

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 2019 IBM 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 Informix 14.10 - Overview / IBM Solution Brief

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)
IBM Informix 14.10 IBM Solution Brief - Download

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.

Read more

IBM software withdrawals for various Informix versions - ENUSZP19-0171 (2019-04)

ZP19-0171IBM software withdrawals for various Informix versions - ENUSZP19-0171 (2019-04).
(IBM Europe Software Withdrawal ZP19-0171, April 9. 2019)
Overview

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.

The Informix Advanced Workgroup Edition will not be continued, IBM will end the offering of this edition on July 9, 2019 (EOM). However, customers who have this edition in maintenance will continue to be supported. A date for the end of support (EOS) has not yet been released.
  • IBM Informix Advanced Workgroup Edition CPU Option Processor Value Unit (PVU) End-of-Marketing: Juli 9. 2019 - no replacements.
For the following Informix versions and programs, IBM will discontinue service and support (EOS) on the date shown:
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

 

Read more

IBM Informix V14.10 enhances all editions ZP19-0078 (2019-03)

ZP19 0078 560x247IBM Informix V14.10 enhances all editions, bringing improvements to performance, security, administration, and core database capabilities
(IBM Europe Software Announcement ZP19-0078, dated March 12, 2019)
Overview

IBM 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

Read more

Informix 14.10 - Release preview

Informix 14.10 - Release preview

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.

Licensing- Informix Workgroup Edition

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.

Licensing- Informix Enterprise Edition

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.

Administration - faster Replication

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.

Administration - Enterprise Replication

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.

Administration – InformixHQ

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".

Industry 4.0 / Logistics

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.

Security

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).

Developer - Common table expression (CTE)

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.

Informix 14.10 - When's the release coming?

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.

release newsletter

Read more

Informix Flash News / SUSE Enterprise Linux SP4 (Nov-26-2018)

Informix Flash News

 

Software (16.11.2018)

IBM My Notifications

Check out the IBM Electronic Support

Informix Servers

Flashes: SUSE Enterprise Linux SP4 Kernel Versions 3.0.101-108.57 through 3.0.101-108.71
Causes Informix Dynamic Server To Crash

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.

The problem seems to be resolved in kernel 3.0.101-108.74 and beyond.

 

Read more

Informix Technology Day 2018 - November 27 in Munich, Germany

Informix Technology Day 2018

IBM is again organizing an Informix Technology Day - on Tuesday, 27.11.2018 in Munich!

There will be the opportunity to find out about new developments in Informix and best practices for the successful use of Informix. In addition, the Technology Day will also provide numerous opportunities to share experiences not only with other customers and partners, but also with IBM and HCL employees.

IMG 20170516 102710800 1200x800

Pradeep Muthalpuredathe / Director - WW Informix Engineering

Speakers include the following:

•  Pradeep Muthalpuredathe,
   Technology Director and Head of Engineering for Informix at HCL,
•  Shawn Moe, Architect for Informix Development at HCL,
•  Scott Pickett, responsible for Informix at IBM worldwide,
•  Martin Mählmann from the Hamburger Pensionsverwaltung,
•  as well as other speakers from the local HCL and IBM organization.

There will also be an Informix Ask the Experts session where all kinds of questions about Informix can be asked.

The event will take place at the IBM office in 81829 Munich, Hollerithstr. 1.
Registration starts at 9:00 a.m., lectures start at 9:30 a.m. The event is scheduled to close at 5:00 p.m

Participation in the event is free of charge.

Agenda - Update 19.11.2018

09:00 - 09:30 Registration  
09:30 - 09:35 Welcoming Andreas Weininger (IBM) / Elisabeth Bach (HCL)
09:35 - 10:20 Informix roadmap - Where do we go from here? (engl.) Pradeep Muthalpuredathe (HCL)
10:20 - 11:05 Some customer Informix configuration and application issues and solutions Scott Pickett (IBM)
11:05 - 11:50 Advanced Analytics with Python and Informix Andreas Weininger (IBM)
11:50 - 12:05 Update Informix Support Andreas Sperl / Piet Gaarthuis (HCL)
12:05 - 13:00 Lunch break / Networking  
13:00 - 13:45 How to use Informix as SQL/NoSQL database Martin Mählmann (Hamburger Pensionsverwaltung)
13:45 - 14:15 What should I watch for when upgrading or migrating to Informix? Holger Kirstein (HCL)
14:15 - 14:45 Push Data and Smart Trigger Andreas Legner (HCL)
14:45 - 15:15 Informix TimeSeries: Special Features and Points of Interest Martin Fürderer (HCL)
15:15 - 15:35 Coffee break  
15:35 - 16:20 What's New in Informix? (engl.) Shawn Moe (HCL)
16:20 - 17:00 Informix Ask the Experts all speakers

Registration for the event can be made by e-mail to This email address is being protected from spambots. You need JavaScript enabled to view it..

Please include the names and e-mail addresses of all participants to be registered in this e-mail.

Dr. Andreas Weininger
Leading Technical Sales Professional
IBM Deutschland GmbH

Read more


more articles blue 780x100
invispix 10x10

Informix for purchasers

Product linesProduct lines

Product lines

CalculationCalculation

Calculation

Price filesPrice files

Price files

License textsLicense texts

License texts

AnnouncedAnnounced

Announced

Placing ordersPlacing orders

Placing orders

invispix 10x10
OEM/ESA licensingOEM/ESA licensing

IBM OEM licensing

IBM Db2 for purchasersIBM Db2 for purchasers

IBM Db2 for purchasers

Informix for purchaserInformix for purchaser

Informix for purchasers

Cognos for purchasersCognos for purchasers

Cognos for purchasers

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.
More information Ok