Use the File Options tab in the Extract Service Editor to specify options for compressing the extract file or extracted tables.
The following compression methods are available for a file:
Inline Compression requires less storage resources during the extract process when compared to post compression.
Data is extracted and written to an uncompressed file. In a second step, Optim™ reads the uncompressed file, and writes a compressed version of the file. The benefit of post compression is that database connections are closed earlier with post compression than with inline compression. However, with post compression the total elapsed time is increased because the uncompressed file must be closed, read, and then a new compressed version created.
Sites having concerns about database resource contention may find post compression useful as it shortens the time database resources are needed. However, post compression increases the elapsed time and storage requirements for processing the extract service. Although increased storage is necessary during the compression operation, that temporary storage required will be released when the compression is completed.
To specify file compression options: