Environment variable portal
This portal is an index of usage categories for HCL OneDB™ and UNIX™ environment variables. The portal contains links to the topics that describe the environment variables.
Because the following table contains a comprehensive list of categories with links to applicable topics. Some environment variables are applicable for more than one category.
| Functional category | Environment variable |
|---|---|
| Abbreviated year values | Specify how to expand literal DATE and DATETIME values: DBCENTURY environment variable |
| ANSI/ISO SQL compliance | Set the case of owner names: ANSIOWNER environment variable Specify if you want to check for HCL OneDB extensions to ANSI-standard SQL syntax: DBANSIWARN environment variable No default table or routine access privileges for PUBLIC in databases not created WITH LOG MODE ANSI: NODEFDAC environment variable |
| archecker utility | Specify the full path name for the archecker configuration file: AC_CONFIG file environment variable |
| Buffers | Manage the fetch buffer size: FET_BUF_SIZE environment variable Manage the network size: IFX_NETBUF_SIZE environment variable Manage the network pool size: IFX_NETBUF_PVTPOOL_SIZE environment variable (UNIX) Manage the BYTE or TEXT data buffer: DBBLOBBUF environment variable |
| Cache | Control the use of the shared-statement cache on a session: STMT_CACHE environment variable Set information for the Optical Subsystem: IONEDB_ OPCACHE environment variable |
| Client/server | Specify the default database server: ONEDB_SERVER environment variable Specify where shared-memory segments are attached to the client process: ONEDB_ SHMBASE environment variable (UNIX) Specify the stack size for a client process: ONEDB_ STACKSIZE environment variable Specify locale information, including for the client and server: GLS-related environment variables |
| Code-set conversion | Specify locale and multibyte information: GLS-related
environment variables Specify the location of the concsm.cfg file: ONEDB_ CONCSMCFG environment variable Specify the filename or pathname of the C compiler: ONEDB_C environment variable (UNIX) Specify the pathname of the map file for C++ programs: ONEDB_ CPPMAP environment variable Specify information for compiling multithreaded applications: THREADLIB environment variable (UNIX) |
| Configuration | Specify the name of the active that holds configuration
parameters: ONCONFIG environment variable Ignore specified environment variable settings: ENVIGNORE environment variable (UNIX) Specify the default database server: ONEDB_SERVER environment variable Specify the dbspaces in which temporary tables are built: DBSPACETEMP environment variable Manage query optimizer directives: IFX_DIRECTIVES environment variable and IFX_EXTDIRECTIVES environment variable Modify the value of the OPTCOMPIND configuration parameter: OPTCOMPIND environment variable Specify the query performance goal for the optimizer: OPT_GOAL environment variable (UNIX) Specify the degree of parallelism that the database server uses: PDQPRIORITY environment variable Specify the stack size that is applied to all client processes: ONEDB_ STACKSIZE environment variable |
| Connecting | Set
the maximum number of additional connection attempts: CONNECT_RETRIES environment variable Set connect time information: CONNECT_TIMEOUT environment variable Specify the default database server to for connections: ONEDB_SERVER environment variable Specify the location of connection information: ONEDB_ SQLHOSTS environment variable |
| Connection Manager | Specify the location of the Connection Manager configuration file:CMCONFIG environment variable |
| Data distributions | Manage the amount of system disk space that the UPDATE STATISTICS statement can use: DBUPSPACE environment variable |
| Database locale | Manage locale information: GLS-related environment variables |
| Database server | Specify servers for connections: ONEDB_SERVER environment variable Set the locale for file I/O: GLS-related environment variables Specify the name of the active file that holds configuration parameters: ONCONFIG environment variable Manage parallel sorting: PSORT_DBTEMP environment variable and PSORT_NPROCS environment variable Manage parallelism: PDQPRIORITY environment variable Manage role separation: INF_ROLE_SEP environment variable Manage shared memory: ONEDB_ SHMBASE environment variable (UNIX) Manage stack size: ONEDB_ STACKSIZE environment variable Manage temporary tables: DBSPACETEMP environment variable, DBTEMP environment variable, and PSORT_DBTEMP environment variable Manage variable-length packets: IFX_PAD_VARCHAR environment variable |
| Date and time values, formats | Manage date and time information: DBCENTURY environment variable, DBDATE environment variable, DBTIME environment variable, GLS-related environment variables (GL_DATE and GL_DATETIME), The USE_DTENV environment variable, and TZ environment variable |
| DB-Access utility | Manage the database server and DB-Access: DBANSIWARN environment variable, DBDELIMITER environment variable, DBEDIT environment variable. DBFLTMASK environment variable, DBPATH environment variable, FET_BUF_SIZE environment variable, ONEDB_SERVER environment variable, ONEDB_ TERM environment variable (UNIX), TERM environment variable (UNIX), TERMCAP environment variable (UNIX), and TERMINFO environment variable (UNIX) |
| dbexport utility | Set the field delimiter: DBDELIMITER environment variable |
| dbinfo | Specify if dbinfo('dbspace', partnum) raises error -727 or returns NULL for an invalid partnum: DBINFO_DBSPACE_RETURN_NULL_FOR_INVALID_PARTNUM environment variable |
| Delimited identifiers | Set the field delimiter used with the dbexport utility and with the LOAD and UNLOAD statements: DBDELIMITER environment variable |
| Disk space | Manage the amount of system disk space and memory that the UPDATE STATISTICS MEDIUM or HIGH statement can use: DBUPSPACE environment variable |
| Editor | Specify the text editor to use with SQL statements and command files in DB-Access: DBEDIT environment variable |
| Enterprise Replication | Specify information for Enterprise Replication: Enterprise Replication configuration parameter and environment variable reference |
| ESQL/C | Specify ANSI compliance: DBANSIWARN environment variable Specify the filename or pathname of the C compiler to use with ESQL/C: ONEDB_C environment variable (UNIX) Set delimited identifiers: DELIMIDENT environment variable Specify multibyte characters and locale information GLS-related environment variables (CLIENT_LOCALE, ESQLMF, and GL_USER) Specify information for multithreaded applications: THREADLIB environment variable (UNIX) Specify the default compilation order: CPFIRST environment variable |
| Executable programs | Specify the directories to search for executable programs: PATH environment variable |
| Fetch buffer size | Set buffer size information: FET_BUF_SIZE environment variable |
| Filenames: multibyte | GLS-related environment variables (GLS8BITFSYS) |
| Files: field delimiter | Set the field delimiter: DBDELIMITER environment variable |
| Files: installation | Specify the directory that contains the subdirectories in which your product files are installed: ONEDB_HOME environment variable |
| Files: locale | Specify locale information: GLS-related environment variables (CLIENT_LOCALE, DB_LOCALE, and SERVER_LOCALE) |
| Files: map for C++ | Specify the pathname of the map file for C++ programs: ONEDB_ CPPMAP environment variable |
| Files: message | Specify the subdirectory of $ONEDB_HOME or the pathname of the directory that contains the compiled message files that the database server uses: DBLANG environment variable |
| Files: temporary | DBSPACETEMP environment variable |
| Files: temporary | Specify a directory for temporary files: DBTEMP environment variable |
| Files: temporary sorting | Specify the location of temporary files used for sorting: PSORT_DBTEMP environment variable |
| Files: termcap, terminfo | Specify terminal information: ONEDB_ TERM environment variable (UNIX), TERM environment variable (UNIX), TERMCAP environment variable (UNIX), and TERMINFO environment variable (UNIX) |
| Format: date and time | Define the format for date and time information: DBCENTURY environment variable, DBDATE environment variable, DBTIME environment variable, GLS-related environment variables (GL_DATE and GL_DATETIME), The USE_DTENV environment variable, and TZ environment variable |
| Format: private-use characters | Set the display width for characters in Unicode Private-Use Area (PUA) ranges: GLS-related environment variables (IFX_PUA_DISPLAY_MAPPING) |
| Format: money | Define the format for money information: DBMONEY environment variableand GLS-related environment variables |
| High-availability clusters | Specify information for high-availability clustersIFX_SMX_TIMEOUT environment variable and IFX_SMX_TIMEOUT_RETRY environment variable |
| High-Performance Loader | Specify information for the High-Performance Loader: DBONPLOAD environment variable, , PLOAD_LO_PATH environment variable. and PLOAD_SHMBASE environment variable |
| Identifiers | Specify field delimiters: DELIMIDENT environment variable Specify information for identifiers longer than 18 bytes: IFX_LONGID environment variable Specify information for multibyte characters: GLS-related environment variables (CLIENT_LOCALE and ESQLMF) |
| HCL® OneDB Storage Manager | Manage ISM: ISM_COMPRESSION environment variable, ISM_DEBUG_LEVEL environment variable, ISM_ENCRYPTION environment variable, ISM_MAXLOGSIZE environment variable, ISM_MAXLOGVERS environment variable |
| Installation | Specify the directory that contains the subdirectories
in which your product files are installed: ONEDB_HOME environment variable Specify which directories to search for executable programs: PATH environment variable |
| JDBC | Manage environment variables used with JDBC: HCL OneDB environment variables with the HCL OneDB JDBC Driver |
| Language environment | Specify language and locale information: DBLANG environment variable and GLS-related environment variables |
| Libraries | Specify paths for libraries: LD_LIBRARY_PATH environment variable (UNIX), LIBPATH environment variable (UNIX), and SHLIB_PATH environment variable (UNIX) |
| Locale | Define client, server, and database locale information: GLS-related environment variables (CLIENT_LOCALE, DB_LOCALE, and SERVER_LOCALE) |
| Lock mode | Set the default lock mode for database tables that are created without specifying the LOCKMODE PAGE or LOCKMODE ROW keywords: IFX_DEF_TABLE_LOCKMODE environment variable |
| Long Identifiers | Specify information for identifiers longer than 18 bytes: IFX_LONGID environment variable |
| Map file for C++ | Specify the pathname of the map file for C++ programs: ONEDB_ CPPMAP environment variable |
| Message chaining | Enable or disable optimized message transfers (message chaining) for : OPTMSG environment variable |
| Message files | Specify the directory that contains compiled message files: DBLANG environment variable |
| Money format | Define the format for money information: DBMONEY environment variableand GLS-related environment variables |
| Multibyte characters | Specify information for multibyte characters: GLS-related environment variables (CLIENT_LOCALE, DB_LOCALE, SERVER_LOCALE, and GL_USEGLU) |
| Multibyte filter | Specify HCL OneDB ESQL/C multibyte filter information: GLS-related environment variables (ESQLMF) |
| Multithreaded applications | Specify information for compiling multithreaded applications: THREADLIB environment variable (UNIX) |
| Network | Specify network information: DBPATH environment variable |
| Nondefault locale | Define client, server, and database locale information: GLS-related environment variables (CLIENT_LOCALE, DB_LOCALE, and SERVER_LOCALE) |
| ON-Bar utility | Optimize the
deduplication capabilities for storage managers: IFX_BAR_USE_DEDUP
environment variable Disable the ability to replicate, import, or export backup objects among TSM servers: IFX_TSM_OBJINFO_OFF environment variable Specify information for ON-Bar to use with HCL OneDB Storage Manager : ISM_COMPRESSION environment variable, ISM_DEBUG_LEVEL environment variable, and ISM_ENCRYPTION environment variable |
| ONCONFIG parameters | Specify the name of the file that holds configuration parameters: ONCONFIG environment variable |
| oninit output (Windows™ only) | Specify a path and file for oninit output: ONINIT_STDOUT environment variable (Windows) |
| Optical Subsystem | Specify the size of the memory cache: IONEDB_ OPCACHE environment variable |
| Optimization: directives | Manage query optimizer directives: IFX_DIRECTIVES environment variable and IFX_EXTDIRECTIVES environment variable |
| Optimization: message transfers | Enable or disable optimized message transfers (message chaining) for : OPTMSG environment variable |
| Optimization: join method | Modify the value of the OPTCOMPIND configuration parameter: OPTCOMPIND environment variable |
| Optimization: performance goal | Specify the query performance goal for the optimizer: OPT_GOAL environment variable (UNIX) |
| OPTOFC feature | Enable optimize-OPEN-FETCH-CLOSE functionality: OPTOFC environment variable |
| PAM authentication for MongoDB clients | Enable PAM authentication for MongoDB clients: IFMXMONGOAUTH environment variable |
| Path name: archecker configuration file | Specify the full path name for the archecker configuration file: AC_CONFIG file environment variable |
| Path name: C compiler | Specify the filename or pathname of the C compiler: ONEDB_C environment variable (UNIX) |
| Path name: database files | Specify database server file and path information: DBPATH environment variable |
| Path name: executable programs | Specify directories to search for executable programs: PATH environment variable |
| Path name: HPL smart-large-object handles | Specify the pathname for smart-large-object handles: PLOAD_LO_PATH environment variable |
| Path name: installation | Specify the directory that contains the subdirectories in which your product files are installed: ONEDB_HOME environment variable |
| Path name: libraries | Specify paths for libraries: LD_LIBRARY_PATH environment variable (UNIX), LIBPATH environment variable (UNIX), and SHLIB_PATH environment variable (UNIX) |
| Path name: message files | Specify the directory that contains compiled message files: DBLANG environment variable and GLS-related environment variables |
| Path name: parallel sorting | Specify the location of temporary files for sorts: PSORT_DBTEMP environment variable |
| HCL OneDB Primary Storage Manager | Manage the storage manager: PSM_ACT_LOG environment variable. PSM_CATALOG_PATH environment variable, PSM_DBS_POOL environment variable, PSM_DEBUG environment variable, PSM_DEBUG_LOG environment variable, and PSM_LOG_POOL environment variable |
| Preserve owner name case | Set the case of owner names: ANSIOWNER environment variable |
| Printing | Specify the default printing program: DBPRINT environment variable |
| Privileges | Configure role separation: INF_ROLE_SEP environment variable |
| Query: optimization | Manage query optimizer directives: IFX_DIRECTIVES environment variable and IFX_EXTDIRECTIVES environment variable Modify the value of the OPTCOMPIND configuration parameter: OPTCOMPIND environment variable Specify the query performance goal for the optimizer: OPT_GOAL environment variable (UNIX) Specify user-defined data types can use to estimate the cost of an R-tree index for queries on UDT columnsRTREE_COST_ADJUST_VALUE environment variable |
| Query: prioritization | Specify the degree of parallelism that the database server uses: PDQPRIORITY environment variable |
| Remote shell | Specify information that overrides the default remote shell for performing remote tape operations: DBREMOTECMD environment variable (UNIX) |
| Role separation | Configure role separation: INF_ROLE_SEP environment variable |
| Rolled-back transactions | Manage what the DB-Access utility does when an
error occurs: DBACCNOIGN environment variable Specify whether an internal rollback of a global transaction frees the transaction: IFX_XASTDCOMPLIANCE_XAEND environment variable |
| Server locale | Define the locale of your database server: GLS-related environment variables SERVER_LOCALE |
| Shared memory | Specify where shared-memory segments are attached
to the client process: ONEDB_ SHMBASE environment variable (UNIX) Specify the shared-memory address for High Performance Loader (HPL) processes:PLOAD_SHMBASE environment variable |
| Shell: remote | Specify information that overrides the default remote shell for performing remote tape operations: DBREMOTECMD environment variable (UNIX) |
| Shell: search path | Specify which directories to search for executable programs: PATH environment variable |
| Sorting | Specify the location of temporary files for sorts: PSORT_DBTEMP environment variable Allocate more threads for sorting: PSORT_NPROCS environment variable |
| SQL statements | Specify information for caching: STMT_CACHE environment variable Specify connection information: CONNECT_RETRIES environment variable, CONNECT_TIMEOUT environment variable, and ONEDB_SERVER environment variable Specify information for CREATE TEMP TABLE operations: DBSPACETEMP environment variable Specify information for DESCRIBE FOR UPDATE operations: IFX_UPDDESC environment variable Specify information for LOAD and UNLOAD operations: DBDELIMITER environment variable and DBBLOBBUF environment variable Specify information for SELECT INTO TEMP operations: DBSPACETEMP environment variable Specify information for SET PDQPRIORITY operations: PDQPRIORITY environment variable Specify information for SET STMT_CACHE operations Specify information for UPDATE STATISTICS operations: DBUPSPACE environment variable |
| Stack size | Define the stack size that is applied to client processes: ONEDB_ STACKSIZE environment variable |
| Temporary tables | Define information for temporary tables: DBSPACETEMP environment variable, DBTEMP environment variable, and PSORT_DBTEMP environment variable |
| Terminal handling | Specify terminal information: ONEDB_ TERM environment variable (UNIX), TERM environment variable (UNIX), TERMCAP environment variable (UNIX), and TERMINFO environment variable (UNIX) |
| Time-limited software license | Set information for trial or evaluation software warning messages: IFX_NO_TIMELIMIT_WARNING environment variable |
| Variables: overriding | Deactivate some specified environment variable settings: ENVIGNORE environment variable (UNIX) |
| Virtual memory segments on large pages | Specify whether the database server can use large pages on platforms where the hardware and the operating system support large pages of shared memory: IFX_LARGE_PAGES environment variable |
| Year values (abbreviated) | Specify how to expand DATE and DATETIME values that are entered as abbreviated year values: DBCENTURY environment variable |