現(xiàn)在Informix版本更新很快，Informix 12.10版出來了!

D2002

http://pic.dhe.ibm.com/infocente ... .doc%2Fproducts.htm

有沒有小白試過此版。



Informix12-01.pdf (106.29 KB, 下載次數(shù): 16)

2013-04-02 21:12 上傳

點擊文件名下載附件
IDS 12.10 介紹資料01

Informix12-02.pdf (1 MB, 下載次數(shù): 47)

2013-04-02 21:12 上傳

點擊文件名下載附件
IDS 12.10 介紹資料02

D2002

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++

D2002

12.10版把ON-Monitor刪除了，有點意外。覺得onmonitor還是不錯的