现在Informix版本更新很快，Informix 12.10版出来了!
本帖最后由 D2002 于 2013-04-02 21:13 编辑http://pic.dhe.ibm.com/infocenter/informix/v121/index.jsp?topic=%2Fcom.ibm.po.doc%2Fproducts.htm
有没有小白试过此版。
本帖最后由 D2002 于 2013-04-02 20:50 编辑
What's new in IBM Informix version 12.10.xC1
Installation and migrationClient SDK
[*]OpenAdmin Tool (OAT) for Informix is installed by default with the Client SDK
Migration
[*]Upgrading to Version 12.10
Application developmentManage 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
AdministrationCompression 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
High availability and Enterprise ReplicationGrid 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
Informix Warehouse AcceleratorRefresh 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
Time seriesManage 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
Removed features and products
ON-Monitor
Informix Storage Manager
Optical subsystem
Geodetic DataBlade® module
Object Interface for C++
12.10版把ON-Monitor删除了，有点意外。觉得onmonitor还是不错的
页:
[1]