Home | Previous Page | Next Page  

Using New Features in Dynamic Server

In This Chapter
New Features in Version 10.00 of IBM Informix Dynamic Server
New Features in Version 10.00.xC4
TRUNCATE Table support
Enterprise Replication Direct Synchronization
Enterprise Replication Consistency Checking
Enhanced Support for IPv6
Secure Local Connections
Secure DataBlade Module Paths
Parallel Backup and Restore is More Efficient
DB-Access Stops a Process After the First Error
Informix Interface for Tivoli Storage Manager Supports HP-UX (Itanium)
New Default Value for IFX_EXTEND_ROLE Configuration Parameter
New Features in Version 10.00.xC3
ANSI-Joins in Distributed Queries
Transaction Support for XA-Compliant External Data Sources
MQ DataBlade Module
Restricting Database Creation
Secure DUMPDIR Configuration Parameter Default Directory
Table-Level Restore Support for Smart Large Objects
AES Ciphers for Network Encryption
Enterprise Replication Statistics Commands
CSDK Included in Dynamic Server Installation
Enhanced Support for Retrieving Subsets of Query Results
Returning Subsets of Query Results as Collection-Derived Tables
J/Foundation Upgraded to JRE 1.4.2
Secure ADTPATH Configuration Parameter Default Directory
UNSECURE_ONSTAT Configuration Parameter
New Features in Version 10.00.xC1
Security Enhancements
Server Usability Enhancements
Performance Enhancements
SQL Enhancements
Enterprise Replication Enhancements
Backup and Restore Enhancements
Storage Enhancements
Extensibility Enhancements
Installation Enhancements
New installation program on UNIX and Linux
Interoperability Enhancements
New Features in Version 9.4
Security Enhancement
Database Server Usability Enhancements
Increase Size of Chunks, Chunk Offsets, and Number of Allowable Chunks
Configurable Event Alarms
Increased Database Server Aliases
Increased File Size Limit
Full Use of Storage Media
Increased Default Values for Tape Block Size Configuration Parameters
Chunk Reserve Pages in Non-Root Chunks
Restartable Fast Recovery
Microsoft Transaction Server/XA Support
Performance Enhancements
PDQ is Enabled for Hold Cursors
Improved Transaction Processing with the B-tree Scanner
Improved Priority Management for the Buffer Manager
Spatial Query Costing
More Precise LRU Maximum and Minimum Settings
Enterprise Replication Enhancements
Enterprise Replication Security
Support for ROW and Collection Data types
Faster Queue Recovery
Replication During Queue Recovery
Large Transactions Support
Improved Availability with HDR
Dynamic Log File
New Commands
New and Altered Configuration Parameters
New Environment Variables
Extensibility Enhancements
Enhanced HDR Support for Extensibility Features
Using an Iterator Function in the FROM Clause of a SELECT Statement
Enhanced CREATE FUNCTION and CREATE PROCEDURE Syntax
SQL Enhancements
INSTEAD OF Triggers on Views
Enhanced SELECT Statement Syntax
Functional Indexes on More Than 16 Columns
Enhanced Dynamic Query Support
Session-Level Non-Default Collation
LOAD TO and UNLOAD FROM with Large Files
SET Residency Statements No Longer Needed
Multiple OUT Parameters
Sequence Objects
ANSI Join Syntax
Unions in Subqueries of SELECT Statements
LVARCHAR Data Types Greater Than 2048 Bytes
New SQL Reserved Words
New Environment Variables
GLS Enhancements
Support for Unicode
Support for Unicode Collation
Full Support for Chinese GB18030-2000 Locale
Reliability, Availability, and Supportability Features
Dynamically Monitor Queries
Print the Session Control Block Address
Display Environment Variable Settings
Print Online Chunk Pages
Display Stored Procedure Information
DataBlade API Enhancements
New mi_get_db_locale() Function
New mi_get_transaction_id() Function
New mi_realloc() function
New mi_stack_limit() Function
New mi_system() Function
Enhanced Stream Support
High-Performance Loader Enhancements
Full Use of Storage Media
New Location for the Custom-Code Shared Library File
Custom-Code Function Input and Output Length
Backup and Restore Enhancements
Renaming Chunks During a Cold Restore
Full Use of Storage Media and Increased File Size Limit
Installation Enhancements
No Files Installed in the /usr/lib Directory
More Recent Client and GLS Files Are Not Overwritten
Serial Number and Key are No Longer Needed
Changed or New URLs
New Features in Version 9.3
UNIX Bundle Installer
Database Server Usability Enhancements
Ability to Display the Maximum Number of Connections
Changes to onconfig.std File
Database Server Administration Utilities (Windows)
High-Availability Data Replication Failover Scripts
DataBlade API Enhancements
New PER_STMT_EXEC and PER_STMT_PREP Memory Durations
NULL Connections for mi_lo() Functions
New mi_collection_card() Function to Obtain Cardinality for Collections
Access to Files on a Client Computer One Buffer at a Time
New Callbacks to Handle Transactions
New Function for Determining the Transaction State for DataBlades
Enterprise Replication Enhancements
Replication of Extensible Data Types
Support Functions for Replication of User-Defined Types
Performance Enhancements to Enterprise Replication
SERIAL Column Primary Keys
Replicate Sets and Exclusive Replicate Sets
Replicating Only Changed Columns
Spooling of Replicate Data to Nonlogging Smart Large Objects
In-Place Alters to Add or Drop Shadow Columns (CRCOLS)
New onstat Options for Enterprise Replication
The cdr finderr Utility
Extensibility Enhancements
DeepCopy Function for Multirepresentational Data Types
Nearest Neighbor Queries in R-Trees
Temporary Sbspaces and Smart Large Objects
Improved Space Allocation of User Data and Metadata in Sbspaces
J/Foundation Enhancements
JVM 1.3 Support in J/Foundation
Performance Enhancements
Configurable Default Lock Modes
The onstat -g stm Option
The Ability to Display the Query Plan Without Executing the Query
Dynamic Addition of Logical Logs
SQL Enhancements
Optional FROM in the DELETE Statement
REVOKE AS User
Features from Dynamic Server, Version 9.21
ANSI Join Syntax
Rename Index Statement
Nonlogging (RAW) Tables
onpladm Utility
The onbar -b -l Command
9.x DB-Access to 7.x Synonyms
SQL Statement Cache Improvements
DataBlade API Features
Functions for Controlling the Virtual-Processor Environment
Functions for Getting Information About a UDR
Java Features in 9.21
JVM 1.2 Support in J/Foundation
Default Values of Java Configuration Parameters
JDBC 2.0 Support
GLS Support for J/Foundation
update_jars.sql Script
Java Runtime Environment Variables
Partial Support for Variable-Length Opaque-Types
References to J/Foundation Features
MaxConnect Support
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]