|
CURSOR Expert SolutionsWe have reorganized our service and support offerings for our database business and consolidated them into CURSOR Expert Solutions GmbH (XPS).We are continuing our existing offerings seamlessly through XPS while also intensifying the further development of CURSOR Admin-Scout.Our entire service portfolio will be provided through XPS in the future. As a subsidiary, we remain part of the CURSOR Software AG group in Giessen.Our contact details remain unchanged – just get in touch with us. |
||||
|
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.
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.
We have combined our service and support capabilities for high-performance databases with the system-oriented tool development of Nonne & Schneider.
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.
Informix Enterprise Replication is a powerful way to replicate data assets across distributed installations and keep them consistent.
With version 3.3, Admin-Scout helps Informix administrators to set up, configure and monitor Informix Enterprise Replications.
Customized use of the Admin-Scout thanks to the new role conceptWhereas 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.
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.
IIUG World 2021 will take place October 5-7 starting each day at 10:00 am Eastern US Time!The keynote speakers just confirmed:
Registration for this event will be $199. Register by September 1st to take advantage of the early bird price of $150.
Version 3.1 continues the journey to new functions for developers and administrators.
Admin-Scout 3.0 offers a completely revised design and up to 60% faster evaluations.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.
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.
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
Planning for Q2 and the second half of 2020
Innovations for 2021 (under investigation)
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.
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?
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
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.
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 MunichThis 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.
Important features for cluster configuration and better analysis of instances in a groupOverview:
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.
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.
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
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.
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.
The Admins-Scout Dashboard is an extremely powerful and informative tool that gives you an overview of the state of your Informix serversThis article describes the Admin-Scout Dashboard and its individual sections.
An Admin-Scout feature for fast analysis of DBSpaces
Pradeep Muthalpuredathe / Director - WW Informix Engineering |
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.
Dear Informix Partners,
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.
Dan Hernandez
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.
IBM Informix on Cloud gives you the ability to speed innovation and save costs by choosing a cloud deployment for your workloads
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.
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.
Software withdrawal and support discontinuanceIBM Informix Genero |
IBM
|
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
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.
IIUG Konferenz 2015CURSOR 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
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
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.
Date: Feb 26, 2015
Time: 10:30 AM - 12:00 PM (Central Time) / (17:30 - 19:00)
Hosted by: Pradeep Muthalpuredathe (IBM)
Presented by: Lalitha Krishnamoorthy (IBM Informix),
Erika Von Bargen (IBM Informix)
Informix Chat with the Lab - register now!
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:
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.
InformationWeek Webinar sponsored by IBM - more informations ...
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:
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.
Informix go’s NoSQLWith 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
Document include Informix Editions summary table!
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.
Extreme warehouse speed for fast business decisions (2012-03)
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:
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.
IBM Informix powers OLTP and analytics for data driven businesses (2013-03)
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.
Download the document for more details!
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.
Major enhancements in Informix 11.7 ( ... )
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.
The Technical White Paper / October 2010
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.
Informix TimeSeries - Proving concept for smart metering data (2011-03)
Wie aus Informix Dynamic Server Enterprise und Workgroup Editionen
Informix Ultimate, Growth, Choice und Innovator-C wurden.
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) ...
Informix TimeSeries - Hildebrand solves a key problem (2010-03)
