100
The 12.10 documentation is in a new information center: http://pic.dhe.ibm.com/infocenter/informix/v121/index.jsp
Check out the amazing list of new features for IBM Informix version 12.10.xC1!
Here's a summary, but be sure to look at all new feature descriptions:
Installation and migration
- Client SDK
- OpenAdmin Tool (OAT) for Informix is installed by default with the Client SDK
- Migration
- Upgrading to Version 12.10
- Manage data storage
- Autonomic storage management for rolling window tables
- Manage rolling window tables in OAT
- Enhanced CREATE TABLE and ALTER FRAGMENT interval fragment syntax
- Enhancements for warehousing and business intelligence queries
- OLAP windowed aggregate functions
- Enhanced control over how the ORDER BY query results sort null values
- SQL DISTINCT expressions as arguments to COUNT, SUM, AVG, and STDDEV aggregates
- Multiple DISTINCT aggregate functions in a query
- Faster queries
- Faster ANSI join queries
- Temporary table projection optimization for views and derived tables
- Result tables
- Enhanced SQL statements to store query results in permanent tables
- SPL enhancements
- The IBM Informix SPL language now includes the CASE statement
- SPL routines for application compatibility
- Enhanced support for OUT and INOUT parameters in SPL routines
- Simpler and more compatible SQL syntax
- CASE expressions in the ORDER BY clause of SELECT statements
- INTERSECT and MINUS set operators for combined query results
- Simplified CREATE EXTERNAL TABLE syntax for loading and unloading data
- Compression options
- Improve space utilization by compressing, repacking, and shrinking B-tree indexes
- Save disk space by compressing simple large objects in dbspaces
- Manage compression in IBM OpenAdmin Tool (OAT) for Informix
- Save disk space by enabling automatic data compression
- Backup and restore
- Enhanced built-in storage management for backup and restore
- Configure automatic backups with the ON-Bar utility
- Ease of use and embeddability
- Dynamically configure the database server
- Easily configure an embedded server
- Managing server connections on Windows operating systems
- Set local environment variables for Informix instances (UNIX)
- Distributed query support for non-root installations of Informix
- Improved ALARMPROGRAM configuration parameter behavior
- OAT usability enhancements
- New Welcome pages in OAT
- Monitor Informix servers from your mobile device
- Log in to OAT with your user name
- Monitor multiple database servers at the same time
- View graphs of the buffer pools and extents for a database server
- Performance
- Increased scalability with optimized caching
- Extensibility improvements
- Store R-tree indexes in dbspaces with non-default page sizes
- Faster queries through the virtual table interface
- Grid enhancements
- Grid queries for consolidating data from multiple grid servers
- Easily propagate external files through a grid
- Manage grids in OAT
- Defer the propagation of DDL statements in a grid
- Enhancements to defining replicates for Enterprise Replication
- Replicate tables without primary keys or ERKEY columns
- Simplified setup of a data consolidation system
- Replicates are mastered by default
- Replicate more types of data with Enterprise Replication
- Replicate time-series data
- Replicate light-append operations
- Faster and more reliable high-availability clusters
- Improved network failover support
- Improved transactional consistency for HDR synchronization
- Faster replication
- Reduce replication latency between Enterprise Replication and shared-disk secondary servers
- Apply transactions for a replicate serially
- Other improvements to Enterprise Replication
- Monitor the status of Enterprise Replication queues
- Enterprise Replication supported among non-root servers
- Automatic space management for Enterprise Replication
- Refresh data in data warehouses
- Continuously refresh the data in data marts
- More accelerated queries
- Enhanced query acceleration
- Administer the accelerator
- Administer Informix Warehouse Accelerator with IBM OpenAdmin Tool (OAT) for Informix
- New SQL routines for administering the Informix Warehouse Accelerator
- Improved security
- Required privileges for administering Informix Warehouse Accelerator
- Manage time series data
- Manage time-series data in rolling window containers
- Return the timestamp of the first or last time-series element
- Speed up data loading
- Faster writing to time-series containers
- Load time-series data faster by reducing logging
- Customize data loading
- Write a custom program to load time-series data
- Enhancements to the Informix TimeSeries Plug-in for Data Studio
