It's here !!!!
Here is the US announcement
Here is the Canada announcement
Here is the EMEA announcement
Here is the AP announcement
Here is the LA announcement
True to it's heritage, Informix continues to build on it's key
differentiating capabilities that Informix customers and partners, known
more widely as "Informix fans" have come to love. You can read more
about the different features across the editions at http://www.informix.com
So what's new with Informix v11.7? Let me provide a very brief intro here.
Informix Flexible Grid
: Informix now offers a very easy way to
do something truly powerful - deploy Informix engines in a grid
environment. With grid based replication enhancements, you can now:
- Replicate DDL across grid or enterprise replication nodes
- Replicate data across nodes without requiring a primary key
- Support connection manager on top of enterprise replication nodes
- Setup, administer and monitor grid nodes using the OpenAdmin Tool or using cdr commands
Connecting to the grid and propagating DDL can be acomplished using
built-in stored procedures identifiable by the "ifx_grid_" prefix.
Informix Grid also now makes it very easy to define two or more cluster
deployments (or CAF ) as nodes within a grid deployment. The Connection
Manager can be used to manage the manage workload distributions across
the grid nodes.
Best-of-Breed Embedability enhancements that gets more autonomics
Again, this continues to enhance one of the core strengths of Informix,
mainly the ability to embed Informix easily. Over the last few years,
especially starting Informix v11.10, a lot of focus went into
autonomics - self configuring, self-healing, self-optimizing and
self-protecting characteristics. So what did we do more?
Enhanced Warehouse Capabilities:
- With Informix v11.70, we bring automated storage allocation -
allowing existing chunks to be extended automatically and adding new
chunks automatically when space is running out. Additionally you have
various thresholds you can configure. You can also now define a
"storage pool" - a list of raw devices, cooked files or directories that
Informix can use to allocate space as needed. You can define one
storage pool per Informix instance. As always, OAT interface exist for
- Informix now provides a set of utilities - Deployment Assistant and Deployment Utility - that allows users to easily and quickly package and deploy snapshots of Informix instances and their data. These are nice graphical user interfaces and users can actually customize (select / de-select) the features of the instance that they want to package.
- Embedability Toolkit : In order to enable existing and new customers to quickly get upto speed on embedding Informix, v11.70 introduces a toolkit that includes the Deployment Assistant and Deployment Utility , a configuration file, additional deployment scripts and a tutorial.
- Standardized errors and alarm codes for exception handling: In deep embed environments, this allows applications to manage and respond to exceptions in a consistent way.
- Auto-registration of extensions (datablades) : Informix now automatically registers built-in extensions the first time they are used
- New automated Database Scheduler Tasks: Several new tasks have been added including idle user timeout, bad index alert, auto CPU VP configuration, automatically optimize storage (compress, repack, shrink, defrag) that meet qualifying criteria (thresholds)
As Informix customers have continued to rely on Informix for warehouse type deployments as well as interest from XPS and RedBrick customers in Informix as a roadmap, Informix v11.70 brings several warehouse enhancements :
- Star and Snowflake Query Optimization: Informix v11.70 brings improvements to query times for queries involving joining data together from fact and dimension tables (star and snowflake schemas) along with new optimizer directives. This utilizes several other nifty features that is available with Informix - namely multi-index scans and pushdown hash joins
- Fragment Level Statistics: Informix now generates statistics at the fragment level. Fragment level stats are aggregated to form table level statistics. Attach and detach operations on fragments will automatically update statistics as applicable
- List and Interval Fragmentation: With Informix v11.70 Informix users can now define a fragmentation scheme based on intervals or a list. Interval fragmentation can be achieved by specifying date or numeric intervals. List fragmentation takes a fragment key based on single or multiple columns or a column expression. List values need to be constant literals.
: Informix v11.70 brings out some exciting capabilities and interoperability for application developers, including:
- SPL Debugger: Yes, a debugger interface and a debugger client for SPL debugging. SPL debugger clients are available via IBM Optim Development Studio a version of which is part of the media!
- Remote Websphere MQ Server : Informix already had , in previous versions, implemented SQL callable routines to exchange data with MQ, however there was a requirement to have MQ installed on all servers where Informix was installed. This is no longer a requirement, Websphere MQ can now be installed on a separate server and service multiple Informix instances
- Integration/Interoperability with Open source applicaitons: Many of you maybe aware that there is an open source project page for Informix at the IIUG website. As of v11.70, Informix now has support for Hibernate, Drupal, Mediawiki and xWiki with several other integrations being pursued.
- Optim Development Studio: Optim Development Studio is now included as part of the media bundle for Informix along with AGS Server Studio
- IBM Mashup Center: IBM Mashup Center provides an exciting new way for deploying dynamic Web 2.0 applications integrating data from Informix with various other sources such as spreadsheets, external data feeds, etc
- Continued enhancements to 4GL SOA
- Several enhancements to SQL
: You really can't have a conversation today with the word "cloud" in it, can you? Well, we made our move towards the cloud infrastructure a while ago with Informix editions being available as AMI images on Amazon's S3 cloud infrastructure. With Informix v11.70, you can now actually back up and restore to and from an Amazon cloud. Ontape enhancements include the ability to specify a url location in the onconfig file. You need to first configure your Informix image on Amazon as well as security credentials. Once thtat is done you can use ontape to perform the backup. Ontape first backs up to a local directory and then fires off a java cloud client to finish the job of backing it up to the cloud location. Security
: Security remains a top business priority for Informix customers. With that in mind, Informix v11.70 offers:
- Trusted Context: Trusted Context provides the convenience of reusing connections with a different user id , with or without authentication. You can now create a trusted context object based on an existing connection and specify user ids that can use that connection. Once a trusted context has been established , connection can be switched between users
- Selective Row level auditing: With Informix v11.70 you can now audit tables on all row operations : select, update, delete and insert. New DDL syntax with Create and Alter table and ADD/DROP AUDIT provides the capabilities to manage audit requirements.
- Support for non-OS users: Informix users no longer need to have a login on the OS
- Raw Disk support for Encryption Expert
: Informix has what I believe a unique heritage in performance, where with every release we strive to exceed performance levels compared to earlier releases. We have several performance related enhancements but I want to point out two primarily:
- Forest of Trees Index: In a nutshell, this is essentially a large B-tree index subdivided into smaller "buckets". You define which columns are to be used to hash to a "bucket" and you define how many buckets you want to divide into when you create the b-tree index. The net performance benefit is that on small to mid-size tables, you can significantly reduce contention on root nodes and on large tables, you can greatly reduce the depth of the b-tree through reduced buffer reads.
- C UDR pre-loading: Preloading a C-UDR shared library allows Informix threads to migrate from one cpuvp to another during the execution of the C-UDR. Without this feature, the thread executing the UDR is bound to the cpuvp for the duration of the C-UDR execution. Allowing thread migration during C-UDR execution can increase performance
I am going to end this blog here, but certainly that's not all there is to say about Informix v11.70. Keep your eyes and ears open as over the next few days , you will see a wealth of material rolling in on Informix v11.70 and it's features.