Lookup support environment variables in DataStage®

This environment variable is concerned with lookup tables.

APT_LUTCREATE_NO_MMAP environment variable in DataStage

Set the APT_LUTCREATE_NO_MMAP environment variable to force lookup tables to be created that use malloced memory.

By default lookup table creation is done by using memory-mapped files. In some situations, depending on the OS configuration or file system, writing to memory-mapped files causes poor performance. In these situations, this variable can be set so that malloced memory is used, which can boost performance.

APT_LOOKUP_POOL_SIZE environment variable in DataStage

Set the APT_LOOKUP_POOL_SIZE environment variable to set a memory limit, in bytes, for lookup operations. This variable sets a memory cap so that only limited memory space is used for look up operations. This setting avoids memory overflow if the lookup table is bigger than the memory available. A minimum value of 1 MB is recommended and becomes the default if a value less than that is provided.

APT_NO_LOOKUP_BUFFER environment variable in DataStage

When APT_NO_LOOKUP_BUFFER is set to true, the buffering policy is disabled for the Lookup stage. This is added for backward compatibility. By default, a buffer is added to the Lookup stage input link to avoid job hanging. Its default value is False. This variable has a Boolean type.