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.
|
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.
Option can be set at the database (PUBLIC) or user level. When set at the database level, the value becomes the default for any new user, but has no impact on existing users. When set at the user level, overrides the PUBLIC value for that user only. No system privilege is required to set option for self. System privilege is required to set at database level or at user level for any user other than self.
Requires the SET ANY PUBLIC OPTION system privilege to set this option. Can be set temporary for an individual connection or for the PUBLIC role. 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.
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, SAP Sybase IQ reports an error.