Adapt Next Extents with BRCONNECT
You can use BRCONNECT to adapt the next extents size. The aim is to avoid the structure of tablespaces deteriorating – that is, breaking up into a large number of small extents – because this reduces database performance.
Caution
This function is only relevant for dictionary-managed tablespaces. Do not use it if all tablespaces are locally managed.
Prerequisites
The database tables and indexes are assigned to one of a number of categories. The standard size of the next extent for each category is defined in the tables TGORA
(for tables) and IGORA
(for indexes).
Activities
When a table requires adapting, the size of the next extent is determined using an algorithm. This also makes sure that the value of MAX_EXTENTS
for a table or index is not less than the value defined in the TGORA
or IGORA
table.
You can exclude specified tables or indexes from this function by using the next_exclude
parameter.
You can specify individual values for NEXT_EXTENT
or MAX_EXTENTS
using the next_special
parameter.
For more information on the command line options for adapting the next extents, see -f next.