Use the TEMP_TAB_EXT_SIZE and TEMP_TAB_NEXT_SIZE environment options to specify the number of kilobytes used as the first and next extent size for a system-generated temporary table.
The following example shows the syntax for setting the first and next extent size using these environment options:
SET ENVIRONMENT TEMP_TAB_EXT_SIZE '64' SET ENVIRONMENT TEMP_TAB_NEXT_SIZE '128'
This example sets the first extent size of a generated temporary table to 64 and the next extent size to 128 kilobytes.
The minimum value of these options is four times the page size on your system. If you specify a size below the minimum, the server will default the page size to four pages. For flex inserts, the server will default to 32 pages or 128 kilobytes.
The maximum value for TEMP_TAB_EXT_SIZE and TEMP_TAB_NEXT_SIZE is the maximum value of a chunk size.
Use the DEFAULT keyword to reset the values of these environments options back to the system defaults.