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