Table 12 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 | X | X | ON-Bar | AC_CONFIG |
| AFDEBUG | JVM | AFDEBUG | ||
| ANSIOWNER | X | None | ANSIOWNER (IDS) | |
| BIG_FET_BUF_SIZE | X | SQL APIs and
DB-Access only |
BIG_FET_BUF_SIZE (XPS) | |
| CC8BITLEVEL | ESQL/C only | GLS | ||
| CDRSITES_731 | X | ER only | ERG | |
| CDRSITES_92X | X | ER only | ERG | |
| CDR_LOGDELTA | X | ER only | ERG | |
| CDR_PERFLOG | X | ER only | ERG | |
| CDR_ROUTER | X | ER only | ERG | |
| CDR_RMSCALEFACT | X | ER only | ERG | |
| CLIENT_LOCALE | X | X | None | GLS |
| CPFIRST | X | X | ESQL/C only | CPFIRST |
| DBACCNOIGN | X | X | DB-Access only | DBACCNOIGN |
| DBANSIWARN | X | X | None | DBANSIWARN |
| DBBLOBBUF | X | X | UNLOAD only | DBBLOBBUF |
| DBCENTURY | SQL APIs only | DBCENTURY | ||
| DBDATE | X | X | None | DBDATE; GLS |
| DBDELIMITER | X | X | None | DBDELIMITER |
| DBEDIT | X | X | None | DBEDIT |
| DBFLTMASK | X | X | DB-Access only | DBFLTMASK |
| DBLANG | X | X | None | DBLANG; GLS |
| DBMONEY | X | X | None | DBMONEY; GLS |
| DBNLS | X | DBNLS (IDS) | ||
| DBONPLOAD | X | HPL only | DBONPLOAD (IDS) | |
| DBPATH | X | X | None | DBPATH |
| DBPRINT | X | X | UNIX only | DBPRINT |
| DBREMOTECMD | X | X | UNIX only | DBREMOTECMD (UNIX) |
| DBSPACETEMP | X | X | None | DBSPACETEMP |
| DBTEMP | X | DB-Access, Gateways | DBTEMP (IDS) | |
| DBTIME | SQL APIs only | DBTIME; GLS | ||
| DBUPSPACE | X | X | None | DBUPSPACE |
| DB_LOCALE | X | X | None | GLS |
| DEFAULT_ATTACH | X | Deprecated | DEFAULT_ATTACH | |
| DELIMIDENT | X | X | None | DELIMIDENT |
| ENVIGNORE | X | X | UNIX only | ENVIGNORE (UNIX) |
| ESQLMF | X | X | ESQL/C only | GLS |
| FET_BUF_SIZE | X | X | SQL APIs, DB-Access only | FET_BUF_SIZE |
| GLOBAL_DETACH_INFORM | X | None | GLOBAL_DETACH_INFORM (XPS) | |
| GLS8BITFSYS | X | X | None | GLS |
| GL_DATE | X | X | None | GLS |
| GL_DATETIME | X | X | None | GLS |
| IBM_XPS_PARAMS | X | None | IBM_XPS_PARAMS (XPS) | |
| IFMX_CART_ALRM | X | None | IFMX_CART_ALRM (XPS) | |
| IFMX_HISTORY_SIZE | X | DB-Access | IFMX_HISTORY_SIZE (XPS) | |
| IFMX_OPT_FACT_TABS | X | None | IFMX_OPT_FACT_TABS (XPS) | |
| IFMX_OPT_NON_DIM_TABS | X | None | IFMX_OPT_NON_DIM_TABS (XPS) | |
| IFX_DEF_TABLE_LOCKMODE | X | None | IFX_DEF_TABLE_LOCKMODE (IDS) | |
| IFX_DIRECTIVES | X | X | None | IFX_DIRECTIVES |
| IFX_EXTDIRECTIVES | X | X | Set on the client only | IFX_DIRECTIVES |
| IFX_LONGID | X | X | None | IFX_LONGID |
| IFX_NETBUF_PVTPOOL_SIZE | X | X | UNIX only | IFX_NETBUF_PVTPOOL_SIZE (UNIX) |
| IFX_NETBUF_SIZE | X | X | None | IFX_PAD_VARCHAR (IDS) |
| IFX_NO_TIMELIMIT_WARNING | X | X | None | IFX_NO_TIMELIMIT_WARNING |
| IFX_PAD_VARCHAR | X | None | IFX_PAD_VARCHAR (IDS) | |
| IFX_UPDDESC | X | None | IFX_UPDDESC (IDS) | |
| IFX_XASTDCOMPLIANCE_XAEND | X | None | IFX_XASTDCOMPLIANCE_XAEND | |
| IMCADMIN | X | IMCADMIN | ||
| IMCCONFIG | X | IMCCONFIG | ||
| IMCSERVER | X | IMCSERVER | ||
| INFORMIXC | ESQL/C, UNIX only | INFORMIXC (UNIX) | ||
| INFORMIXCONCSMCFG | X | None | INFORMIXCONCSMCFG (IDS) | |
| INFORMIXCONRETRY | X | X | None | INFORMIXCONRETRY |
| INFORMIXCONTIME | X | X | None | INFORMIXCONRETRY |
| INFORMIXCPPMAP | X | None | INFORMIXCPPMAP (IDS) | |
| INFORMIXDIR | X | X | None | INFORMIXDIR |
| INFORMIXKEYTAB | X | X | UNIX only | INFORMIXKEYTAB (UNIX) |
| INFORMIXOPCACHE | X | Optical Subsystem only | INFORMIXOPCACHE (IDS) | |
| INFORMIXSERVER | X | X | None | INFORMIXSERVER |
| INFORMIXSHMBASE | X | X | UNIX only | INFORMIXSHMBASE (UNIX) |
| INFORMIXSQLHOSTS | X | X | None | INFORMIXSQLHOSTS |
| INFORMIXSTACKSIZE | X | X | None | INFORMIXSTACKSIZE |
| INFORMIXTERM | X | X | DB-Access, UNIX only | INFORMIXTERM (UNIX) |
| INF_ROLE_SEP | X | None | INF_ROLE_SEP (IDS) | |
| INTERACTIVE_DESKTOP_OFF | X | Windows only | INTERACTIVE_DESKTOP_OFF (Windows) | |
| ISM_COMPRESSION | X | X | ISM, ON–Bar only | ISM_COMPRESSION |
| ISM_DEBUG_FILE | X | X | ISM only | ISM_DEBUG_FILE |
| ISM_DEBUG_LEVEL | X | X | ISM, ON–Bar only | ISM_DEBUG_LEVEL |
| ISM_ENCRYPTION | X | X | ISM, ON–Bar only | ISM_ENCRYPTION |
| ISM_MAXLOGSIZE | X | X | ISM only | ISM_MAXLOGSIZE |
| ISM_MAXLOGVERS | X | X | ISM only | ISM_MAXLOGVERS |
| JAR_TEMP_PATH | X | JVM | JAR_TEMP_PATH (IDS) | |
| JAVA_COMPILER | X | JVM | JAVA_COMPILER (IDS) | |
| JVM_MAX_HEAP_SIZE | X | JVM | JVM_MAX_HEAP_SIZE (IDS) | |
| LD_LIBRARY_PATH | SQL APIs, UNIX only | LD_LIBRARY_PATH (UNIX) | ||
| LIBERAL_MATCH | X | None | LIBERAL_MATCH (XPS) | |
| LIBPATH | SQL APIs, UNIX only | LIBPATH (UNIX) | ||
| NODEFDAC | X | X | None | NODEFDAC |
| ONCONFIG | X | X | None | ONCONFIG |
| OPTCOMPIND | X | X | None | OPTCOMPIND |
| OPTMSG | ESQL/C only | OPTMSG | ||
| OPTOFC | ESQL/C only | OPTOFC | ||
| OPT_GOAL | X | UNIX only | OPT_GOAL (IDS, UNIX) | |
| PATH | X | X | None | PATH |
| PDQPRIORITY | X | X | None | PDQPRIORITY |
| PLCONFIG | X | HPL only | PLCONFIG (IDS) | |
| PLOAD_LO_PATH | X | HPL only | PLOAD_LO_PATH (IDS) | |
| PLOAD_SHMBASE | X | HPL only | PLOAD_SHMBASE (IDS) | |
| PSORT_DBTEMP | X | X | None | PSORT_DBTEMP |
| PSORT_NPROCS | X | X | None | PSORT_NPROCS |
| RTREE_COST_ADJUST_VALUE | X | None | RTREE_COST_ADJUST_VALUE (IDS) | |
| SERVER_LOCALE | X | X | None | GLS |
| SHLIB_PATH | X | X | UNIX only | SHLIB_PATH (UNIX) |
| STMT_CACHE | X | None | STMT_CACHE (IDS) | |
| TERM | X | X | UNIX only | TERM (UNIX) |
| TERMCAP | X | X | UNIX only | TERMCAP (UNIX) |
| TERMINFO | X | X | UNIX only | TERMINFO (UNIX) |
| THREADLIB | ESQL/C, UNIX only | TOBIGINT (XPS) | ||
| TOBIGINT | X | dbschema only | TOBIGINT (XPS) | |
| USETABLENAME | X | None | USETABLEAME (IDS) | |
| XFER_CONFIG | X | None | XFER_CONFIG (XPS) |