Index of Environment Variables

Home | Previous Page | Next Page Environment Variables >

Index of Environment Variables

Table 15 provides an overview of the uses for the various Informix and UNIX environment variables that Version 8.5 and Version 10.0 support. This serves as an index to general topics and lists the related environment variables and the pages where the environment variables are introduced. Where the Topic column is empty, the entry refers to the previously listed topic.

The term GLS Guide in the Page column in Table 15 indicates environment variables that are described in the IBM Informix: GLS User's Guide.

The term ER Guide in the Page column in Table 15 indicates environment variables that are described in the IBM Informix: Dynamic Server Enterprise Replication Guide.

Table 15. Uses for Environment Variables
Topic		Environment Variable	Page
Abbreviated year values		DBCENTURY	DBCENTURY
Alarms for SQL operations
	Globally detached indexes	GLOBAL_DETACH_INFRM	GLOBAL_DETACH_INFORM (XPS)
	Cartesian joins	IFMX_CART_ALARM	IFMX_CART_ALRM (XPS)
ANSI/ISO SQL compliance
	Lettercase of owner names	ANSIOWNER	ANSIOWNER (IDS)
	Informix syntax extensions	DBANSIWARN	DBANSIWARN
	default table privileges	NODEFDAC	NODEFDAC
archecker utility		AC_CONFIG	AC_CONFIG
Buffer: fetch size		FET_BUF_SIZE	FET_BUF_SIZE
	network size	IFX_NETBUF_SIZE	IFX_PAD_VARCHAR (IDS)
	network pool size	IFX_NETBUF_PVTPOOL_SIZE	IFX_NETBUF_PVTPOOL_SIZE (UNIX)
	BYTE or TEXT data buffer	DBBLOBBUF	DBBLOBBUF
Cache: enabling		STMT_CACHE	STMT_CACHE (IDS)
	size for Optical Subsystem	INFORMIXOPCACHE	INFORMIXOPCACHE (IDS)
Client/server:
	default server	INFORMIXSERVER	INFORMIXSERVER
	shared memory segments	INFORMIXSHMBASE	INFORMIXSHMBASE (UNIX)
	stacksize for client session	INFORMIXSTACKSIZE	INFORMIXSTACKSIZE
	locale of client, server	CLIENT_LOCALE, DBLOCALE	GLS Guide
	locale for file I/O	SERVER_LOCALE	GLS Guide
Code-set conversion
	code set of client, server	CLIENT_LOCALE, DB_LOCALE	GLS Guide
	character-string conversion	DBNLS	DBNLS (IDS)
Communication Support Module: DCE-GSS		INFORMIXKEYTAB	INFORMIXKEYTAB (UNIX)
	concsm.cfg file	INFORMIXCONCSMCFG	INFORMIXCONCSMCFG (IDS)
	Compiler:	INFORMIXC	INFORMIXC (UNIX)
	multibyte characters	CC8BITLEVEL	GLS Guide
	C++	INFORMIXCPPMAP	INFORMIXCPPMAP (IDS)
	ESQL/C	THREADLIB	TOBIGINT (XPS)
Configuration file:
	database server	ONCONFIG	ONCONFIG
	ignore environment variables	ENVIGNORE	ENVIGNORE (UNIX)
	Configuration parameter: COSERVER	INFORMIXSERVER	INFORMIXSERVER
	DBSERVERNAME	INFORMIXSERVER	INFORMIXSERVER
	DBSPACETEMP	DBSPACETEMP	DBSPACETEMP
	DIRECTIVES	IFX_DIRECTIVES IFX_EXTDIRECTIVES	IFX_DIRECTIVES IFX_EXTDIRECTIVES
	OPCACHEMAX	INFORMIXOPCACHE	INFORMIXOPCACHE (IDS)
	OPTCOMPIND	OPTCOMPIND	OPTCOMPIND
	OPT_GOAL	OPT_GOAL	OPT_GOAL (IDS, UNIX)
	PDQPRIORITY	PDQPRIORITY	PDQPRIORITY
	STACKSIZE	INFORMIXSTACKSIZE	INFORMIXSTACKSIZE
Connecting		INFORMIXCONRETRY INFORMIXCONTIME INFORMIXSERVER INFORMIXSQLHOSTS	INFORMIXCONRETRY INFORMIXCONRETRY INFORMIXSERVER INFORMIXSQLHOSTS
Data distributions		DBUPSPACE	DBUPSPACE
Database locale		DB_LOCALE	GLS Guide
Database server		INFORMIXSERVER	INFORMIXSERVER
	locale for file I/O	SERVER_LOCALE	GLS Guide
	configuration file	ONCONFIG	ONCONFIG
	parallel sorting	PSORT_DBTEMP PSORT_NPROCS	PSORT_DBTEMP PSORT_NPROCS
	parallelism	PDQPRIORITY	PDQPRIORITY
	role separation	INF_ROLE_SEP	INF_ROLE_SEP (IDS)
	shared memory	INFORMIXSHMBASE	INFORMIXSHMBASE (UNIX)
	stacksize	INFORMIXSTACKSIZE	INFORMIXSTACKSIZE
	temporary tables	DBSPACETEMP DBTEMP PSORT_DBTEMP	DBSPACETEMP DBTEMP (IDS) PSORT_DBTEMP
	variable-length packets	IFX_PAD_VARCHAR	IFX_PAD_VARCHAR (IDS)
Date and time values, formats		DBCENTURY DBDATE GL_DATE DBTIME GL_DATETIME IBM_XPS_PARAMS	DBCENTURY DBDATE: GLS Guide DBTIME: GLS Guide IBM_XPS_PARAMS (XPS)
DB-Access utility		DBANSIWARN DBDELIMITER DBEDIT DBFLTMASK DBNLS DBPATH FET_BUF_SIZE INFORMIXSERVER INFORMIXTERM TERM TERMCAP TERMINFO	DBANSIWARN DBDELIMITER DBEDIT DBFLTMASK DBNLS (IDS) DBPATH FET_BUF_SIZE INFORMIXSERVER INFORMIXTERM (UNIX) TERM (UNIX) TERMCAP (UNIX) TERMINFO (UNIX)
dbexport utility		DBDELIMITER	DBDELIMITER
dbschema utility		TOBIGINT	TOBIGINT (XPS)
Delimited identifiers		DELIMIDENT	DELIMIDENT
Disk space		DBUPSPACE	DBUPSPACE
Editor		DBEDIT	DBEDIT
Enterprise Replication		CDR_LOGDELTA CDR_PERFLOG CDR_ROUTER CDR_RMSCALEFACT CDRSITES_731 CDRSITES_92X	ER Guide
ESQL/C: ANSI compliance		DBANSIWARN	DBANSIWARN
	C compiler	INFORMIXC	INFORMIXC (UNIX)
	DATETIME formatting	DBTIME	DBTIME; GLS Guide
	delimited identifiers	DELIMIDENT	DELIMIDENT
	multibyte characters	CLIENT_LOCALE, ESQLMF	GLS Guide
	multithreaded applications	THREADLIB	TOBIGINT (XPS)
	C preprocessor	CPFIRST	CPFIRST
Executable programs		PATH	PATH
Fetch buffer size		FET_BUF_SIZE	FET_BUF_SIZE
Filenames: multibyte		GLS8BITSYS	GLS Guide
Files: field delimiter		DBDELIMITER	DBDELIMITER
Files: installation		INFORMIXDIR	INFORMIXDIR
Files: locale		CLIENT_LOCALE DB_LOCALE SERVER_LOCALE	GLS Guide
Files: map for C++		INFORMIXCPPMAP	INFORMIXCPPMAP (IDS)
Files: message		DBLANG	DBLANG
Files: temporary		DBSPACETEMP	DBSPACETEMP
Files: temporary, for Gateways		DBTEMP	DBTEMP (IDS)
Files: temporary sorting		PSORT_DBTEMP	PSORT_DBTEMP
Files: termcap, terminfo		INFORMIXTERM TERM TERMCAP TERMINFO	INFORMIXTERM (UNIX) TERM (UNIX) TERMCAP (UNIX) TERMINFO (UNIX)
Formats: date and time		DBDATE GL_DATE DBTIME GL_DATETIME	DBDATE; GLS Guide DBTIME; GLS Guide
Format: money		DBMONEY	DBMONEY, GLS Guide
Gateways		DBTEMP	DBTEMP (IDS)
High-Performance Loader		DBONPLOAD PLCONFIG PLOAD_LO_PATH PLOAD_SHMBASE	DBONPLOAD (IDS) PLCONFIG (IDS) PLOAD_LO_PATH (IDS) PLOAD_SHMBASE (IDS)
Identifiers: delimited		DELIMIDENT	DELIMIDENT
Identifiers: longer than 18 bytes		IFX_LONGID	IFX_LONGID
Identifiers: multibyte characters		CLIENT_LOCALE,ESQLMF	GLS Guide
IBM Informix Storage Manager		ISM_COMPRESSION ISM_DEBUG_FILE ISM_DEBUG_LEVEL ISM_ENCRYPTION	ISM_COMPRESSION ISM_DEBUG_FILE ISM_DEBUG_LEVEL ISM_ENCRYPTION
IBM Informix Storage Manager		ISM_MAXLOGSIZE ISM_MAXLOGVERS	ISM_MAXLOGSIZE ISM_MAXLOGVERS
Installation		INFORMIXDIR PATH	INFORMIXDIR PATH
Language environment		DBLANG See also "Nondefault Locale"	DBLANG,; GLS Guide
Libraries		LD_LIBRARY_PATH LIBPATH SHLIB_PATH	LD_LIBRARY_PATH (UNIX) LIBPATH (UNIX) SHLIB_PATH (UNIX)
Locale		CLIENT_LOCALE DB_LOCALE SERVER_LOCALE	GLS Guide
Lock Mode		IFX_DEF_TABLE_LOCKMODE	IFX_DEF_TABLE_LOCKMODE (IDS)
Long Identifiers		IFX_LONGID	IFX_LONGID
Map file for C++		INFORMIXCPPMAP	INFORMIXCPPMAP (IDS)
Message chaining		OPTMSG	OPTMSG
Message files		DBLANG	DBLANG,; GLS Guide
Money format		DBMONEY	DBMONEY,; GLS Guide
Multibyte characters		CLIENT_LOCALE DB_LOCALE SERVER_LOCALE	GLS Guide
Multibyte filter		ESQLMF	GLS Guide
Multithreaded applications		THREADLIB	TOBIGINT (XPS)
Network		DBPATH	DBPATH
Nondefault locale		DBNLS CLIENT_LOCALE DB_LOCALE SERVER_LOCALE	DBNLS (IDS),; GLS Guide
ON–Bar utility		ISM_COMPRESSION ISM_DEBUG_LEVEL ISM_ENCRYPTION	ISM_COMPRESSION ISM_DEBUG_LEVEL ISM_ENCRYPTION
ONCONFIG parameters		See "Configuration parameter"	***
Optical Subsystem		INFORMIXOPCACHE	INFORMIXOPCACHE (IDS)
Optimization: directives		IFX_DIRECTIVES IFX_EXTDIRECTIVES	IFX_DIRECTIVES IFX_EXTDIRECTIVES
Optimization: message transfers		OPTMSG	OPTMSG
Optimization: join method		OPTCOMPIND	OPTCOMPIND
Optimization: performance goal		OPT_GOAL	OPT_GOAL (IDS, UNIX)
OPTOFC feature		OPTOFC	OPTOFC
Parameters		See "Configuration parameter"	* to *
Pathname: archecker config file		AC_CONFIG	AC_CONFIG
Pathname: C compiler		INFORMIXC	INFORMIXC (UNIX)
Pathname: database files		DBPATH	DBPATH
Pathname: executable programs		PATH	PATH
Pathname: HPL sblob handles		PLOAD_LO_PATH	PLOAD_LO_PATH (IDS)
Pathname: installation		INFORMIXDIR	INFORMIXDIR
Pathname: libraries		LD_LIBRARY_PATH LIBPATH SHLIB_PATH	LD_LIBRARY_PATH (UNIX) LIBPATH (UNIX) SHLIB_PATH (UNIX)
Pathname: message files		DBLANG	DBLANG,; GLS Guide
Pathname: parallel sorting		PSORT_DBTEMP	PSORT_DBTEMP
Pathname: remote shell		DBREMOTECMD	DBREMOTECMD (UNIX)
Pathname: xfer_config file		XFER_CONFIG	XFER_CONFIG (XPS)
Preserve owner name lettercase		ANSIOWNER	ANSIOWNER (IDS)
Printing		DBPRINT	DBPRINT
Privileges		NODEFDAC	***
Query: optimization		IFX_DIRECTIVES IFX_EXTDIRECTIVES IFMX_OPT_FACT_TABS IFMX_OPT_NON_DIM_TABS OPTCOMPIND OPT_GOAL RTREE_COST_ADJUST_VALUE	IFX_DIRECTIVES IFX_EXTDIRECTIVES IFMX_OPT_FACT_TABS (XPS) IFMX_OPT_NON_DIM_TABS (XPS) OPTCOMPIND OPT_GOAL (IDS, UNIX) RTREE_COST_ADJUST_VALUE (IDS)
Query: prioritization		PDQPRIORITY	PDQPRIORITY
Remote shell		DBREMOTECMD	DBREMOTECMD (UNIX)
Role separation		INF_ROLE_SEP	INF_ROLE_SEP (IDS)
Rolled-back transactions		DBACCNOIGN, IFX_ XASTDCOMPLIANCE_XAEND	DBACCNOIGN IFX_XASTDCOMPLIANCE_XAEND
Routine: DATETIME formatting		DBTIME	DBTIME,; GLS Guide
Server		See "Database Server"	Database server
Server locale		SERVER_LOCALE	GLS Guide
Shared memory		INFORMIXSHMBASE PLOAD_SHMBASE	INFORMIXSHMBASE (UNIX) PLOAD_SHMBASE (IDS)
Shell: remote		DBREMOTECMD	DBREMOTECMD (UNIX)
Shell: search path		PATH	PATH
Sorting		PSORT_DBTEMP PSORT_NPROCS	PSORT_DBTEMP PSORT_NPROCS
SQL statements:caching		STMT_CACHE	STMT_CACHE (IDS)
	CONNECT	INFORMIXCONTIME INFORMIXSERVER	INFORMIXCONRETRY INFORMIXSERVER
	CREATE TEMP TABLE	DBSPACETEMP	DBSPACETEMP
	DESCRIBE FOR UPDATE	IFX_UPDDESC	IFX_UPDDESC (IDS)
	LOAD, UNLOAD	DBDELIMITER	DBDELIMITER
	LOAD, UNLOAD	DBBLOBBUF	DBBLOBBUF
	SELECT INTO TEMP	DBSPACETEMP	DBSPACETEMP
	SET PDQPRIORITY	PDQPRIORITY	PDQPRIORITY
	SET STMT_CACHE	STMT_CACHE	STMT_CACHE (IDS)
	UPDATE STATISTICS	DBUPSPACE	DBUPSPACE
Stacksize		INFORMIXSTACKSIZE	INFORMIXSTACKSIZE
String search: trailing blanks		LIBERAL_MATCH	LIBERAL_MATCH (XPS)
Temporary tables		DBSPACETEMP DBTEMP PSORT_DBTEMP	DBSPACETEMP DBTEMP (IDS) PSORT_DBTEMP
Terminal handling		INFORMIXTERM TERM TERMCAP TERMINFO	INFORMIXTERM (UNIX) TERM (UNIX) TERMCAP (UNIX) TERMINFO (UNIX)
Time-limited software license		IFX_NO_TIMELIMIT_WARNING	IFX_NO_TIMELIMIT_WARNING
Time zone, specifying		IBM_XPS_PARAMS	IBM_XPS_PARAMS (XPS)
Utilities: DB-Access		DBANSIWARN DBDELIMITER DBEDIT DBFLTMASK DBNLS DBPATH FET_BUF_SIZE IFMX_HISTORY_SIZER INFORMIXSERVER INFORMIXTERM TERM TERMCAP TERMINFO	DBANSIWARN DBDELIMITER DBEDIT DBFLTMASK DBNLS (IDS) DBPATH FET_BUF_SIZE IFMX_HISTORY_SIZE (XPS) INFORMIXSERVER INFORMIXTERM (UNIX) TERM (UNIX) TERMCAP (UNIX) TERMINFO (UNIX)
Utilities: dbexport		DBDELIMITER	DBDELIMITER
Utilities: ON–Bar		ISM_COMPRESSION ISM_DEBUG_LEVEL ISM_ENCRYPTION	ISM_COMPRESSION ISM_DEBUG_LEVEL ISM_ENCRYPTION
Variables: overriding		ENVIGNORE	ENVIGNORE (UNIX)
Year values (abbreviated)		DBCENTURY	DBCENTURY