TEMP_EXTRACT_SIZEn options

Function

Specifies the maximum sizes of the corresponding output files used by the data extraction facility. There are eight options: TEMP_EXTRACT_SIZE1 through TEMP_EXTRACT_SIZE8.

Default

0

Scope

Can be set for an individual connection. Takes effect immediately.

Description

TEMP_EXTRACT_SIZE1 through TEMP_EXTRACT_SIZE8 are used to specify the maximum sizes of the corresponding output files used by the data extraction facility. TEMP_EXTRACT_SIZE1 specifies the maximum size of the output file specified by TEMP_EXTRACT_NAME1, TEMP_EXTRACT_SIZE2 specifies the maximum size of the output file specified by TEMP_EXTRACT_NAME2, and so on.

NoteThe default for the data extraction size options is 0. Sybase IQ converts this default to the values shown in the following table.

Device type

Size

Disk file

AIX and HP-UX: 0 – 64GB

Sun Solaris & Linux: 0 – 512GB

Windows: 0 – 128GB

Tape*

524288KB (0.5GB)

Other

9007199254740992KB (8192 Petabytes “unlimited”)

*Tape devices currently are not supported.

When large file systems, such as JFS2, support file size larger than the default value, set TEMP_EXTRACT_SIZEn to the value that the file system allows. For example, to support lTB set option:

TEMP_EXTRACT_SIZE1 = 1073741824 KB

If you are extracting to a single disk file or a single named pipe, leave the options TEMP_EXTRACT_NAME2 through TEMP_EXTRACT_NAME8 and TEMP_EXTRACT_SIZE1 through TEMP_EXTRACT_SIZE8 at their default values.

The TEMP_EXTRACT_SIZEn options are not compatible with TEMP_EXTRACT_APPEND. If you try to restrict the size of the extract append output file, Sybase IQ reports an error.

See also

For details on the data extraction facility and using the extraction options, see “Data extraction options” in Chapter 7, “Moving Data In and Out of Databases” in the Sybase IQ System Administration Guide.

“TEMP_EXTRACT_NAMEn options”.