Environment Variables
These topics list the environment variables that are available for affecting the set up and operation of parallel jobs.
There are many environment variables that affect the design and running of parallel jobs in InfoSphere® DataStage®. Commonly used ones are exposed in the InfoSphere DataStage Administrator client, and can be set or unset using the Administrator (see Setting environment variables for the parallel engine). There are additional environment variables, however. This topic describes all the environment variables that apply to parallel jobs. The environment variables can be set or unset as you would any other UNIX or Windows system variables to the values indicated in their descriptions. You can also add the environment variables to the User Defined section in the InfoSphere DataStage Administrator environment variable tree.
The available environment variables are grouped according to function. They are summarized in the following table.
The final section in this topic gives some guidance to setting the environment variables.
Buffering
Building Custom Stages
Compiler
Db2 Support
Debugging
- APT_DEBUG_OPERATOR
- APT_DEBUG_MODULE_NAMES
- APT_DEBUG_PARTITION
- APT_DEBUG_SIGNALS
- APT_DEBUG_STEP
- APT_DEBUG_SUBPROC
- APT_EXECUTION_MODE
- APT_NO_PM_SIGNAL_HANDLERS
- APT_PM_DBX
- APT_PM_SHOW_PIDS
- APT_PM_XTERM
- APT_PXDEBUGGER_FORCE_SEQUENTIAL
- APT_SHOW_LIBLOAD
- DS_OSH_WRAPPER_DEBUG_CONNECT
- DS_OSH_WRAPPER_TIMEOUT
- DS_PXDEBUG
Decimal Support
Disk I/O
Parallel Engine Fundamentals
- APT_CLOBBER_OUTPUT
- APT_CONNECTION_PORT_RANGE
- APT_CONFIG_FILE
- APT_DISABLE_COMBINATION
- APT_DONT_COMPRESS_BOUNDED_FIELDS
- APT_EXECUTION_MODE
- APT_FILE_EXPORT_ADD_BOM
- APT_IMPORT_FORCE_QUOTE_DELIM
- APT_ORCHHOME
- APT_STARTUP_SCRIPT
- APT_NO_STARTUP_SCRIPT
- APT_STARTUP_STATUS
- DSForceTerminate
- DSIPC_OPEN_TIMEOUT
- DSJOB_DOMAIN
- DSWaitShutdown
- DS_FORCE_ABORT_AT_WARN_LIMIT
- DS_LOG_AUTOPURGE_IGNORE_STATUS
Job Monitoring
Look Up support
Miscellaneous
- APT_AGGREGATOR_NULLABLE_OUTPUT
- APT_AUTO_TRANSPORT_BLOCK_SIZE
- APT_CHECKPOINT_NO_COMPRESSION
- APT_CHECKPOINT_TARGET_ON_HDFS
- APT_COPY_TRANSFORM_OPERATOR
- APT_DATASET_FLUSH_NOFSYNC
- APT_DATASET_FLUSH_SYNC
- APT_DATE_CENTURY_BREAK_YEAR
- APT_DATE_ADD_ROLLOVER
- APT_DISABLE_FASTALLOC
- APT_DONT_OPTIMIZE_MODIFY
- APT_DS_COMPRESSION
- APT_EBCDIC_VERSION
- APT_FILE_EXPORT_DEFAULTS_TO_CONDUCTOR
- APT_FIFO_DIRECTORY
- APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL
- APT_IMPORT_REJECT_INVALID_CHARS
- APT_IMPORT_REJECT_STRING_FIELD_OVERRUNS
- APT_INSERT_COPY_BEFORE_MODIFY
- APT_ISVALID_BACKCOMPAT
- APT_JOIN_POOL_SIZE
- APT_LOOKUP_POOL_SIZE
- APT_OLD_BOUNDED_LENGTH
- APT_OLD_CUTOFF
- APT_OUTPUT_LOCALE
- APT_OPERATOR_REGISTRY_PATH
- APT_OSL_PARAM_ESC_SQUOTE
- APT_OSL_RESTORE_BACKSLASH
- APT_PLAYERS_REPORT_IN
- APT_PM_ACCEPT_CONNECTION_RETRIES
- APT_PM_ACCEPT_CONNECTION_TIMEOUT
- APT_PM_CLEANUP_TIMEOUT
- APT_PM_NO_SHARED_MEMORY
- APT_PM_NO_NAMED_PIPES
- APT_PM_SCORE_DIR
- APT_YARN_MAX_AM_POOL_SIZE
- APT_YARN_PX_BINARY_VISIBILITY
- APT_PM_STARTUP_CONCURRENCY
- APT_RECORD_COUNTS
- APT_RESPATH
- APT_SHOW_COMPONENT_CALLS
- APT_STACK_TRACE
- APT_SURRKEY_BLOCK_WRITE
- APT_SURRKEY_LOCKSTATE_RETRIES
- APT_THREAD_SAFE_FAST_ALLOC
- APT_TRANSFORM_ABORT_ON_CONVERSION_ERROR
- APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING
- APT_TRANSFORM_LOOP_WARNING_THRESHOLD
- APT_TRANSFORM_OPERATOR_DEBUG
- APT_TSORT_HDFS_SCRATCH
- APT_TSORT_SCRATCH_COMPRESSION
- APT_USE_CRLF
- APT_VIEWDATA_TEMP_DIR
- DSAttLockWait
- DSE_SLAVE_CLOSE_SOCKET_ON_EXEC
- DSJobStartedMax
- DSODBC_EXECUTE_MULTI_STMTS_AS_ONE
- DSODBC_NEW_FVMARKERS
- DSODBC_NO_BIGINT_WARNINGS
- DSODBC_NO_DB2_DELETE_WARNINGS
- DSR_RECORD_DELETE_BEFORE_WRITERAW
- DSSocketNotifyTimeout
- DSWaitResetStartup
- DSWaitStartup
- DS_CHANGE_SEQ_PUT_BEHAVIOR
- DS_EXECUTE_NO_MASKING
- DS_HOSTNAME_ALIAS
- DS_IPCPUT_OLD_TIMEOUT_BEHAVIOR
- DS_LONG_JOBSTATUS_LOCK
- DS_MAX_PREC_FOR_FLOATS
- DS_MMAPPATH
- DS_MMAPSIZE
- DS_NO_INSTANCE_PURGING
- DS_OPTIMIZE_FILE_BROWSE
- DS_SEQ_BYPASS_CHOWN
- DS_STATUSSTARTED_CHECK
- DS_TRX_ALLOW_LINKVARIABLES
- OSH_PRELOAD_LIBS
- PX_DBCONNECTHOME
- DS_USE_OLD_STATUS_PURGE
- DS_USE_OSHSCRIPT
- DS_USE_SERVER_AUTH_ONLY
- ODBCBindingOrder
- ODBCstripCRLF
- OSHMON_INIT_RETRY
- OSHMON_TRACE
Network
- APT_DEBUG_ENVIRONMENT
- APT_PM_ENV_DEBUG
- APT_PM_ENV_NOCLOBBER
- APT_IO_MAXIMUM_OUTSTANDING
- APT_IOMGR_CONNECT_ATTEMPTS
- APT_PLAYER_CONNECTION_PORT
- APT_PM_CONDUCTOR_TIMEOUT
- APT_PM_CONDUCTOR_HOSTNAME
- APT_PM_CONNECT_USING_NAME
- APT_PM_NO_TCPIP
- APT_PM_NODE_TIMEOUT
- APT_PM_PLAYER_TIMEOUT
- APT_PM_SHOWRSH
- APT_PM_STARTUP_PORT
- APT_RECVBUFSIZE
- APT_USE_IPV4
NLS
Oracle Support
Partitioning
Reading and Writing Files
- APT_DELIMITED_READ_SIZE
- APT_FILE_IMPORT_BUFFER_SIZE
- APT_FILE_EXPORT_BUFFER_SIZE
- APT_IMPORT_FILE_PATTERN_CMD
- APT_IMPORT_HANDLE_SHORT
- APT_IMPORT_PATTERN_USES_CAT
- APT_IMPORT_PATTERN_USES_FILESET_MOUNTED
- APT_MAX_DELIMITED_READ_SIZE
- APT_RAW_DISPLAY_HEXADECIMAL
- APT_STRING_ALLPADS_NOT_EMPTY
- APT_STRING_PADCHAR
Reporting
SAS Support
- APT_HASH_TO_SASHASH
- APT_NO_SASOUT_INSERT
- APT_NO_SAS_TRANSFORMS
- APT_SAS_ACCEPT_ERROR
- APT_SAS_CHARSET
- APT_SAS_CHARSET_ABORT
- APT_SAS_COMMAND
- APT_SASINT_COMMAND
- APT_SAS_DEBUG
- APT_SAS_DEBUG_IO
- APT_SAS_DEBUG_LEVEL
- APT_SAS_DEBUG_VERBOSE
- APT_SAS_S_ARGUMENT
- APT_SAS_NO_PSDS_USTRING
- APT_SAS_SCHEMASOURCE_DUMP
- APT_SAS_SHOW_INFO
- APT_SAS_TRUNCATION