TBLTBLNEXT configuration parameter
The TBLTBLNEXT configuration parameter specifies the next extent size of tblspace tblspace in the root dbspace. Set this parameter if you do not want the database server to automatically manage the extent size.
- onconfig.std value
- TBLTBLNEXT 0
- values
- From equivalent of 4 pages specified in kilobytes to the maximum chunk size minus three pages
- units
- Kilobytes
- takes effect
- After you edit your onconfig file and restart the database server.
Usage
If there is not enough space for a next extent in the primary chunk, the extent is allocated from another chunk. If the specified space is not available, the closest available space is allocated.