New Features in Version 10.00.xC4

IBM Informix Dynamic Server, Version 10.00.xC4 contains the following new 4features:

4
• TRUNCATE table support
4
• Enterprise Replication direct synchronization
4
• Enterprise Replication consistency checking
4
• Enhanced support for IPv6
4
• Secure local connections
4
• Secure DataBlade module paths
4
• Parallel backup and restore is more efficient
4
• DB-Access stops a process after the first error
4
• Informix Interface for TSM supports HP-UX (Itanium)
4
• New default value for IFX_EXTEND_ROLE configuration parameter

TRUNCATE Table support

TRUNCATE is a SQL keyword that quickly deletes active rows from a table 4and the b-tree structures of its indexes. The active rows are deleted without 4dropping the table or its schema, access privileges, triggers, constraints, 4and other attributes. With TRUNCATE TABLE, you can de-populate a local 4table and release (or reuse for the same table) the storage space that formerly 4held its data rows and b-tree structures. For more information, see the Guide to SQL: Syntax.

Enterprise Replication Direct Synchronization

The cdr sync replicate and cdr sync 4replicateset commands perform direct synchronization between a reference 4server and one or more target servers. For more information, see the Enterprise Replication Guide.

Enterprise Replication Consistency Checking

The cdr check replicate and cdr 4check replicateset commands check for consistency within replicates, 4and optionally, repair inconsistent rows. For more information, see the Enterprise Replication Guide.

Enhanced Support for IPv6

IPv6 support now includes automatic discovery of whether or not a platform 4supports IPv6.

Secure Local Connections

The SECURITY_LOCALCONNECTION configuration parameter enables a database 4server administrator (DBSA) to set up security checking for local connections 4with the same host. For more information, see the Administrator's 4Reference.

Secure DataBlade Module Paths

The DB_LIBRARY_PATH configuration parameter allows you to specify a comma-separated 4list of valid directory prefix locations from which the database server can 4load external modules, such as DataBlade modules. You can use DB_LIBRARY_PATH 4to control the location from which shared objects can be loaded, and it allows 4you to enforce policies and standards on the formats of the EXTERNAL NAME 4clause of the CREATE FUNCTION, CREATE PROCEDURE, and CREATE ROUTINE statements. 4For more information, see the Administrator's Reference.

Parallel Backup and Restore is More Efficient

The new BAR_SORT_DBS environment variable can improve the efficiency of 4backup and restore operations whose scope is not the whole system. This environment 4variable implements new sorting methods for parallel dbspace backup and restore. 4BAR_SORT_DBS takes effect if it is set to any value. You can preserve the 4(less efficient) legacy behavior of backup and restore operations by not setting 4BAR_SORT_DBS.

DB-Access Stops a Process After the First Error

In DB-Access, using the -a command-line option 4will stop a process directly after the first error is encountered. Stopping 4a process from continuing after the first error ensures greater database consistency. 4For more information on DB-Access, see the DB-Access 4User's Guide.

Informix Interface for Tivoli Storage Manager Supports HP-UX 4(Itanium)

You can now use the ON-Bar utility with Tivoli Storage Manager on 4the HP-UX (Itanium) platform. The Informix Interface for TSM supports 4HP-UX.

New Default Value for IFX_EXTEND_ROLE Configuration Parameter

The default value of the IFX_EXTEND_ROLE configuration parameter is changing 4from 0 to 1. The new default is more restrictive so that only administrators 4or users who have been granted extend role by administrators can register 4external routines.