IBM Informix Ultimate Warehouse Edition
brings new levels of performance to analytics
(IBM Software Announcement ENUS211-148, dated dated March 29, 2011)
Overview:
IBM Informix Ultimate Warehouse Edition is a high-performance offering for IBM Informix, delivering dramatically faster analytic query responses transparently to users when compared to an existing Informix environment without the capabilities available with the Informix Ultimate Warehouse Edition. It integrates into an IBM Informix data warehouse environment, providing high-performance query software that is based on advanced in-memory technology.
The IBM Informix Ultimate Warehouse Edition consists of the following components:
• IBM Informix Ultimate Edition
• IBM Informix Warehouse Accelerator
• IBM Informix Storage Optimization Feature
IBM Informix Ultimate Warehouse Edition addresses the following client challenges:
• Long-running queries with unpredictable response time that do not allow for adhoc processing
• Need for DBA to tune the system, with increasingly inadequate results, due to the ad hoc, unpredictable nature of the data warehouse / analytical requests
• Leveraging the same database server environment for mixed workloads
Informix Ultimate Warehouse Edition provides:
• Faster query response times on unpredictable and long-running query workloads
• Help in lowering operating costs by reducing database tuning efforts
• Improved performance on analytical queries compared to your existing Informix environment
• The ability to run mixed workloads





Informix Enterprise Replication is a powerful way to replicate data assets across distributed installations and keep them consistent.
Customized use of the Admin-Scout thanks to the new role concept
With the ONCONFIG Explorer, Admin-Scout 3.2 offers a completely new module for managing ONCONFIG variables.
The entire storage administration clearly arranged in one module!
Admin Scout 3.2 offers a long-awaited feature: easy comparison of the databases' structures in different instances.
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.
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.
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.
Important features for cluster configuration and better analysis of instances in a group
The Admins-Scout Dashboard is an extremely powerful and informative tool that gives you an overview of the state of your Informix servers
An Admin-Scout feature for fast analysis of DBSpaces
IBM Informix 11.7
IBM Informix V11.50 editions
IBM Informix Dynamic Server Workgroup Edition V11.50
IBM Informix Warehouse V11.50 


