Use
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.We strongly recommend you to use this BRCONNECT function rather than the equivalent SAPDBA one,
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
MAXEXTENTS 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
NEXTEXTENTS or MAXEXTENTS using the next_special parameter.For more information on the command line options for adapting the next extents, see
-f next.
See also:
Internal Rules for Determining Next Extent Size