Configuration parameter changes in Version 11.50

The onconfig.std file was reorganized for Informix® Version 11.50. In addition, some configuration parameters were added to the onconfig.std file, and some configuration parameters have new default values.

In the Version 11.50 onconfig.std file, comments and the parameters are listed separately and are grouped by functional areas. Some configuration parameters that specify sizes now have higher values. Some configuration parameters that specify file locations now have more secure default locations under the $INFORMIXDIR directory.

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

Table 1. New configuration parameters added in Version 11.50
Version	New Configuration Parameter	Description
11.50.xC8	NET_IO_TIMEOUT_ALARM	Controls whether to be notified if network write operations are blocked for 30 minutes or more.
11.50.xC8	RSS_FLOW_CONTROL	Specifies the boundaries within which flow control is enabled in a high-availability cluster that contains at least one RS secondary server.
11.50.xC6	BATCHEDREAD_TABLE	Enables or disables light scans on compressed tables, tables with rows that are larger than a page, and tables with any type of data, including VARCHAR, LVARCHAR, and NVARCHAR data.
11.50.xC6	CONVERSION_GUARD	Enables changes made during an upgrade to a new version of the server and the upgrade fails.
11.50.xC6	RESTORE_POINT_DIR	Specifies the path of the directory where all restore-point files are located if you are undoing changes made during an upgrade that failed. This directory must be empty, and the server offline, before the upgrade begins. The server stores restore point files in a subdirectory of the specified directory, with the server number as the subdirectory name.
11.50.xC6	SB_CHECK_FOR_TEMP	Prevents the copying of a temporary smart large object into a permanent table.
11.50.xC5	DELAY_APPLY	Used to configure RS secondary servers to wait for a specified period of time before applying logs.
11.50.xC5	LOG_STAGING_DIR	Specifies the location of log files received from the primary server when configuring delayed application of log files on RS secondary servers.
11.50.xC5	STOP_APPLY	Used to stop an RS secondary server from applying log files received from the primary server.
11.50.xC5	SQL_LOGICAL_CHAR	When enabled, causes size specifications in the declarations of character data types to be interpreted in units of logical characters, rather than as bytes.
11.50.xC4	CHECKALLDOMAINSFORUSER	Configures how Informix searches for user names in a networked Windows environment. Not in the onconfig.std file.
11.50.xC2	LIMITNUMSESSIONS	Defines the maximum number of sessions that you want connected to Informix. If you specify a maximum number, you can also specify whether you want Informix to print messages to the online.log file when the number of sessions approaches the maximum number.
11.50	FAILOVER_CALLBACK	Specifies the full path name of a script that the database server executes when the server transitions from a secondary server to a primary or standard server.
11.50	HA_ALIAS	When a secondary server connects to a primary server, specifies the name of a network alias to use if a failover occurs.
11.50	MSG_DATE	When enabled, adds a date to the front of each message in the online log.
11.50	SHMNOACCESS	Specifies a virtual memory address range to not use to attach shared memory.
11.50	SSL_KEYSTORE_FILE	On clients, specifies the fully qualified file name of the keystore that stores the certificates of all servers to which the client connects. Not in the onconfig.std file.
11.50	SSL_KEYSTORE LABEL	On Informix, specifies the label of the server digital certificate used in the keystore database that stores Secure Sockets Layer (SSL) keys and digital certificates.
11.50	SSL_KEYSTORE_STH	On clients, specifies the fully qualified file name of the stash file that contains the encrypted keystore password. Not in the onconfig.std file.
11.50	STORAGE_FULL_ALARM	Configures the frequency and severity of messages and alarms when storage spaces become full.
11.50	UPDATABLE_SECONDARY	Enables client applications to perform update, insert, and delete operations on a high-availability secondary server.

Configuration parameters added to the onconfig.std file

The following table lists the existing configuration parameters that were added to the onconfig.std file in Version 11.50.

Table 2. Configuration parameters added to the onconfig.std file
Configuration Parameter	Value
ADMIN_USER_MODE_WITH_DBSA	none
BTSCANNER	num=1,priority=low,threshold=5000, rangesize=1,alice=6,compression=default
BACKUP_FILTER	none
BAR_DEBUG	0
CDR_SUPPRESS_ATSRISWARN	none
DD_HASHMAX	10
DD_HASHSIZE	31
DEF_TABLE_LOCKMODE	page
DS_HASHSIZE	31
DS_POOLSIZE	127
ENCRYPT_CDR	none
ENCRYPT_CIPHERS	none
ENCRYPT_HDR	none
ENCRYPT_MAC	none
ENCRYPT_MACFILE	none
ENCRYPT_SMX	none
ENCRYPT_SWITCH	none
EXT_DIRECTIVES	0
FASTPOLL	1
LOG_INDEX_BUILDS	none
MAX_INCOMPLETE_CONNECTIONS	1024
PC_HASHSIZE	31
PC_POOLSIZE	127
PLCY_HASHSIZE	127
PLCY_POOLSIZE	31
PLOG_OVERFLOW_PATH	UNIX: $INFORMIXDIR/tmp Windows: none
RESTORE_FILTER	none
SBSPACETEMP	none
SDS_ENABLE	none
SDS_PAGING	none
SDS_TEMPDBS	none
SDS_TIMEOUT	20
SECURITY_LOCALCONNECTION	none
SQLTRACE	Commented out: # SQLTRACE level=low,ntraces=1000,size=2,mode=global
STMT_CACHE	0
STMT_CACHE_HITS	0
STMT_CACHE_NOLIMIT	0
STMT_CACHE_NUMPOOL	1
STMT_CACHE_SIZE	512
UNSECURE_ONSTAT	none
USRC_HASHSIZE	31
USRC_POOLSIZE	127
VPCLASS	cpu,num=1,noage Commented out: # VPCLASS aio,num=1 Commented out: #VPCLASS jvp,num=1

Configuration parameters that have new default values

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

Table 3. Configuration Parameters with New Default Values in the onconfig.std File
Configuration parameter	Previous value	New value
ADMIN_MODE_USERS	1	None
ALARMPROGRAM	UNIX: /usr/informix/etc/alarmprogram.sh Windows: None	UNIX: $INFORMIXDIR/etc/alarmprogram.sh Windows: $INFORMIXDIR\etc\alarmprogram.bat
BAR_ACT_LOG	/usr/informix/bar_act.log	UNIX: $INFORMIXDIR/tmp/bar_act.log Windows: $INFORMIXDIR\tmp\bar_act.log
BAR_BSALIB_PATH	UNIX: $INFORMIXDIR/lib/libsad001.so Window: libbsa.dll	None
BAR_DEBUG_LOG	UNIX: /usr/informix/bar_dbug.log Windows: bar_dbug.log	UNIX: $INFORMIXDIR/tmp/bar_dbug.log Windows: $INFORMIXDIR\tmp\bar_dbug.log
BUFFERPOOL	Operating systems with 2K page size: default,buffers=5000,lrus=8, lru_min_dirty=50, lru_max_dirty=60 size=2k,buffers=5000,lrus=8, lru_min_dirty=50, lru_max_dirty=60 Operating systems with 4K page size: default,buffers=1000,lrus=8, lru_min_dirty=50, lru_max_dirty=60 size=4k,buffers=1000,lrus=8, lru_min_dirty=50, lru_max_dirty=60	Operating systems with 2K page size: default,buffers=10000,lrus=8, lru_min_dirty=50.00, lru_max_dirty=60.50 size=2k,buffers=50000,lrus=8, lru_min_dirty=50, lru_max_dirty=60 Operating systems with 4K page size: default,buffers=10000,lrus=8, lru_min_dirty=50.00, lru_max_dirty=60.50 size=4k,buffers=10000,lrus=8, lru_min_dirty=50, lru_max_dirty=60
CLEANERS	1	8
CONSOLE	UNIX: /dev/console Windows: console.log	UNIX: $INFORMIXDIR/tmp/online.con Windows: online.con
DB_LIBRARY_PATH	commented out: # DB_LIBRARY_PATH $INFORMIXDIR/extend	commented out: # DB_LIBRARY_PATH
DRLOSTFOUND	UNIX: /usr/etc/dr.lostfound Windows: \tmp	UNIX: $INFORMIXDIR/etc/dr.lostfound Windows: $INFORMIXDIR\tmp
DUMPDIR	UNIX: /usr/informix/tmp Windows: INFORMIXDIR\tmp	UNIX: $INFORMIXDIR/tmp Windows: $INFORMIXDIR\tmp
EXPLAIN_STAT	0	1
LISTEN_TIMEOUT	10	60
LOCKS	2000	20000
LOGBUFF	32	64
LOGSIZE	2000	10000
LTAPEDEV	UNIX: /dev/tapedev Windows: \\.TAPE1	UNIX: /dev/tapedev (same as previous value) Windows: NUL
MIRRORPATH	None	UNIX: $INFORMIXDIR/tmp/demo_on.root_mirror Windows: none
MSGPATH	UNIX: /usr/informix/online.log Windows: online.log	UNIX: $INFORMIXDIR/tmp/online.log Windows: online.log
NETTYPE	UNIX: none Windows: onsoctcp,drsoctcp,1,NET	UNIX: ipcshm,1,50,CPU Windows: none
PHYSBUFF	32	128
PHYSFILE	2000	50000
RA_PAGES	None	64
RA_THRESHOLD	None	16
ROOTPATH	UNIX: /dev/online_root Windows: None	UNIX: $INFORMIXDIR/tmp/demo_on.rootdbs Windows: None
ROOTSIZE	30000	200000
SHMVIRT_ALLOCSEG	0	0,3
SHMVIRTSIZE	8192	32656
SYSALARMPROGRAM	UNIX: /usr/informix/etc/evidence.sh Windows: INFORMIXIDR\etc\evidence.bat	UNIX: $INFORMIXDIR/etc/evidence.sh Windows: Commented out: # SYSALARMPROGRAM $INFORMIXDIR\etc\evidence.bat
TAPEBLK	32	UNIX: 32 Windows: 16
TAPESIZE	10240	0

Configuration parameters that were changed

The following configuration parameters were changed in Version 11.50:

DIRECT_IO: Has new option for concurrent I/O on AIX® operating systems.
DUMPSHMEM: Has new options for controlling how much memory is written to a dump file.

JVPJAVAHOME: /usr/informix in the directory name of the configuration parameter is replaced with $INFORMIXDIR.
The value is now: $INFORMIXDIR/extend/krakatoa/jre
JVPPROPFILE: /usr/informix" in the directory name of the configuration parameter is replaced with $INFORMIXDIR.
The value is now: $INFORMIXDIR/extend/krakatoa/.jvpprops
JVPLOGFILE: /usr/informixin the directory name of the configuration parameter is replaced with $INFORMIXDIR.
The value is now: $INFORMIXDIR/jvp.log
JVPCLASSPATH: /usr/informixin the directory name of the configuration parameter is replaced with $INFORMIXDIR.
The value is now: $INFORMIXDIR/extend/krakatoa/krakatoa.jar:$INFORMIXDIR/extend/krakatoa/jdbc.jar