What’s new in IBM Informix 12.10 ?

As of Feb 2016, the latest release is 12.10.xC6. Below are the new features in IBM Informix version 12.10.xC6.

Server changes
• Support for additional platforms – Informix is now available on IBM POWER8® for ppc64le with Red Hat Enterprise Linux 7.1, SUSE Linux Enterprise Server 12, and Ubuntu 14.04 LTS.
• Server changes that affect migration – Informix version 12.10.xC6 contains the following new configuration parameters and environment variable:

    BAR_MAX_RESTORE configuration parameter
    IFXGUARD configuration parameter
    SHARD_ID configuration parameter
    SHARD_MEM configuration parameter
    SMX_NUMPIPES configuration parameter
    TENANT_LIMIT_CONNECTIONS configuration parameter
    TENANT_LIMIT_MEMORY configuration parameter
    IFX_SOC_KEEPALIVE environment variable

• Limit shared memory and connections for tenant databases – You can limit shared memory and the number of connections for tenant databases in a multitenancy environment. You can use configuration parameters to set limits for all tenants or parameters to the tenant create or tenant update argument to the task or admin SQL administration API command.
• Restore tenant databases to a point in time – You can now restore a tenant database to a particular point in time. Run the onbar -r command with the new -T option to specify the tenant database and the -t option to specify the point in time.
Backup and restore
• Control restore resources
JSON compatibility
• Parallel sharded queries – You can now run SELECT statements in sharded queries in parallel instead of serially on each shard. Parallel sharded queries return results faster.
• Wire listener enhancements
• Authenticate wire listener connections with Informix
• Starting the wire listener for the REST API
• MongoDB 2.6 and 3.0 compatibility – Informix now supports a few MongoDB commands mentioned below. You can authenticate MongoDB clients with the MongoDB 3.0 SCRAM-SHA-1 authentication method. You must upgrade the user schema for existing users. You upgrade to MongoDB 3.0 by setting the new mongo.api.version parameter to 3.0 in the wire listener configuration file.

    The query and write operation commands insert, update, and delete.
    The instance administration commands createIndexes, listCollections, and listIndexes.
    The user management commands, for MongoDB 2.6 and later, createUser, updateUser, dropUser, dropAllUserFromDatabase, grantRolesToUser, revokeRolesFromUser, and usersInfo.
    The role management commands: createRole, updateRole, dropRole, dropAllRolesFromDatabase, grantPrivilegesToRole, revokePrivilegesFromRole, grantRolesToRole, revokeRolesFromRole, and rolesInfo.
    The query and projection command $eq.
    The field update operators $mul, $min, $max, and $currentDate.
    The pipeline aggregation operator $out.

High availability
• Faster communication between high-availability servers
• Faster index transfer to secondary servers
• Easier cloning of database servers
Application development
• Reoptimize JDBC queries – When you run queries through the Informix JDBC Driver, you can now reoptimize previously prepared query plans. Set the new withReoptimization argument of the IfmxPreparedStatement.executeQuery method to true.
• Keep JDBC socket connections open – You can now keep long-running JDBC socket connections from timing out due to inactivity. Set the IFX_SOC_KEEPALIVE environment variable to true when you open a socket connection with the Informix JDBC Driver.
• Avoid caching SQL statements with unpredictable query plans – Some SQL statements produce significantly different query plans depending on the values of the placeholders that are passed to the database server when the statements are run. Using a cached query plan for such a statement might result in poor performance. You can now avoid caching an SQL statement whose query plan is unpredictable by including the AVOID_STMT_CACHE optimizer directive.

• Prioritize databases for automatic update statistics
• Audit Informix databases with IBM Security Guardium – You can now audit the user actions for your Informix database server with IBM Security Guardium®, version 10.0. After you set up the Guardium server, you start the ifxguard utility to monitor connections to your Informix databases. You can customize the behavior of the ifxguard utility by editing the ifxguard configuration file and by setting the IFXGUARD configuration parameter in the onconfig file.
Time series data
• Show time series reference count – You can now see the time series reference count in the metadata section of the output of the TSInfo function. The time series reference count is the number rows in time series tables that reference the same time series data in a container.
• Default dbspace for time series containers – You can now specify NULL instead of a dbspace name when you create containers with the TSCreateContainer procedure. The container is created in the same dbspace as the time series table, or, if the table is in a tenant database, the dbspace for the tenant database catalogs.
• Enhanced monitoring of IBM Informix Warehouse Accelerator queries – When you run the ondwa tasks command to monitor Informix Warehouse Accelerator queries, the command now displays client session information for running queries and basic information about queued queries. The client session information includes the session ID and the server number to which the client is connected.


Leave a Reply

Your email address will not be published. Required fields are marked *