Configuration parameter changes in Version 11.70

Informix® Version 11.70 contains some configuration parameter changes, including new default values.

New configuration parameters

The following table lists the configuration parameters that were added in Informix 11.70. All parameters are in the onconfig.std file, unless otherwise noted.

Table 1. New configuration parameters
Version	New Configuration Parameter	Description
11.70.xC8	INFORMIXCONRETRY	Specifies the number of connection attempts that can be made to the database server after the initial connection attempt fails. With the INFORMIXCONTIME configuration parameter, specifies the frequency at which the CONNECT statement tries to connect to the database server.
11.70.xC8	INFORMIXCONTIME	Specifies the duration, in seconds, that the CONNECT statement attempts to establish a connection to the database server. With the INFORMIXRETRY configuration parameter, specifies the frequency at which the CONNECT statement tries to connect to the database server.
11.70.xC8	TLS_VERSION	Specifies the version of the Transport Layer Security (TLS) connection.
11.70.xC6	CLUSTER_TXN_SCOPE	If set on the servers in a high-availability cluster, controls whether a transaction commit can be returned to a client application before the transaction is applied in another server session or on another cluster node
11.70.xC6	HA_FOC_ORDER	If set on a primary server in a high-availability cluster, defines a single failover rule to be used by all Connection Managers connecting to that primary server.
11.70.xC6	IFX_XA_UNIQUEXID_IN_ DATABASE	Enables the transaction manager to use same XID to represent global transactions on different databases in the same database server instance.
11.70.xC4	GSKIT_VERSION	Specifies the major version of the IBM® Global Security Kit (GSKit) that the database server uses for encryption and SSL communication.
11.70.xC4	SDS_LOGCHECK	Prevents an SD secondary server from taking over the role of the primary server if network communication between the primary and secondary servers is unavailable.
11.70.xC4	S6_USE_REMOTE_SERVER_CFG	Specifies the file that is used to authenticate secure server connections in a non-trusted network environment. S6_USE_REMOTE_SERVER_CFG is used with the REMOTE_SERVER_CFG configuration parameter.
11.70.xC4	USTLOW_SAMPLE	Enables sampling during the gathering of statistics for UPDATE STATISTICS LOW operations.
11.70.xC3	AUTO_READAHEAD	Changes the automatic read-ahead mode or disables automatic read ahead.
11.70.xC3	LOW_MEMORY_MGR	Enables automatic low memory management, which you can use to change the default behavior of the server when it reaches its memory limit.
11.70.xC3	LOW_MEMORY_RESERVE	Reserves a specific amount of memory for use when critical activities (such as rollback activities) are needed and the server has limited free memory.
11.70.xC3	PN_STAGEBLOB_THRESHOLD	Reserves space for BYTE and TEXT data in round-robin fragments.
11.70.xC2	REMOTE_SERVER_CFG	Specifies the name of a file that lists the remote hosts that are trusted by the computer on which the database server resides.
11.70.xC2	REMOTE_USERS_CFG	Specifies the name of a file that lists names of trusted users that exist on remote hosts.
11.70.xC1	AUTO_STAT_MODE	Enables or disables the recalculation of distribution statistics.
11.70.xC1	BATCHEDREAD_INDEX	Enables the optimizer to automatically fetch a set of keys from an index buffer.
11.70.xC1	BAR_CKPTSEC_TIMEOUT	Sets the amount of time, in seconds, that an RS secondary server should wait for a checkpoint to arrive from the primary server while performing an external backup.
11.70.xC1	CDR_LOG_LAG_ACTION	Specifies how Enterprise Replication responds to a potential log wrap situation.
11.70.xC1	CDR_LOG_STAGING_MAXSIZE	Specifies the maximum amount of space that Enterprise Replication uses to stage compressed log files in the directory specified by the LOG_STAGING_DIR configuration parameter.
11.70.xC1	DEFAULTESCCHAR	Specifies the default escape character.
11.70.xC1	ENABLE_SNAPSHOT_COPY	Enables or disables the ability to clone a server using the ifxclone utility.
11.70.xC1	FAILOVER_TX_TIMEOUT	In high-availability cluster environments, enables transaction survival and indicates the maximum number of seconds after failover that the server should wait before rolling back transactions.
11.70.xC1	FULL_DISK_INIT	Specifies whether or not the disk initialization command (oninit -i) can run on your instance when a page zero exists at the root path location.
11.70.xC1	MQCHLLIB	Specifies the path to the directory containing the IBM WebSphere® MQ client channel definition table.
11.70.xC1	MQCHLTAB	Specifies the name of the client channel definition table.
11.70.xC1	MQSERVER	Defines a channel, specifies the location of the IBM WebSphere MQ server, and specifies the communication method to be used.
11.70.xC1	NS_CACHE	Defines the maximum retention time for an individual entry in the host name/IP address cache, the service cache, the user cache, and the group cache.
11.70.xC1	NUMFDSERVERS	For network connections on UNIX, specifies the maximum number of poll threads to handle network connections moving between virtual processors (VPs).
11.70.xC1	PRELOAD_DLL_FILE	Specifies the path name for a shared library file that is preloaded when the database server is started.
11.70.xC1	SEQ_CACHE_SIZE	Specifies the maximum number of sequence objects that can have preallocated values in the sequence cache.
11.70.xC1	SMX_COMPRESS	Specifies the level of compression that the database server uses before sending data from the source database server to the target database server.
11.70.xC1	SP_AUTOEXPAND	Enable or disables the automatic creation or extension of chunks in a storage space
11.70.xC1	SP_THRESHOLD	Defines the minimum amount of free kilobytes that can exist in a storage space
11.70.xC1	SP_WAITTIME	Specifies the maximum number of seconds that a thread will wait for a storage pool to expand before returning an "out of space" error
11.70.xC1	STATCHANGE	Specifies a percentage of changed rows that triggers the recalculation of distribution statistics.
11.70.xC1	USERMAPPING	Specifies whether or not the database server accepts connections from mapped users.

Configuration parameters that have new default values

The following table lists the configuration parameters that have new default values in the Version 11.70 onconfig.std file.

Table 2. Configuration parameters with new default values in the *onconfig.std* file
Configuration Parameter	Previous Value	New Value
BATCHEDREAD_TABLE	0	1

Configuration parameters that have changed values

The following table lists the configuration parameters that have changed values in Version 11.70.

Table 3. Configuration parameters that have changed values
Version	Configuration Parameter	Previous Values	New Values
11.70.xC9	AUTO_REPREPARE	Disable (0) or enable (1) automatic repreparation.	In addition to the existing values, the configuration parameter offers three new values that you can use to control how much checking takes place, and when it takes place. 3 = don't check statements that were successfully executed recently (optimistic mode) 5 = check only after update statistics are run 7 = both 3 and 5
11.70.xC8	VP_MEMORY_CACHE_KB	The total size of all private memory caches.	The total size of all private memory caches, optionally followed by a comma and the mode (Dynamic or Static) of the caches.
11.70.xC6	ALRM_ALL_EVENTS	1 and 2	0 (on) and 1 (off)