• Workgroup: 32 GB -> 128 GB
• Express: 8 GB -> 16 GB
• Innovator-C: Allow HDR Secondary
• Distributed SQL/NoSQL for all Editions
• Partitioning for all Editions
Feature Request
Vote now for an upgrade of the editions!
Informix Monitoring
relaxed - thanks to the CURSOR Informix Team
Admin-Scout
the best tool for Informix administrators
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).
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.
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).
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
Written on
The Informix Newsletter 2026/Q1:
Highlights of the Issue:
TechTipp: Ergänzung "InPlaceAlter" Task
TechTipp: Task "auto_crsd"
TechTipp: ONCONFIG - NET_IO_TIMEOUT_ALARM
TechTipp: UTL_File Package (Datablade)
...
Read the whole article and view the Informix Newsletter online here!
The limitations of the smaller Informix editions have long been outdated and an obstacle to the future-oriented use of Informix. As part of Informix Technology Days 2024, a call was made to product management to review and upgrade the limits. There has been no response from IBM to date.
IBM TechXchange: Informix Technology Days 2025 on March 12th/13th, 2025, at IBM Watson Center in Munich.
Informix Technology Days 2025: like last year, at the same place but one day earlier and one major release further! Two days of lectures and hands-on labs with discussions about IBM Informix.
We were saddened to have heard of Carlton Doe's death.
Carlton came to IT in the 1980s. He began working with the Informix database as a 4GL developer, administrator and consultant. His high technical understanding, communication skills, and passion for advancing projects, made him a globally recognized expert on Informix over the course of his professional life.
IBM TechXchange: Informix Technology Days 2024 - on March 13th/14th, 2024 at the IBM Watson IoT Center in Munich.
After a pause caused by the Corona pandemic, we are pleased that IBM is offering the Informix Technology Days at the Watson Center in Munich again this year. The planned event is, as in previous years, aimed at decision-makers, developers, and system technicians who work with the database system in their professional daily life. IBM expressly invites all Informix users - including those who may have a potential interest in the technology - to join us.
Admin-Scout 3.2 Create individual users / Test roles with the SQL-Editor
Customized use of the Admin-Scout thanks to the new role concept
Whereas Admin-Scout previously only knew the default users "cursoradmin" and "openadmin", the new version 3.2 allows the creation of individual users. In combination with a dedicated assignment of rights on menu level, different roles can now be built up specifically.
Checking role and rights concepts with the SQL-Editor
Administrators have to deal with roles and access rights of database users. To make it possible to check the rights of a user, the new version allows to test accesses of the SQL-Editor under a different user name
With the ONCONFIG Explorer, Admin-Scout 3.2 offers a completely new module for managing ONCONFIG variables.
The goal of our development was to clearly summarize the ONCONFIG variables in one place and to present all information related to selected variables.
The ONCONFIG Explorer displays all ONCONFIG variables alphabetically sorted in a tree structure. A search field can be used to narrow down the number of hits.
For all documented variables a help button supports the quick display of the reference entry from the manual.
The entire storage administration clearly arranged in one module!
Admin-Scout 3.2 offers a complete overhaul and restructuring of storage management. The new module combines storage administration and reporting in one menu item. Administrators are now able to see all storage objects immediately through a hierarchically sorted object tree. A simple click provides all relevant details, sensibly organized via individual tabs.
Admin Scout 3.2 offers a long-awaited feature: easy comparison of the databases' structures in different instances.
The new module compares the typical database objects such as tables, views, external tables, sequences functions and access rights, including the respective associated indexes, constraints and triggers.
This premium feature increases productivity while matching and adapting database structures and objects.
Admin-Scout 3.0 offers a completely revised design and up to 60% faster evaluations.
Revised user interface
The entire user interface of the Admin-Scout is designed more uniformly and with better performance. The access to configuration and server administration is clearly structured. Optimized table structures and scaling of the display, lead to a considerably faster page layout.
New SQL Toolbox
The version 3.0 impresses above all with the new SQL Toolbox with many powerful functions in the Database Explorer and SQL Editor. As a result the Admin-Scout offers more interesting functionalities for development and tuning of Informix databases.
IBM Informix vulnerability CVE-2020-4799 in Spatial Datablade Module
A security warning was issued on October 8, 2020 (CVE-2020-4799) for IBM Informix Dynamic Server.
This vulnerability affects the Spatial Datablade Module in Informix Server versions 12.10 and 14.10.
A specific function in the Spatial Datablade can be called with an out-of-range parameter. A local user logged on with SQL privileges could use this vulnerability to attempt to execute an SQL injection. If the attack is successful, the attacker would be able to grant himself extended user rights and execute his own code
Help provides a Fix Pack that IBM has released on Fix Central.
Processor-based licensing with full- and sub-capacity in virtual environments
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?
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.
Informix Release 14.10.xC2 of September 2019 For the Informix Developer- 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.
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.
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.
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.
The new Admin-Scout 2.3 Scheduler module offers a centralized administration of all tasks and sensors
Admin-Scout 2.3 - Overview new features in version 2.3
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.
https port is now active - generating of a self-signed certificate.
Setting up an encrypted SSL connection on the database port.
Easier selection of instances - access to instances of different groups.
Autologon-Feature – automatic connection to a standard instance.
New Scheduler module - all Scheduler modules are now available in one place.
New module Cluster Configuration.
New module DBSpace Layout History.
Backup/Restore now with SQL Editor Files.
Additional reporting on the InformixHQ Monitoring Database.
Setting up a secure SSL connection for Informix servers and clients
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.
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.
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.
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!
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.
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.
For years, Adobe Flash was the first choice to visualize animations and sophisticated graphics in a browser. Due to recurring security issues, the use of Adobe Flash Player has long been discouraged. The IBM Informix OpenAdmin Tool also uses the Adobe Flash Player in some areas for the graphical representation of complex contexts.
Security warnings and the end of support for the Adobe Flash Player, already announced for 2020, prompted us early on to switch the graphical interface of the Admin-Scouts to the Dojo Toolkit and HTML5. We have step by step converted all relevant modules. This involved the redesign of all charts and the elaborate redesign of important modules such as the SQL-Trace or the Storage-Module.
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.
CURSOR Informix Support employees have more than twenty years of experience in supporting and administering Informix databases. We have been developing the Admin-Scout since mid-2015 and the first customer installations took place in 2016.
With the release 2.2, from March 2019, the Admin-Scout will only be provided on the basis of the Dojo Framework with HTML5 and without Adobe-Flash.
In the Admin-Scout developer blog we present some new features as articles. A good overview of the enhancements can be found in the article Development and Release Steps, in which we also give a preview of the features of the next version
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.
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.
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
Admin-Scout 1.4.4 - the new dashboard, an overview
The Admins-Scout Dashboard is an extremely powerful and informative tool that gives you an overview of the state of your Informix servers
The Admin-Scout Dashboard is the central overview for important parameters and states. All Informix servers in a group are listed and the status of a server is displayed with icons.
The details of an instance are very useful for troubleshooting or for identifying optimization potentials. For example, it is very easy to find tables where indexes are missing or the index structure is not ideal.
In contrast to the OAT, the Admin-Scout offers the possibility to switch between the tabs - without waiting times and without having to start the reporting from the beginning.
This article describes the Admin-Scout Dashboard and its individual sections.
Informix International Users Group Conference October 28 - November 1, 2018 - Washington, DC, USA
The largest gathering of Informix DBAs, Developers and Business Partners in the world. 3 Full Days of Educational Sessions to meet all of your Informix DBA and Developer needs.
Developers
The IIUG conference enables developers to find the newest and most powerful ways to utilize Informix.
DBAs
The best technical information to maximize your Informix potential.
Managers
Learn why Informix has the lowest TCO in the industry while having some of the most powerful tools available for your business.
Call for Presentations and Early Registration are now open!
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
below we share actual news about the IBM/HCL Informix partnership, provided today by Tomas Escobar (WW Sales and Strategy Leader, DB2 and Informix).
Your CURSOR Service Distribution Team
Tomas Escobar:
Short overview
Informix Development and support teams will move to HCL and HCL will further accelerate Informix development work.
Nothing changes for existing customers - and there is a guarantee for next 15 years of continued Informix availability, enhancements and support.
IBM did not sell the IP, not the product, not the source code - we did not sell the Informix business.
IBM remains the point of contact for sales, contracting, licensing, pricing, support towards customers. IBM product lifecycle policies remain unchanged for Informix.
IBM and HCL Strategic Partnership to jointly develop and market IBM Informix (April-17-2017)
Friends
I have some very exciting news to share with you today. I am very pleased to announce that IBM and HCL are entering a strategic partnership to jointly develop and market the IBM Informix family of products.
We are building on a history of collaboration between the two companies. The new partnership combines IBM’s large Informix customer base and global sales force with HCL’s leadership in the IT services sector – accelerating the investments, evolution and adoption of Informix as a leading database – and further address the needs of an embedded database.
Effective May 1, 2017, HCL will take over development and support of the Informix product family. Product strategy, marketing and sales efforts continue to be led by IBM with HCL participating and expanding routes to market. Experience for customers remains unchanged. Existing customer agreements, first point of contact, new licenses or extensions to existing entitlements continue to be through IBM.
Let me close by expressing again my personal excitement about this new partnership as it will lead to new innovations, more delighted clients and more opportunities for our employees and partners.
Dan Hernandez, VP Offering Management Analytics IBM
The conference starts on Tuesday with a keynote. Pradeep Muthalpuredathe, the manager of Informix, will provide development and support on the new situation and an outlook on the plans.
A session about new features will follow.
IBM Informix Support gives an outlook on a possible OAT successor and an overview of undocumented features of the IDS.
Two lectures will deal with SQEexplain and Performance Tuning, two with Enterprise Replication and CDC.
Finally, a question and answer session will be held again under the ambitious motto "All questions answered", in which the participants have the opportunity to ask questions to IBM experts.
The event takes place at the IBM office in Munich, Hollerithstr. 1. The event starts on Tuesday at 10 am, registration starts at 9:30 am, the event ends at 6 pm on this day.
Participation in the event is free.
The registration can be made directly by e-mail to This email address is being protected from spambots. You need JavaScript enabled to view it. (Note: alternatively you can also use the contact function on this website). Please provide the names and e-mail addresses of all participants.
We look forward to your registration and hope to see you in May!
Your IBM Informix team
Request for speakers and additional topics (10.03.2017)
Dear Informix friends
After the very positive response to the Informix technology days in recent years, a technology day will be held again this year. The event will be held in Munich on 16 May. Registrations will be possible from the end of March.
IBM is planning a mix of a key note with up-to-date information on product development, lectures by developers and support staff, and of course, customers will also participate with lectures.
We therefore ask you to propose topics and presentations for the Informix Technology Day. In this case, a title proposal is sufficient, possibly extended by a brief description of the content
Two types of proposals can be made
- Topics on lectures, which you would like to keep yourself - Topics on lectures you would like to hear.
Please send your topic or lecture request to This email address is being protected from spambots. You need JavaScript enabled to view it., and also provide your contact details.
We look forward to your feedback and hope to see you in May!
Thanks and kind regards
Dr. Elisabeth Bach (IBM)
Techn.Support DMS / IBM Informix Advanced Support IBM Software Group, Information Management
April 23 - 27, 2017 Marriott City Center, Raleigh, NC, USA
The largest gathering of Informix DBAs, Developers and Business Partners in the world. 3 Full Days of Educational Sessions to meet all of your Informix DBA and Developer needs.
Developers
The IIUG conference enables developers to find the newest and most powerful ways to utilize Informix.
DBAs
The best technical information to maximize your Informix potential.
Managers
Learn why Informix has the lowest TCO in the industry while having some of the most powerful tools available for your business.
IBM Announces Informix on Cloud speed innovation and save costs
(IBM Announcement ENUSZP16-0499 - 27.09.2016)
IBM Informix on Cloud gives you the ability to speed innovation and save costs by choosing a cloud deployment for your workloads
At a glance
IBM Informix on Cloud delivers all of the capabilities of the Informix Advanced Enterprise server deployed in on-premises configurations but without the time and expense of a hardware purchase, system administration, and management. The cloud-delivered Informix server will be configured for OLTP workloads and also includes entitlement to Informix Warehouse Accelerator (IWA) that delivers incredible query acceleration through columnar, compressed, in-memory technology.
Provides database as a service on the IBM SoftLayer global cloud infrastructure
Comes with an OLTP preconfigured instance
Includes IBM Informix Warehouse Accelerator entitlement
Supports cloud deployments of applications that will need JSON/BSON and SQL apps simultaneously in the same database, in the same queries
Allows for faster deployment of innovative cloud applications due to REST interface and MQTT
Key features and benefits of Informix on Cloud are:
Accelerates and simplifies deployment: Reduces costs and time required to take advantage of the high-performance Informix engine that integrates TimeSeries, Spatial, NoSQL, and SQL data.
Seamless integration of application data: Delivers high-performance operational and analytic processing across the boundaries of cloud environments and on-premises configurations.
Native encryption with all configurations. Secure your data at rest and in flight.
DBMS servers sized to meet your business demands: S, M, L, and XL configurations.
White Paper by Bloor Author Philip Howard Publish date July 2016
Informix, one of the databases offered by IBM, has a long and illustrious history. In particular, it is well known as a platform for supporting applications developed by third parties and ISVs, primarily for use in transactional environments. This is because Informix is a robust offering that combines high performance and functionality with minimal administrative requirements.
However, this paper does not discuss these features of the product in any detail. Instead, we are here concerned with the use of IBM Informix within Internet of Things (IoT) environments. Indeed, we can start by saying that IBM Informix is IBM’s database of choice for IoT deployments, which should be reassuring to any existing users that might have been concerned about continuing investment into this database product.
Using IBM Informix on the Cloud - Webcast (26.09.2016)
Summary
Does your business depend on core database solutions for mission critical operations? Are you considering or are you already doing business with systems in the cloud? Join this webcast and learn about IBM's latest offerings for using Informix in the cloud.
Nicholas develops software in and related to the IBM Informix database. He has contributed to Informix's high-availability and replication functionality and more recently helped bring Informix to the cloud.
Informix Technologietage 14. - 15. Juni 2016 - IBM München
ALL QUESTIONS ANSWERED
Resümee: All questions answered!
Dieser Punkt der Agenda war programmatisch für die gesamte Veranstaltung. So nutzten viele Teilnehmer intensiv die Möglichkeiten für Detailfragen zu technischen Problemstellungen. Eine freudige Überraschung waren die vielen Fragen zu Informix und NoSQL. Dies ist ein deutliches Zeichen dafür, dass die Öffnung für neue Standards in der Entwicklung und beim Anwender angekommen sind und Informix sich in aktuellen Projekten durchsetzt. (Umfangreicher Bericht im Rahmen des Newsletter folgt).
This email address is being protected from spambots. You need JavaScript enabled to view it.
This email address is being protected from spambots. You need JavaScript enabled to view it.
Informix Technologietage 2016 14. - 15. Juni - IBM München
Mit speziellen Beiträgen der CURSOR Software AG
Informix Technologietage haben eine besondere Note. Langjährige Besucher schätzen die Gelegenheit für den direkten Austausch mit IBM Strategen, Kollegen aus dem Informix Support und natürlich mit vielen anderen Anwendern.
Die IBM lädt Sie für den 14. und 15. Juni zu den IBM Informix Technologietagen 2016 nach München ein.
Beginnend mit einer Keynote von Al Martin (IBM Vice President - Informix Development and Support) und einem Grußwort der Präsidenten der IIUG von Stuart Litel, bietet die Veranstaltung Informationen zu vier verschiedenen Themenblöcken:
Informix Produktstrategie - aktuelle und kommende Versionen. Hierzu auch ein informativer Rückblick auf die IIUG Konferenz vom Mai, mehrere Teilnehmer werden anwesend sein und von ihren Eindrücken berichten.
Informix Best-Practice - Anwender berichten detailliert über den kreativen Einsatz von neuen Features und den aktuellen Möglichkeiten die Informix bietet. Welche Lösungen gibt es für wiederkehrende Anforderungen.
Informix Support - wie können Kunden die Angebote des Informix Supports am einfachsten nutzen. IBM Supportmitarbeiter bieten Informationen aus erster Hand.
Informix und das Internet der Dinge - das intelligente Haus und weitere praktische Anwendungsbeispiele.
CURSOR ist Sponsor der Veranstaltung und wir sind mit einem eigenen Beitrag speziell für Administratoren dabei:
Erstmals in einem größeren Rahmen werden wir den Admin-Scout für Informix vorstellen, die Best-Practice Toolbox für Informix Administratoren!
Erfahren Sie wie die Administration durch aussagekräftige Dashboards und automatisiertes Reporting vereinfacht wird, wie Sie durch vorausschauendes Monitoring und Alarmierung Engpässe und Ausfälle vermeiden und wie Sie durch die Kombination von System- und Datenbankmonitoring mehr Sicherheit gewinnen.
It's still not too late to register for IIUG 2016 in Ponte Vedra Beach, Florida, USA from May 4 - 8. There are still hotel rooms available at the LOW conference rate of $189 at the Sawgrass Marriott Golf Resort and Spa. You still have time to register to take advantage of the free tutorials on Sunday May 8, which are available to ALL PAID ATTENDEES, as long as you REGISTER.
Effective on dates shown, IBM(R) will withdraw from marketing and withdraw from support the following programs licensed under the IBM International Program License Agreement: IBM Informix Genero - Program number 5725-D13
Withdrawal from marketing September 1,2015
Withdrawal from support September 30, 2016
IBM Informix Genero, an application development environment that helps customers create innovative database applications and modernize existing 4GL code, is a product IBM offers through an OEM relationship with its partner Four Js. To better serve clients and deliver the latest Genero enhancements to them in the most timely manner, IBM is entering a new delivery phase of this product. Effective September 1, 2015, IBM will transfer the sale of Genero licenses to Four Js. Support for current customers will continue to be available from IBM until September 30, 2016. IBM considers Genero to be the best path forward for customers wishing to modernize Informix 4GL applications.
The annual IIUG Conference is the largest gathering of Informix DBAs, Developers and Business Partners in the world. After the conference IIUG provided more then fifty presentations. Below you can find an overview sorted by subjects.
CURSOR Kollege Erik Stahlhut war einer der Teilnehmer der diesjährigen IIUG Konferenz in San Diego. Die CURSOR Software AG ist nun zum dritten Mal dabei, wenn es darum geht die neuesten „Insights“ rund um Informix zu erfahren und zu beeinflussen.
Auf seinem Blog (ESTJump - Informix) berichtet Erik Stahlhut ausführlich über die Veranstaltung, eine Kurzfassung geben wir hier wieder.
Learn about the latest Informix features, including the tried and true "must have" sessions like maximizing your system performance while minimizing system downtime, NoSQL, Cloud as well as opportunities to road test the latest Informix 12.10 and big data capabilities in one of the many Hands-On Labs with actual IBM development and support engineers. Join us for the best the Informix community has to offer.
You have until midnight (EST) Wednesday January 16, 2015 to register for the 2015 IIUG Conference and save OVER $300 USD. Save $250 with early bird registration and an additional $100 with an IIUG Membership discount. If you are not currently an IIUG member and want to take advantage of the full early bird price, please go to http://www.iiug.org/join. It is quick and easy and there is no fee. Becoming an IIUG member will increase your Conference savings, and allows access to the Members Only section of the IIUG Website, where downloads of some of the latest IBM Informix products are available, as well as IIUG-only utilities written by DBAs for DBAs.
Once again this year's conference registration includes a full day of tutorials, on Thursday April 30th, and these tutorials are included at NO CHARGE for all paid attendees. So don't miss out on this wonderful opportunity to expand your training dollars.
Need some help with the boss on why you should attend the SEVENTH annual IIUG conference — the largest gathering of Informix users in the world? We have created a special Justification document to help you with this. All attendees will have an opportunity to road test the latest 12.10 and big data capabilities and features in one of our many Hands On Labs with actual IBM development and support engineers.
The speaker submissions for the 2015 Conference have been overwhelming. The submissions cover a multitude of topics pertinent to Informix users and administrators, including the many popular Informix features, as well as tried and true "must have" topics like those involving maximizing your system performance while minimizing system downtime. Our speakers for this year's conference are the best our Informix community has to offer, and the list includes many new speakers. The IIUG Conference committee has completed the review of all submitted presentations to select the very best sessions, hands-on-labs and tutorials for the conference. The sessions we've chosen include interesting and relevant topics that can be used to reinforce your professional skills and keep current in today's changing market. Remember, the 2015 IIUG Conference is not "Just For DBAs": Bring your application developers too!
Selected speakers will be notified on or about January 10, and once the speakers have confirmed their selection we will post the sessions to the conference website. Please continue to review the website for regular updates. It will be updated to include details of sessions, hands-on-labs and tutorials as these details become available. The 2015 IIUG Conference in San Diego will be our best conference yet.
See you at the Conference! Apr 26 – 30, 2015 The IIUG 2015 Conference team This email address is being protected from spambots. You need JavaScript enabled to view it.
Register for IIUG2015 by March 2, 2015 to save $200 at www.iiug2015.org
Since many of you in North America are either still shoveling snow, or possibly getting ready for the next blizzard of the century, what you should REALLY be thinking about is SAN DIEGO IN APRIL for IIUG 2015!
There is less than 1 week left before the Late Registration price increase for IIUG2015 takes effect. You have until midnight (EST) Monday, March 2, 2015 to register for IIUG2015 in San Diego.
Register now to receive the Standard Registration rate and apply your $100 IIUG Membership Discount for a total cost of $1050 USD.
Not an IIUG member? Join for FREE today at www.iiug.org/iiug/join.html and gain access to downloads of the latest IBM Informix products, Informix DBA Utilities and Online Forums.
Your IIUG2015 registration includes the Thursday Tutorials at NO ADDITIONAL CHARGE for all paid attendees. Do not miss out on this wonderful opportunity to enhance your Informix knowledge.
The IIUG2015 Technical Sessions will run Monday morning to Wednesday afternoon and will cover a wide range of invaluable topics for Informix users and administrators. The sessions will cover popular Informix features, engine and application performance tuning, including Hands-On Labs, troubleshooting and much more.
The speakers at IIUG2015 are the best the Informix community has to offer. New speakers and familiar faces are eager to share their knowledge and expertise while presenting interesting and relevant topics that can be used to reinforce your professional skills.
Remember, this year IIUG2015 moves back to the Marriott Mission Valley in sunny San Diego, CA.
Guaranteed NO SNOW.
The IIUG 2015 Planning Committee
This email address is being protected from spambots. You need JavaScript enabled to view it.
REST Easy: Driverless, Unified Access to JSON, Relational and Spatio-temporal Data - (26.02.2015)
The IBM TimeSeries and Spatio-temporal offerings include the representational state transfer (REST) API, which supports rapid development of applications that access a database using any programming language or platform that supports HTTP. Developers need not rely on proprietary drivers in a subset of programming languages and platforms to deliver their application. The REST API also enables unified access to JSON collections, relational database tables and Informix high-performance time series database capabilities. A developer can prototype a design using a JSON collection and go into production using a relational table or time series to maximize performance without modifying the application.
Internet of Things Data: How to Use Embedded Database & Streaming Analytics for Value (12.08.2014)
Event Date: Aug 12, 2014 Event Time: 12:00 PM (Eastern Time) / 18:00 CET
Speaker:
Sara Willett Program Director Informix Internet of Things
Jacques Roy Executive IT Specialist, WW Technical Sales, Big Data InfoSphere Streams
The Internet of Things (IoT) is driven by consumer demand for new services and convenience, as well as by the availability of low cost sensors, smart phones, and universal internet access. New technologies can enable you to take advantage of this new natural resource through gateway processing, cloud infrastructure and distributed real-time analytics.
Attend this webinar to learn how to:
Understand the 3-tier IoT architecture including edge devices, gateways, and cloud
Derive the importance of a gateway database for local processing and storage of data from your edge devices
Act in real time with sophisticated analysis of your streaming data for time sensitive decisions.
Register for this webinar to learn more about the latest technology enabling the Internet of Things across devices, sensors, gateways and the cloud for connected environments. See how bringing an intelligent mix of technologies from an enterprise-class database to the “edge” and real-time analytics on consolidated data provides a competitive advantage in the Internet of Things.
A new technology-surge comes upon IT-distributors, companies and customers. Cost-efficient sensors enable a cheap recording of measuring data in all areas of the real world. Our whole technical environment becomes increasingly measurable and analyzable, both in companies and public areas, as well as in private households.
The harvested data are a real image of actual activities and have a high value for planning- and controlling-decision, as well as for information services. The massive appearance of sensors and autonomous devices, the local recording, storage and processing of data, together with the possibilities of a breadthways available Internet are the base of a new technologic revolution which is summed up under the term:
Setting up the NoSQL functionality on an existing instance
With the Version 12.10.xC2 IBM created the opportunity to access the Informix database with MongoDB-clients and to use the Informix NoSQL functionality.
Unfortunately getting this fantastic feature requires to build up a new instance. All descritptions of the IBM proclaim, that the installer of the xC2 version has to create a new instance. Then the functionality, based on the copiyng and adjusting of 2 files, can be transferred to further new instances which are created manually.
With the in September 2013 released version 12.10.xC2 Informix has now JSON compatible NoSQL functionality available. With that the IBM pushed the door to BigData once more wider open for Informix.
Now a third important building block is added to Warehouse Accelerator and TimeSeries functionality: The from relational scheme deviating storage and converting of data in the for webapplications widely spread Java Script Object Notation (JSON).
Therefor the set of native datatypes for Informix was expanded by JSON, respectively by the binary equivalent BSON. During the expansion of the scope of functions the compatibility to the widest spread NoSQL database - MongoDB - was respected, so that MongoDB applications can also be run mostly directly with Informix.
The first noteworthy introduction of NosQL for Informix occured in the end of September in the "Chat with the lab webcast" by Jerry Keesee and John Miller. The topic is still barely present in the web. The Informix NoSQL presentation of the IBM offers a good entrance and explains the basic terms and relations.
IBM Informix is one of the world’s most widely used database servers, deployed by some of the world’s largest corporations as well as new start-ups. Informix incorporates design concepts that are significantly different from traditional relational platforms, resulting in extremely high levels of performance and availability, distinctive capabilities in data replication and scalability, and minimal administrative overhead. For application developers, Informix offers a variety of options and tools to accelerate a new generation of mobile and cloudbased applications. Developers can choose their favorite language or integrated development environment (IDE) with support for PHP, Ruby and Microsoft .NET. Informix also includes compatibility features that make it easy to port applications to the database. It is available in a variety of editions and supports a wide range of operating systems to power OLTP and OLAP workloads.
Informix 12.1 delivers unprecedented advantages: superior performance, availability and efficiency, minimal complexity and lower computing costs.
Highlights
Fast, always-on transactions: IBM® Informix® is proven database management software that provides fast, alwayson access to data in a platform-independent environment
Real-time analytics: Informix is a single platform that can power online transaction processing (OLTP) and online analytical processing (OLAP) workloads and help your organization successfully meet service-level agreements for each
Easy to use: Informix runs virtually unattended with selfconfiguring, self-managing and self-healing capabilities
Best-of-breed embeddability: Provides an embedded data management platform for independent software vendors (ISVs) and original equipment manufacturers (OEMs) to deliver integrated, world-class solutions, enabling use on multiple platforms
Informix Warehouse Accelerator - Take data warehouse performance to extremes
Informix and Informix Warehouse Accelerator give your organization highperformance analytic capability. Ultimately, that means better extraction of business insight from your information assets and greater business agility by consistently providing the right answers to the right questions at the right time. With this level of extreme warehouse speed, you can make faster, better business decisions.
Introduction Make informed decisions at the speed of business
How fast can you go? Understand your company’s need for speed
Optimize warehouse performance Make the most of compressed, in-memory data marts
Save by simplifying Cut costs by using existing resources to full advantage
Resources Take data warehouse performance to extremes
A single database platform delivers maximal performance for multiple workloads
Informix is simple yet powerful data management software that provides a single platform to achieve optimal performance for transactional and analytical applications. It enables organizations to lower costs and consolidate environments for OLTP and OLAP workloads. Using the most current technologies, Informix keeps data always available for real-time transactions and speed-of-thought analytics—helping organizations gain greater business insights for competitive advantage.
Highlights:
Deliver fast, always-on access to data in a platform-independent environment
Perform speed-of-thought analytics for rapid business decisions
Leverage easy-to-use management features to help reduce complexity
Enable fast and flexible cloud deployments
IBM® Informix® is one of the world’s most widely used database servers, present in organizations ranging from the largest corporations to start-ups. Informix incorporates design concepts that are significantly different from traditional relational platforms, resulting in extremely high levels of performance and availability, distinctive capabilities in data replication and scalability, and minimal administrative overhead.
New Features for Data Warehouse, Sensor Data, Cloud Computing, Administration and Application Development
Powerful and simple have always been watchwords for the IBM Informix database server and version 12.10 continues in that vein with enhancements to five key feature areas.
As well as updated platform support, there are also other new server features to improve SQL compatibility and boost performance:
Data Warehousing
New features in the Informix Warehouse Accelerator create a real time, in memory data warehouse capability. An updated administration interface means that the accelerator is even easier to configure and manage on a daily basis by using the new automatic partition refresh and trickle feed features. Informix has never been faster, simpler to use or more consistent in its performance. The Informix server has also been enhanced to provide powerful OLAP features, often used by Business Intelligence tools such as IBM Cognos products, to simplify and speed up complex queries that have to work across very large sets of data.
Sensor Data
The ability to store and analyze high volumes of structured data is key to handling the current explosion of information from monitoring devices and Smart Meters. The unique capabilities of Informix spatial and TimeSeries data types make it a simple task to store and process this data avalanche. New enhancements built in to 12.10 make these data types even more powerful than before. There is now a transparent view of time series data through Informix Warehouse Accelerator marrying two Informix technologies into a very powerful data search and analysis engine. Management of time series data is now much simpler and faster with the capability to define active and dormant time ranges for the storage containers. There are also several enhancements to the Virtual Table Interface and a new Loader API to make access to time series data even faster than before. Spatial data support has been enhanced to include new features that come with the latest ESRI 10.1 library.
Cloud
New features in the Informix Flexible Grid environment make the configuration and management of sharded data within complex replication environments even simpler than before by introducing the powerful concept of regions and the easy configuration of spoke and hub systems. Monitoring of replication queues has been enhanced to take account of their asynchronous nature and there are performance enhancements to allow for the replication of lightappend operations. The Connection Manager and internal server support for failover can now prioritize different networks within an application and database environment to maintain the highest level of service. This can also include keeping a Shared Disk Secondary cluster running while there is a network outage.
Embeddability
Autonomic capabilities have been extended with the ability to automatically compress data and compression now supports more database objects, which lowers the storage space requirements. Dynamic configuration for more server parameters allows for automatic tuning and self healing, including the ability to manage parameters in groups using an export and import interface. Rolling window definitions for fragmented tables boost performance and can be controlled automatically for simple administration.
Easy Administration
As well as boasting a new dashboard, the IBM OpenAdmin Tool for Informix continues to be developed to monitor and control many of the new Informix 12.10 features mentioned above, such as replication grids and Informix Warehouse Accelerator data marts. There is now a mobile app for DBAs on the move, allowing them to monitor the health and performance of all their database server systems. The old Informix Storage Manager has been replaced with a new Primary Storage Manager to make the process of backing up the server simpler and faster.
Application Development Support
It is easier to build applications in general, and database neutral ones in particular, with the addition of several new SQL language elements. As well as the OLAP functions mentioned above there are new UNION operators, extensions for compatibility with other database servers (including Informix Parallel Server) and new aggregate capabilities. Improvements to Informix Genero speed up the development process with powerful new templates for the Business Application Modeling tool. The Eclipse based loader tool for time series data now makes it easier to create load jobs, and has a simple command option for use in minimal production environments. As always, there are a number of internal enhancements to the Informix server that improve cross platform support and provide notable performance increases. Examples of performance enhancements include the following: ANSI style outer join queries can now be better optimized by utilizing hash joins and support for compression of data in the server has been extended to include indexes and simple large objects, which reduces I/O time.
Deutsches Zentrum für Luft- und Raumfahrt e. V. (DLR) Informix & Geodetic DataBlade - Kundenreferenz
Germany’s Aerospace Center needed a reliable and highly scalable database server to provide efficient access to more than 2 PB of image data while fulfilling long-term data preservation policies. The center deployed IBM® Informix® database to serve as an inventory of image data and IBM Informix Geodetic DataBlade® for the representation of data in three dimensions. The solution has provided efficient access to 2 PB of image data with no data lost in 10 years and requires less than one full-time employee’s time to administer at each of two sites. (Link zur Website des DLR)
Westfleisch, a meat products cooperative in Germany, uses advanced tracking and analytics to follow each product it makes, from farm to slaughterhouse to grocery shelves, increasing accountability and creating peace of mind for consumers.
Food contamination is a serious matter. Tainted food that goes unchecked can be fatal for consumers and for companies. As governments tighten regulations on food production and processing, companies need to account for each bushel of vegetables or piece of meat that makes it to market. Westfleisch needed to track animal information throughout the production process. It sought a serious data warehouse with lightning-fast processing capability and analytics power that helps it know exactly where products are at any given time.
Discover hassle-free data management with IBM Informix
IBM® Informix® is the database software voted number one in customer satisfaction.
Clients choose Informix because it is reliable, low-cost and hassle-free. Solution providers choose Informix for its best-of-breed embeddability. And it’s available on Microsoft® Windows®, Linux®, UNIX® and Mac OS X platforms.
Overview
Informix 11.7 ushers in the next decade for Informix to continue delivering smarter solutions as the engine that powers online transaction processing (OLTP) and decision support applications for businesses of all sizes. Informix 11.7 offers unprecedented advantages through advanced levels of performance, availability and efficiency, with minimal complexity and lower computing costs. And with the introduction of IBM Informix Flexible Grid, it is easy to perform routine maintenance and upgrades throughout all your geographic locations from a single site.
IBM Informix Database Software - New Features in Informix 11.70
Executive Summary:
With the diverse set of Informix® customers across different industries and enterprise sizes, we wanted to ensure that 11.70 focuses on the core strengths of Informix while significantly enhancing specific areas of growth and demand. Informix 11.70 raises the bar as a viable, low-cost RDBMS alternative for most custom small to enterprise level business applications. It provides the industry's most comprehensive set of high availability options in a platform independent environment while providing increasing value for embeddability, security, application development and data warehousing capabilities.
As a provider of solutions for energy and utilities companies across Europe, AMT-SYBEX is constantly looking to develop new products and services that help its customers meet the challenges of an ever-changing industry. When the UK government announced that the introduction of smart metering technologies to all homes would be a top priority, AMT-SYBEX immediately recognised that the proposed rollout presented both a challenge and an opportunity that would soon be repeated in other global energy markets.
Hildebrand provides creative and technology consulting for service organisations. The company’s technology team specialises in combining innovative technology with real-world experience, turning complex problems into a source of competitive advantage. Hildebrand’s consultants became fascinated by the challenges posed by smart monitoring of home electricity usage, and began a project funded by the Seventh Framework Programme for EU Research (FP7) ...