Table 9 contains an alphabetical list of the environment variables that you can set for an Informix database server and SQL API products. Most of these environment variables are described in this chapter on the pages listed in the "Page" column. The * symbol indicates that XPS or Dynamic Server (or both, if both columns are so marked) support the environment variable.
The notation ERG in the Page column indicates an environment variable that must be set with the CDR_ENV configuration parameter and that is described in the appendix on configuration parameters and environment variables of the IBM Informix: Dynamic Server Enterprise Replication Guide.
The notation GLS in the Page column indicates a GLS environment variable that is valid in nondefault locales and that is described in the GLS environment variables chapter of IBM Informix: GLS User's Guide.
| Environment Variable | XPS | IDS | Restrictions | Page |
|---|---|---|---|---|
| AC_CONFIG | * | * | None | AC_CONFIG |
| AFDEBUG | JVM | AFDEBUG | ||
| ANSIOWNER | * | None | ANSIOWNER (IDS Only) | |
| BIG_FET_BUF_SIZE | * | SQL APIs and
DB-Access only |
BIG_FET_BUF_SIZE (XPS Only) | |
| CC8BITLEVEL | ESQL/C only | GLS | ||
| CDR_LOGDELTA | * | ER only | ERG | |
| CDR_PERFLOG | * | ER only | ERG | |
| CDR_ROUTER | * | ER only | ERG | |
| CDR_RMSCALEFACT | * | ER only | ERG | |
| CLIENT_LOCALE | * | * | None | GLS |
| CPFIRST | * | * | None | CPFIRST |
| DBACCNOIGN | * | * | DB-Access only | DBACCNOIGN |
| DBANSIWARN | * | * | None | DBANSIWARN |
| DBBLOBBUF | * | * | None | DBBLOBBUF |
| DBCENTURY | SQL APIs only | DBCENTURY | ||
| DBDATE | * | * | None | DBDATE; GLS |
| DBDELIMITER | * | * | None | DBDELIMITER |
| DBEDIT | * | v | None | DBEDIT |
| DBFLTMASK | * | * | DB-Access only | DBFLTMASK |
| DBLANG | * | * | None | DBLANG; GLS |
| DBMONEY | * | * | None | DBMONEY; GLS |
| DBNLS | * | DBNLS (IDS Only) | ||
| DBONPLOAD | * | HPL only | DBONPLOAD (IDS Only) | |
| DBPATH | * | * | None | DBPATH |
| DBPRINT | * | * | UNIX only | DBPRINT |
| DBREMOTECMD | * | * | UNIX only | DBREMOTECMD (UNIX Only) |
| DBSPACETEMP | * | * | None | DBSPACETEMP |
| DBTEMP | * | DB-Access, Gateways | DBTEMP (IDS Only) | |
| DBTIME | SQL APIs only | DBTIME; GLS | ||
| DBUPSPACE | * | * | None | DBUPSPACE |
| DB_LOCALE | * | * | None | GLS |
| DEFAULT_ATTACH | * | Deprecated | DEFAULT_ATTACH | |
| DELIMIDENT | * | * | None | DELIMIDENT |
| ENVIGNORE | * | * | UNIX only | ENVIGNORE (UNIX Only) |
| ESQLMF | * | * | ESQL/C only | GLS |
| FET_BUF_SIZE | * | * | SQL APIs, DB-Access only | FET_BUF_SIZE |
| GLOBAL_DETACH_INFORM | * | None | GLOBAL_DETACH_INFORM (XPS Only) | |
| GLS8BITFSYS | * | * | None | GLS |
| GL_DATE | * | * | None | GLS |
| GL_DATETIME | * | * | None | GLS |
| IBM_XPS_PARAMS | * | None | IBM_XPS_PARAMS (XPS Only) | |
| IFMX_CART_ALRM | * | None | IFMX_CART_ALRM (XPS Only) | |
| IFMX_HISTORY_SIZE | * | DB-Access | IFMX_HISTORY_SIZE (XPS Only) | |
| IFMX_OPT_FACT_TABS | * | None | IFMX_OPT_FACT_TABS (XPS Only) | |
| IFMX_OPT_NON_DIM_TABS | * | None | IFMX_OPT_NON_DIM_TABS (XPS Only) | |
| IFX_DEF_TABLE_LOCKMODE | * | None | IFX_DEF_TABLE_LOCKMODE (IDS Only) | |
| IFX_DIRECTIVES | * | * | None | IFX_DIRECTIVES |
| IFX_LONGID | * | * | None | IFX_LONGID |
| IFX_NETBUF_PVTPOOL_SIZE | * | * | UNIX only | IFX_NETBUF_PVTPOOL_SIZE (UNIX Only) |
| IFX_NETBUF_SIZE | * | * | None | IFX_PAD_VARCHAR (IDS Only) |
| IFX_PAD_VARCHAR | * | None | IFX_PAD_VARCHAR (IDS Only) | |
| IFX_UPDDESC | * | None | IFX_UPDDESC (IDS Only) | |
| IMCADMIN | * | IMCADMIN | ||
| IMCCONFIG | * | IMCCONFIG | ||
| IMCSERVER | * | IMCSERVER | ||
| INFORMIXC | ESQL/C, UNIX only | INFORMIXC (UNIX Only) | ||
| INFORMIXCONCSMCFG | * | None | INFORMIXCONCSMCFG (IDS Only) | |
| INFORMIXCONRETRY | * | * | None | INFORMIXCONRETRY |
| INFORMIXCONTIME | * | * | None | INFORMIXCONRETRY |
| INFORMIXCPPMAP | * | None | INFORMIXCPPMAP (IDS Only) | |
| INFORMIXDIR | * | * | None | INFORMIXDIR |
| INFORMIXKEYTAB | * | * | UNIX only | INFORMIXKEYTAB (UNIX Only) |
| INFORMIXOPCACHE | * | Optical Subsystem only | INFORMIXOPCACHE (IDS Only) | |
| INFORMIXSERVER | * | * | None | INFORMIXSERVER |
| INFORMIXSHMBASE | * | * | UNIX only | INFORMIXSHMBASE (UNIX Only) |
| INFORMIXSQLHOSTS | * | * | None | INFORMIXSQLHOSTS |
| INFORMIXSTACKSIZE | * | * | None | INFORMIXSTACKSIZE |
| INFORMIXTERM | * | * | DB-Access, UNIX only | INFORMIXTERM (UNIX Only) |
| INF_ROLE_SEP | * | None | INF_ROLE_SEP (IDS Only) | |
| INTERACTIVE_DESKTOP_OFF | * | Windows only | INTERACTIVE_DESKTOP_OFF (Windows Only) | |
| ISM_COMPRESSION | * | * | ISM, ON-Bar only | ISM_COMPRESSION |
| ISM_DEBUG_FILE | * | * | ISM only | ISM_DEBUG_FILE |
| ISM_DEBUG_LEVEL | * | * | ISM, ON-Bar only | ISM_DEBUG_LEVEL |
| ISM_ENCRYPTION | * | * | ISM, ON-Bar only | ISM_ENCRYPTION |
| ISM_MAXLOGSIZE | * | * | ISM only | ISM_MAXLOGSIZE |
| ISM_MAXLOGVERS | * | * | ISM only | ISM_MAXLOGVERS |
| JAR_TEMP_PATH | * | JVM | JAR_TEMP_PATH (IDS Only) | |
| JAVA_COMPILER | * | JVM | JAVA_COMPILER (IDS Only) | |
| JVM_MAX_HEAP_SIZE | * | JVM | JVM_MAX_HEAP_SIZE (IDS Only) | |
| LD_LIBRARY_PATH | SQL APIs, UNIX only | LD_LIBRARY_PATH (UNIX Only) | ||
| LIBERAL_MATCH | * | None | LIBERAL_MATCH (XPS Only) | |
| LIBPATH | SQL APIs, UNIX only | LIBPATH (UNIX Only) | ||
| NODEFDAC | * | * | None | NODEFDAC |
| ONCONFIG | * | * | None | ONCONFIG |
| OPTCOMPIND | * | * | None | OPTCOMPIND |
| OPTMSG | ESQL/C only | OPTMSG | ||
| OPTOFC | ESQL/C only | OPTOFC | ||
| OPT_GOAL | * | UNIX only | OPT_GOAL (IDS and UNIX Only) | |
| PATH | * | * | None | PATH |
| PDQPRIORITY | * | * | None | PDQPRIORITY |
| PLCONFIG | * | HPL only | PLCONFIG (IDS Only) | |
| PLOAD_LO_PATH | * | HPL only | PLOAD_LO_PATH (IDS Only) | |
| PLOAD_SHMBASE | * | HPL only | PLOAD_SHMBASE (IDS Only) | |
| PSORT_DBTEMP | * | * | None | PSORT_DBTEMP |
| PSORT_NPROCS | * | * | None | PSORT_NPROCS |
| RTREE_COST_ADJUST_VALUE | * | None | RTREE_COST_ADJUST_VALUE (IDS Only) | |
| SERVER_LOCALE | * | * | None | GLS |
| SHLIB_PATH | * | * | UNIX only | SHLIB_PATH (UNIX Only) |
| STMT_CACHE | * | None | STMT_CACHE (IDS Only) | |
| TERM | * | * | UNIX only | TERM (UNIX Only) |
| TERMCAP | * | * | UNIX only | TERMCAP (UNIX Only) |
| TERMINFO | * | * | UNIX only | TERMINFO (UNIX Only) |
| THREADLIB | ESQL/C, UNIX only | TOBIGINT (XPS Only) | ||
| TOBIGINT | * | dbschema only | TOBIGINT (XPS Only) | |
| USETABLENAME | * | None | USETABLEAME (IDS Only) | |
| XFER_CONFIG | * | None | XFER_CONFIG (XPS Only) |