Show TOC

Syntax documentation-f next Locate this document in the navigation structure

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

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>]*[<suffix>]|<tablespace>|<object_list>

    |all_part|null

    Default value: 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 value: both

    The next extent size is not normally reduced, but only rounded down to the next multiple of five 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 (MAX_EXTENTS)

    Input syntax: -l|-limit <count>

    Default value: 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 value: 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 value: 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>]*[<suffix>]:<size>[/<limit>]|

    <special_list>|[all_sel:]<size>[/<limit>]|null

    Default value: 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 ( )

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

    • all_sel: sets NEXT_EXTENT and MAX_EXTENTS 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>]*[<suffix>]|<tablespace>|<object_list>

    Default value: 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.

    Note Note

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

    End of the note.