The following table provides information about the new features for IBM Informix Dynamic Server, Version 10.0, that this manual covers. For a description of all new features, see the IBM Informix Getting Started Guide.
| New Features | Reference |
|---|---|
| Support for Distributed Relational Database Architecture (DRDA) protocol | You can connect to DB2 clients through DRDA. Some onstat commands include the DRDA thread name and an indicator to distinguish between SQLI and DRDA sessions. |
| ALRM_ALL_EVENTS | Use this new event-alarm parameter if you want the event-alarm program to operate for all events that are logged in the MSGPATH, instead of only noteworthy events. See ALRM_ALL_EVENTS and Setting ALRM_ALL_EVENTS. |
| Buffer pool size in onstat utility output | The buffer pool size in the output from onstat commands is now indicated in bytes (the page size). See The onstat Utility. |
| BUFFERPOOL | The BUFFERPOOL configuration parameter allows you to specify different page size buffer pools. Information that was specified with the BUFFERS, LRUS, LRU_MAX_DIRTY, and LRU_MIN_DIRTY configuration parameters prior to Version 10.0 is now specified using the BUFFERPOOL configuration parameter. See BUFFERPOOL. |
| 4DB_LIBRARY_PATH | 4Use this configuration parameter to limit the paths from 4which UDRs can be run to those paths that you specify. See DB_LIBRARY_PATH. |
| 3DBCREATE_PERMISSION | 3DBCREATE_PERMISSION restricts the permission to create 3databases to the specified user. You can include multiple copies of DBCREATE_PERMISSION 3in the ONCONFIG file to give additional users permission to create databases. 3For more information see DBCREATE_PERMISSION. |
| DISABLE_B162428_XA_FIX | The DISABLE_B162428_XA_FIX configuration parameter ensures compatibility with applications that require the default behavior of Dynamic Server version 9.4 or earlier. This configuration parameter immediately frees all global transactions after a transaction rollback. |
| DRAUTO | The DRAUTO configuration parameter determines how a secondary database server reacts to an HDR failure. See DRAUTO and the IBM Informix Dynamic Server Administrator's Guide. |
| DRIDXAUTO
onmode -d index onmode- d idxauto |
Used to specify whether the primary High-Availability Data Replication (HDR) server automatically starts index replication if the secondary HDR server detects a corrupted index. The -d idxauto option dynamically changes DRIDXAUTO. The -d index option forces index replication. See DRIDXAUTO and Replicate an Index with Data-Replication. |
| DS_NONPDQ_QUERY_MEM | Use this configuration parameter to increase the amount of sort memory that is a available for a query that is not a Parallel Database Query (PDQ). See DS_NONPDQ_QUERY_MEM , the IBM Informix Dynamic Server Administrator's Guide, and the IBM Informix Dynamic Server Performance Guide. |
| 3DUMPDIR | 3The default value of the DUMPDIR configuration parameter 3in the onconfig.std file is /usr/informix/tmp on UNIX and %INFORMIXDIR%\tmp on Windows. If the DUMPDIR configuration parameter 3is not in the ONCONFIG file, the $INFORMIXDIR/tmp directory is 3used |
| FAST_RESTART_CKPT_FUZZYLOG
FAST_RESTART_PHYSLOG |
These two configuration parameters enable the database server to perform physical logging on fuzzy checkpoints during the roll-forward phase of recovery, thus reducing the time required for recovery. See FAST_RESTART_CKPT_FUZZYLOG and FAST_RESTART_PHYSLOG. |
| 4IFX_EXTEND_ROLE | 4The default, 1, enables the EXTEND role so that administrators 4can grant privileges to a user to create or drop a DataBlade UDR that has 4the EXTERNAL clause. See IFX_EXTEND_ROLE and the IBM Informix Administrator's Guide. |
| 3LISTEN_TIMEOUT
3 3MAX_INCOMPLETE_ 3 3CONNECTIONS |
3New configuration parameters for Windows systems that you 3can use to reduce the incomplete connection timeout period and restrict the 3number of incomplete requests for connections, thus reducing the risk of a 3hostile, denial-of-service (DOS) flood attack. See LISTEN_TIMEOUT and MAX_INCOMPLETE_CONNECTIONS and the Security 3chapter in the IBM Informix Dynamic Server Administrator's Guide. |
| onmode -j | This option is used to change the database server to single-user mode. See Change Database Server Mode. |
| onparams -b | The -b flag for onparams utility allows you to create a new buffer pool while the database server is running. See Add a New Buffer Pool. |
| Rename a Dbspace, Blobspace, Sbspace, or Extspace with the onspaces utility | See Rename a Dbspace, Blobspace, Sbspace, or Extspace. |
| SHMADD
SHMVIRTSIZE |
These configuration parameters allow you to increase the size of segments for shared memory. See SHMADD and SHMVIRTSIZE. |
| TBLTBLFIRST
TBLTBLNEXT |
Specifies the first and the next extent size of tblspace tblspace in the root dbspace. See TBLTBLFIRST, TBLTBLNEXT, and Structure of the Tblspace Tblspace. |
| 3UNSECURE_ONSTAT | 3The onstat commands that show SQL 3statement text being executed by a session are normally restricted to DBA 3users. You can set the UNSECURE_ONSTAT configuration parameter to 1 to remove 3this restriction. |