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.
0
Can be set for an individual connection. Takes effect immediately.
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.
The 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.
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 System Administration Guide: Volume 1.
