Purpose
To specify the disk space to be used by Connect ETL for temporary work files.
Format
/WORKSPACE directory_name
| directory_name |
The pathname of a directory where Connect ETL can create temporary work files. This is needed when aggregating, joining or sorting a large number of records when the memory available to Connect ETL may not be sufficient to hold all the records. |
Location
The option may appear anywhere in the task definition.
Defaults
See the topic Work space in the Connect help for the default directories used when no /WORKSPACE option is present.
Notes
For the majority of tasks, the amount of work space needed is either zero (if the data will fit in memory) or approximately the same as the amount of input data.
In cases where special processing is performed, the amount of work space required varies. For more information on estimating the amount of work space needed, see the topic Work space in the Connect help.
Only one work area can be specified per /WORKSPACE option.
You must have read, write, and delete access for the work area.
Example
/workspace /usr/workspace /workspace /prod/tmpThese options specify that the directories /usr/workspace and /prod/tmp are to be used by Connect ETL for temporary work files.