Miscellaneous environment variables in DataStage

These environment variables do not fit into the other categories.

APT_AGGREGATOR_NULLABLE_OUTPUT environment variable in DataStage
Set the APT_AGGREGATOR_NULLABLE_OUTPUT environment variable to force the Aggregator Stage to define aggregate fields as nullable in the output schema.
APT_COPY_TRANSFORM_OPERATOR environment variable in DataStage
Set the APT_COPY_TRANSFORM_OPERATOR environment variable to distribute the shared object file of the sub-level transform operator and the shared object file of user-defined functions (not extern functions) via distribute-component in a non-NFS MPP.
APT_DATASET_FLUSH_NOFSYNC environment variable in DataStage
Set this environment variable to turn off the fsync() and sync() calls done in APT_DMDescriptorFile::flushFile().
APT_DATASET_FLUSH_SYNC environment variable in DataStage
Set this environment variable to turn on the sync() call that is done in APT_DMDescriptorFile::flushFile() when PX datasets (internal or external) are closed. This will improve file system integrity on file systems, but may reduce the performance.
APT_DATE_CENTURY_BREAK_YEAR environment variable in DataStage
The APT_DATE_CENTURY_BREAK_YEAR environment variable contains the four-digit year that marks the century that two-digit years belong to.
APT_DATE_ADD_ROLLOVER environment variable in DataStage
Set this environment variable to disable a change to year/month date calculations that was introduced in IBM® InfoSphere® Information Server, Version 9.1.
APT_DISABLE_FASTALLOC environment variable in DataStage
Set this environment variable to use the global heap allocator instead of the fast allocator.
APT_DS_COMPRESSION environment variable in DataStage
Set the APT_DS_COMPRESSION environment variable so that data is compressed when it is written to data sets on the disk. The files are not compressed by default, and when this variable is defined to any value, the compression is turned on. This setting includes the data set files on the HDFS file system. If you have old data sets that were generated with a previous version of DataStage®, and you use the orchadmin ll command on the data sets, the compression is set to false in the output of the orchadmin ll command if compression was not available in the previous version.
APT_EBCDIC_VERSION environment variable in DataStage
The APT_EBCDIC_VERSION environment variable indicates which EBCDIC character set to use for fields that are represented in the EBCDIC format.
APT_FILE_EXPORT_DEFAULTS_TO_CONDUCTOR environment variable in DataStage
Set this environment variable to disable a change to file export that was introduced in IBM InfoSphere Information Server, Version 8.0.
APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL environment variable in DataStage
Set the APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL environment variable to allow zero length null_field values with fixed-length fields.
APT_IMPORT_REJECT_INVALID_CHARS environment variable in DataStage
Set this environment variable to reject integer fields that contain any character that causes the buffer conversion to be ended prematurely.
APT_IMPORT_REJECT_STRING_FIELD_OVERRUNS environment variable in DataStage
Set the APT_IMPORT_REJECT_STRING_FIELD_OVERRUNS environment variable so that DataStage rejects any string or ustring fields read that go over their fixed size.
APT_INSERT_COPY_BEFORE_MODIFY environment variable in DataStage
Set the APT_INSERT_COPY_BEFORE_MODIFY environment variable to turn on automatic insertion of a copy operator before any modify operator.
APT_ISVALID_BACKCOMPAT environment variable in DataStage
Set this environment variable to disable a change to the isValid() function that was introduced in IBM InfoSphere Information Server, Version 8.1.
APT_JOIN_POOL_SIZE environment variable in DataStage
Set the APT_JOIN_POOL_SIZE environment variable to set the memory limit for the join operator. After the join operator hits the memory limit, the data is written to files on the scratch disk. The files are cleaned up when the join operation is complete. This parameter is not set by default. To enable it, set this environment variable. The variable needs to be set in bytes. The memory size value is used for the upper bound of memory for the join.
APT_OLD_BOUNDED_LENGTH environment variable in DataStage
Set the APT_OLD_BOUNDED_LENGTH environment variable to any value to revert the storage behavior before IBM DataStage Version 7.0.1 when using bounded length varchars.
APT_OPERATOR_REGISTRY_PATH environment variable in DataStage
Set the APT_OPERATOR_REGISTRY_PATH environment variable to locate operator .apt files, which define what operators are available and which libraries they are found in.
APT_OSL_PARAM_ESC_SQUOTE environment variable in DataStage
Set this environment variable so that naked single quotation marks that are found in nonencrypted parameter values are escaped.
APT_PLAYERS_REPORT_IN environment variable in DataStage
Set this environment variable so that each player generates a message as it starts and as it ends.
APT_PM_ACCEPT_CONNECTION_RETRIES environment variable in DataStage
Set this environment variable to specify the number of times a player connection is retried before checking to see whether the accept connection timeout has been reached.
APT_PM_ACCEPT_CONNECTION_TIMEOUT environment variable in DataStage
Set this environment variable to specify the number of seconds that a player connection can be retried before failing.
APT_PM_CLEANUP_TIMEOUT environment variable in DataStage
Set this environment variable to control the number of seconds the conductor waits for all the section leaders to respond back that they are finished with file cleanup on job shutdown. For jobs that cleanup large files on shutdown it might be useful to increase this value. The default timeout is 5 seconds.
APT_PM_NO_SHARED_MEMORY environment variable in DataStage
Set the APT_PM_NO_SHARED_MEMORY environment variable to use named pipes rather than shared memory for local connections.
APT_PM_NO_NAMED_PIPES environment variable in DataStage
Set the APT_PM_NO_NAMED_PIPES environment variable to specify that name pipes are not used for local connections.
APT_PM_SCORE_DIR environment variable in DataStage
Set this environment variable to specify the directory to be used for the temporary files that are created when the score for all nodes is saved and restored.
APT_PM_STARTUP_CONCURRENCY environment variable in DataStage
Set the APT_PM_STARTUP_CONCURRENCY environment variable to a small integer to determine the number of simultaneous section leader startups to be allowed.
APT_RECORD_COUNTS environment variable in DataStage
Set the APT_RECORD_COUNTS environment variable to cause DataStage to print, for each operator Player, the number of records consumed by getRecord() and produced by putRecord().
APT_SHOW_COMPONENT_CALLS environment variable in DataStage
Set the APT_SHOW_COMPONENT_CALLS environment variable so that DataStage displays messages at job check time as to which user overloadable functions, such as checkConfig and describeOperator, are being called.
APT_STACK_TRACE environment variable in DataStage
Set the APT_STACK_TRACE environment variable to control the number of lines printed for stack traces.
APT_SURRKEY_BLOCK_WRITE environment variable in DataStage
Set this environment variable to enable the use of a block of memory for writing the surrogate key state file. Setting this variable can improve performance for large key state files.
APT_SURRKEY_LOCKSTATE_RETRIES environment variable in DataStage
Set this environment variable to specify the number to try to lock the key state file for a surrogate key operator.
APT_THREAD_SAFE_FAST_ALLOC environment variable in DataStage
Set this environment variable to specify the threading mode for fast allocators, which are used to allocate commonly used objects such as strings.
APT_TRANSFORM_ABORT_ON_CONVERSION_ERROR environment variable in DataStage
Set this environment variable to abort the transformer operator if a runtime conversion error occurs.
APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING environment variable in DataStage
Set the APT_TRANSFORM_COMPILE_OLD_NULL_HANDLING environment variable to revert to manual handling of nulls for all jobs in the project.
APT_TRANSFORM_LOOP_WARNING_THRESHOLD environment variable in DataStage
Set the APT_TRANSFORM_LOOP_WARNING_THRESHOLD environment variable to a value to control the number of times that a loop iterates, and the size of the cache that is used to hold input rows.
APT_TRANSFORM_OPERATOR_DEBUG environment variable in DataStage
Set this environment variable so that the token tree and symbol table are printed.
APT_TSORT_SCRATCH_COMPRESSION environment variable in DataStage
Set APT_TSORT_SCRATCH_COMPRESSION if you want scratch files that are created as part of a tsort operation to be compressed when they are written to disk. This saves space on the disk. You can specify any value for this variable.
APT_USE_CRLF environment variable in DataStage
Set this environment variable to default the end of line to windows style \r\n.
OSH_PRELOAD_LIBS environment variable in DataStage
Set the OSH_PRELOAD_LIBS environment variable to specify a colon-separated list of names of libraries to be loaded before any other processing.
PX_DBCONNECTHOME environment variable in DataStage
The location where the PX Components are installed.

Parent topic: Environment variables in DataStage