-f next

This BRCONNECT function adapts the next extents of database tables. For more information, see:

·        Adapt Next Extents

·        Algorithm for Determining Next Extent Size

Function options:

·        -e|-exclude: Defines tables and indexes to be excluded from adapting next extents

Input syntax:-e|-exclude [<owner>.]<table>|[<owner>.]<index>|[<owner>.]<prefix>*|
<tablespace>|<object_list>|all_part|null

Default: No exclusion, process all selected objects

all_part means that SAP partitions (such as in Business Information Warehouse and Advanced Planner and Optimizer) are excluded from the check.

null invalidates the exclusion list defined by the next_exclude parameter. This means that no tables or indexes are excluded from processing.

You can use this option to exclude from processing tables or indexes with exceptional space parameters. This option overrides the next_exclude parameter.

·        -f|-force: Forces the next extent size of all selected tables and indexes to be reduced to the maximum free extent size in the tablespace or to the maximum next extent size (next_max_size parameter) if required.

Input syntax:-f|-force free|max|both|nocasc

Default: both

The next extent size is not normally reduced, but only rounded down to the next multiple of 5 times the database block size.

Ў        free: reduces the next extent size to the maximum free extent size in the tablespace

Ў        max: reduces the next extent size to the value of parameter next_max_size

Ў        both: reduces the next extent size to the smaller of the values free and max

Ў        nocasc: With this option, you can prevent the check and, if necessary, the adjustment of NEXT extents from being implicitly performed for all indexes for the selected tables. This option is only provided for exceptional situations.

·        -l|-limit: Defines the maximum number of next extents (MAXEXTENTS)

Input syntax: -l|-limit <count>

Default: Settings from tables TGORA and IGORA

0 means unlimited number of extents

This option overrides the next_limit_count parameter.

·        -m|-max: Defines the maximum size for next extents, which must not be exceeded when a next extent is adapted

Input syntax: -m|-max <size>

Default: 2 GB - 5 * <database block size>

0 means unlimited next extent size

You can specify this option in KB, MB, or GB. This option overrides the next_max_size parameter.

·        -o|-owner: Defines the database owner of tables and indexes to be processed

Input syntax: -o|-owner <owner1>[,<owner2>,...]

Default: SAPR3/SAP<SID> in a standard database or all SAP owners in a multi-schema database.

This option overrides the next_owner parameter.

·        -s|-special: Defines special sizes of next extent and maximum number of next extents for exceptional tables and indexes

Input syntax: -s|-special [<owner>.]<table>:<size>[/<limit>]|[<owner>.]
<index>:<size>[/<limit>]|[<owner>.]<prefix>*:<size>[/<limit>]|
<special_list>|[all_sel:]<size>[/<limit>]|null

Default: Derived from internal rules for determining next extent size

This option overrides the next_special parameter.

Ў        <size>: size of next extent for specified table or index (NEXTEXTENT)

Ў        <limit>: maximum number of next extents for specified table or index (MAXEXTENTS)

Ў        all_sel: sets NEXTEXTENT and MAXEXTENTS attributes to a certain value for all the database objects selected using the -t function option or the next_table parameter (see below).This option is provided for exceptional situations. This is the default when the table or index name is not specified.

Ў        null invalidates the special list defined by the next_special parameter. It means that no tables or indexes are to be processed in a special way.

·        -t|-table: Defines the database objects (that is, tables, indexes, or tablespaces) to be processed

Input syntax: -t|-table all|all_ind|special|[<owner>.]<table>|
[<owner>.]<index>|[<owner>.]<prefix>*|<tablespace>|<object_list>

Default: All objects of selected owners

Ў        all: All SAP tables and indexes

Ў        all_ind: All SAP indexes

Ў        special: Only tables and indexes defined in the next_special parameter

This option overrides the next_table parameter.

To specify all SAP tables with indexes enter –t all –f nocase.