Informix 14.10新增功能介绍

注：文档更新于2022年04月29日
Informix 14.10新增功能介绍

Informix v14.10.xC1 新增功能
1 性能 Performance
1) J-foundation upgrade
J-foundation升级至4.50.JC1
2) Log Replay
日志复制：日志复制性能增强，增加onstat -g laq监控日志复制
3) New Enterprise Replication command to automate setting up replication between Informix servers
新增ER复制命令cdr migrate server
4) Common Table Expression
WITH语句支持CTE
2 管理 Administration
1) InformixHQ
新的基于网页的工具（替代OAT）
2) REGEX: rtrim flag and overloaded functions
rtrim增强
3) Backup to S3 cloud servers using V4 authentication
onpsm支持使用V4验证方式备份至S3云服务器
4) Atomic replacement of stored procedure
存储过程（仅限）支持CREATE OR REPLACE语法
5) Replication to SPL routine
ER复制至SPL routine
6) ODBC Smart Trigger
ODBC接口可使用更智能的触发器
3 安全性 Security
1) Integrated Encryption
集成加密：备份与恢复工具（onbar/ontape/archecker/onlog）有内部的加密解密功能
2) Remote Key Store for EAR
encryption-at-rest (EAR) 的密钥存储于AWS
4 扩展性 Extensibility
1) TSTAMP data type for TimeSeries
时间序列中新增TSTAMP数据类型
2) Spatio-temporal Enhancements
Spatio-temporal增强

Informix v14.10.xC2 新增功能
1) InformixHQ enhancements
InformixHQ增强
2) Sharded query enhancements
网格复制增强
3) New Java API for CDC data streaming
CDC增加新的Java API
4) Support for using direct strings in SQLs for clob columns
CLOB字段可直接插入
5) Implementation of UUID keyword/function
引入UUID关键字/功能
6) Partial Index
分片表上使用局部索引
7) cdr list replicate command enhancement
cdr list replicate命令增强
8) cdr migrate server command enhancement
cdr migrate server命令增强
9) Statement cache enhancements
语句缓存增强
10) CSDK Connection Pooling
CSDK增加连接池功能

Informix v14.10.xC3 新增功能
1) GSKit Upgrade
GSKit版本更新为8.0.55.9
2) Java(TM) SE Runtime Environment Upgrade
SunOS及HP-UX上的Java™运行环境更新为8.0.5.35，其它平台更新为8.0.5.37

Informix v14.10.xC4 新增功能
Informix .NET Core
Wire Listener enhancements
Spatio-temporal enhancement
ODBC Connection Pooling enhancement
Replication enhancements
Onstat Command enhancement
InformixHQ enhancements
Solaris Certification
MSG_Date Parameter enhancement
J/Foundation enhancement
Conversion Support for HDR and RSS Secondary Server
Client SDK 4.50.xC4W1 enhancement

Informix v14.10.xC5 新增功能
Shard Join enhancements
InformixHQ enhancements

Informix v14.10.xC6 新增功能
InformixHQ enhancements
TLS 1.3 support added
Auditing enhancement, support for Audit to Syslog (ASL) facility
Distributed transactions and PAM authentication enhancement
New High-availability cluster configuration parameter SEC_NONBLOCKING_CKPT
TEMPTAB_NOLOG enhancement
New replication utility cdr check catalog
Enterprise replication performance enhancements
onstat -g laq enhancement
Limitations on admin() commands on read only secondary
Backup and restore a Remote Secondary Server(RSS)
DBSPACETEMP enhancement
New SMI table syssessiontempspaceusage
New session environment variable DBINFO_DBSPACE_RETURN_NULL_FOR_INVALID_PARTNUM
New session environment option QUERY_TIMEOUT
repl2spl now includes userid and session id
Documentation updates: Wire listener
Removing support for Deployment Assist and SPWDCSM(from JDBC and server) in future releases
CSDK install enhancement
New ODBC DSN Advance Option UPDATE_DESCRIBE or UPDDESC

Informix v14.10.xC7 新增功能
Internal IBM Java version update
GSKit Upgrade
InformixHQ and HDR Secondary Operations
InformixHQ and new SQL Editor
New oncheck -w [#seconds] option to wait for locks
Reverse Scan metrics added to onstat -g tpf
onstat -g rah enhanced to provide more read-ahead information
Chunk mirroring enabled permanently, configuration parameter MIRROR deprecated
Support for Deployment Assist removed
ER Update: Change in the cdc_set_fullrowlogging() function
InformixHQ documentation updates

Informix v14.10.xC8 新增功能
Internal IBM Java version update
Important change to rolling upgrade procedure
New ON-Bar configuration parameter ARCHIVE_UNLOGGED_OBJECTS
AUTO_READAHEAD Enhancement
InformixHQ: H2 Database migration
InformixHQ UI Enhancements
TLS (Transport Layer Security) versions 1.0 and 1.1 disabled
Wire listener configuration parameter 'command.blacklist' deprecated
Removal of Informix Server 14.10 support for HP-UX in future releases
Removing support for ENCCSM, GSSCSM in future releases
Removal of IBM JRE in future releases