Table 11 provides an overview of the uses for the various Informix and UNIX environment variables that Version 8.5 and Version 9.5 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 11 indicates environment variables that are described in the IBM Informix: GLS User's Guide.
The term ER Guide in the Page column in Table 11 indicates environment variables that are described in the IBM Informix: Dynamic Server Enterprise Replication Guide.
| Topic | Environment Variable | Page | |
|---|---|---|---|
| Abbreviated year values | DBCENTURY | DBCENTURY | |
| Alarms for SQL operations | |||
| Globally detached indexes | GLOBAL_DETACH_INFORM | GLOBAL_DETACH_INFORM (XPS Only) | |
| Cartesian joins | IFMX_CART_ALRM | IFMX_CART_ALRM (XPS Only) | |
| ANSI/ISO SQL compliance | |||
| Lettercase of owner names | ANSIOWNER | ANSIOWNER (IDS Only) | |
| 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 Only) | |
| network pool size | IFX_NETBUF_PVTPOOL_SIZE | IFX_NETBUF_PVTPOOL_SIZE (UNIX Only) | |
| BYTE or TEXT data buffer | DBBLOBBUF | DBBLOBBUF | |
| Cache: enabling | STMT_CACHE | STMT_CACHE (IDS Only) | |
| size for Optical Subsystem | INFORMIXOPCACHE | INFORMIXOPCACHE (IDS Only) | |
| Client/server: | |||
| default server | INFORMIXSERVER | INFORMIXSERVER | |
| shared memory segments | INFORMIXSHMBASE | INFORMIXSHMBASE (UNIX Only) | |
| 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 Only) | |
| Communication Support Module: DCE-GSS | INFORMIXKEYTAB | INFORMIXKEYTAB (UNIX Only) | |
| concsm.cfg file | INFORMIXCONCSMCFG | INFORMIXCONCSMCFG (IDS Only) | |
| Compiler: | INFORMIXC | INFORMIXC (UNIX Only) | |
| multibyte characters | CC8BITLEVEL | GLS Guide | |
| C++ | INFORMIXCPPMAP | INFORMIXCPPMAP (IDS Only) | |
| ESQL/C | THREADLIB | TOBIGINT (XPS Only) | |
| Configuration file: | |||
| database server | ONCONFIG | ONCONFIG | |
| ignore environment variables | ENVIGNORE | ENVIGNORE (UNIX Only) | |
|
Configuration parameter:
COSERVER |
INFORMIXSERVER | INFORMIXSERVER | |
| DBSERVERNAME | INFORMIXSERVER | INFORMIXSERVER | |
| DBSPACETEMP | DBSPACETEMP | DBSPACETEMP | |
| DIRECTIVES | IFX_DIRECTIVES
|
IFX_DIRECTIVES
|
|
| OPCACHEMAX | INFORMIXOPCACHE | INFORMIXOPCACHE (IDS Only) | |
| OPTCOMPIND | OPTCOMPIND | OPTCOMPIND | |
| OPT_GOAL | OPT_GOAL | OPT_GOAL (IDS and UNIX Only) | |
| 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 Only) | |
| shared memory | INFORMIXSHMBASE | INFORMIXSHMBASE (UNIX Only) | |
| stacksize | INFORMIXSTACKSIZE | INFORMIXSTACKSIZE | |
| temporary tables | DBSPACETEMP
DBTEMP PSORT_DBTEMP |
DBSPACETEMP
DBTEMP (IDS Only) PSORT_DBTEMP |
|
| variable-length packets | IFX_PAD_VARCHAR | IFX_PAD_VARCHAR (IDS Only) | |
| 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 Only) |
|
| DB-Access utility | DBANSIWARN
DBDELIMITER DBEDIT DBFLTMASK DBNLS DBPATH FET_BUF_SIZE INFORMIXSERVER INFORMIXTERM TERM TERMCAP TERMINFO |
DBANSIWARN
DBDELIMITER DBEDIT DBFLTMASK DBNLS (IDS Only) DBPATH FET_BUF_SIZE INFORMIXSERVER INFORMIXTERM (UNIX Only) TERM (UNIX Only) TERMCAP (UNIX Only) TERMINFO (UNIX Only) |
|
| dbexport utility | DBDELIMITER | DBDELIMITER | |
| dbschema utility | TOBIGINT | TOBIGINT (XPS Only) | |
| Delimited identifiers | DELIMIDENT | DELIMIDENT | |
| Disk space | DBUPSPACE | DBUPSPACE | |
| Editor | DBEDIT | DBEDIT | |
| Enterprise Replication | CDR_LOGDELTA
CDR_PERFLOG CDR_ROUTER CDR_RMSCALEFACT |
ER Guide | |
| ESQL/C: ANSI compliance | DBANSIWARN | DBANSIWARN | |
| C compiler | INFORMIXC | INFORMIXC (UNIX Only) | |
| DATETIME formatting | DBTIME | DBTIME;
GLS Guide |
|
| delimited identifiers | DELIMIDENT | DELIMIDENT | |
| multibyte characters | CLIENT_LOCALE, ESQLMF | GLS Guide | |
| multithreaded applications | THREADLIB | TOBIGINT (XPS Only) | |
| 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 Only) | |
| Files: message | DBLANG | DBLANG | |
| Files: temporary | DBSPACETEMP | DBSPACETEMP | |
| Files: temporary, for Gateways | DBTEMP | DBTEMP (IDS Only) | |
| Files: temporary sorting | PSORT_DBTEMP | PSORT_DBTEMP | |
| Files: termcap, terminfo | INFORMIXTERM
TERM TERMCAP TERMINFO |
INFORMIXTERM (UNIX Only)
TERM (UNIX Only) TERMCAP (UNIX Only) TERMINFO (UNIX Only) |
|
| 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 Only) | |
| High-Performance Loader | DBONPLOAD
PLCONFIG PLOAD_LO_PATH PLOAD_SHMBASE |
DBONPLOAD (IDS Only)
PLCONFIG (IDS Only) PLOAD_LO_PATH (IDS Only) PLOAD_SHMBASE (IDS Only) |
|
| 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 Only)
LIBPATH (UNIX Only) SHLIB_PATH (UNIX Only) |
|
| Locale | CLIENT_LOCALE
DB_LOCALE SERVER_LOCALE |
GLS Guide | |
| Lock Mode | IFX_DEF_TABLE_LOCKMODE | IFX_DEF_TABLE_LOCKMODE (IDS Only) | |
| Long Identifiers | IFX_LONGID | IFX_LONGID | |
| Map file for C++ | INFORMIXCPPMAP | INFORMIXCPPMAP (IDS Only) | |
| 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 Only) | |
| Network | DBPATH | DBPATH | |
| Nondefault locale | DBNLS
CLIENT_LOCALE DB_LOCALE SERVER_LOCALE |
DBNLS (IDS Only),;
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 Only) | |
| Optimization: directives | IFX_DIRECTIVES
|
IFX_DIRECTIVES
|
|
| Optimization: message transfers | OPTMSG | OPTMSG | |
| Optimization: join method | OPTCOMPIND | OPTCOMPIND | |
| Optimization: performance goal | OPT_GOAL | OPT_GOAL (IDS and UNIX Only) | |
| OPTOFC feature | OPTOFC | OPTOFC | |
| Parameters | See "Configuration parameter" | *** to *** | |
| Pathname: archecker config file | AC_CONFIG | AC_CONFIG | |
| Pathname: C compiler | INFORMIXC | INFORMIXC (UNIX Only) | |
| Pathname: database files | DBPATH | DBPATH | |
| Pathname: executable programs | PATH | PATH | |
| Pathname: HPL sblob handles | PLOAD_LO_PATH | PLOAD_LO_PATH (IDS Only) | |
| Pathname: installation | INFORMIXDIR | INFORMIXDIR | |
| Pathname: libraries | LD_LIBRARY_PATH
LIBPATH SHLIB_PATH |
LD_LIBRARY_PATH (UNIX Only)
LIBPATH (UNIX Only) SHLIB_PATH (UNIX Only) |
|
| Pathname: message files | DBLANG | DBLANG,;
GLS Guide |
|
| Pathname: parallel sorting | PSORT_DBTEMP | PSORT_DBTEMP | |
| Pathname: remote shell | DBREMOTECMD | DBREMOTECMD (UNIX Only) | |
| Pathname: xfer_config file | XFER_CONFIG | XFER_CONFIG (XPS Only) | |
| Preserve owner name lettercase | ANSIOWNER | ANSIOWNER (IDS Only) | |
| Printing | DBPRINT | DBPRINT | |
| Privileges | NODEFDAC | *** | |
| Query: optimization | IFX_DIRECTIVES
IFMX_OPT_FACT_TABS IFMX_OPT_NON_DIM_TABS OPTCOMPIND OPT_GOAL RTREE_COST_ADJUST_VALUE |
IFX_DIRECTIVES
IFMX_OPT_FACT_TABS (XPS Only) IFMX_OPT_NON_DIM_TABS (XPS Only) OPTCOMPIND OPT_GOAL (IDS and UNIX Only) RTREE_COST_ADJUST_VALUE (IDS Only) |
|
| Query: prioritization | PDQPRIORITY | PDQPRIORITY | |
| Remote shell | DBREMOTECMD | DBREMOTECMD (UNIX Only) | |
| Role separation | INF_ROLE_SEP | INF_ROLE_SEP (IDS Only) | |
| 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 Only)
PLOAD_SHMBASE (IDS Only) |
|
| Shell: remote | DBREMOTECMD | DBREMOTECMD (UNIX Only) | |
| Shell: search path | PATH | PATH | |
| Sorting | PSORT_DBTEMP
PSORT_NPROCS |
PSORT_DBTEMP
PSORT_NPROCS |
|
| SQL statements:caching | STMT_CACHE | STMT_CACHE (IDS Only) | |
| CONNECT | INFORMIXCONTIME
INFORMIXSERVER |
INFORMIXCONRETRY
INFORMIXSERVER |
|
| CREATE TEMP TABLE | DBSPACETEMP | DBSPACETEMP | |
| DESCRIBE FOR UPDATE | IFX_UPDDESC | IFX_UPDDESC (IDS Only) | |
| 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 Only) | |
| UPDATE STATISTICS | DBUPSPACE | DBUPSPACE | |
| Stacksize | INFORMIXSTACKSIZE | INFORMIXSTACKSIZE | |
| String search: trailing blanks | LIBERAL_MATCH | LIBERAL_MATCH (XPS Only) | |
| Temporary tables | DBSPACETEMP
DBTEMP PSORT_DBTEMP |
DBSPACETEMP
DBTEMP (IDS Only) PSORT_DBTEMP |
|
| Terminal handling | INFORMIXTERM
TERM TERMCAP TERMINFO |
INFORMIXTERM (UNIX Only)
TERM (UNIX Only) TERMCAP (UNIX Only) TERMINFO (UNIX Only) |
|
| Time zone, specifying | IBM_XPS_PARAMS | IBM_XPS_PARAMS (XPS Only) | |
| 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 Only) DBPATH FET_BUF_SIZE IFMX_HISTORY_SIZE (XPS Only) INFORMIXSERVER INFORMIXTERM (UNIX Only) TERM (UNIX Only) TERMCAP (UNIX Only) TERMINFO (UNIX Only) |
|
| 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 Only) | |
| Year values (abbreviated) | DBCENTURY | DBCENTURY | |