Show TOC

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

This BRCONNECT function checks the database system. For more information, see Database System Check.

Function options:

  • -d|-default: uses internal BRCONNECT default settings to check the database system

    Input syntax: -d|-default

    Default value: uses settings from the control table DBCHECKORA

  • -e|-exclude: defines tables and indexes to be excluded from the check

    Input syntax:

    -e|-exclude [<owner>.]<table>|[<owner>.]<index>|

    [<owner>.][<prefix>]*[<suffix>]|<tablespace>|

    <object_list>|non_sap|all_part|null

    non_sap means that non-SAP objects (for example, Oracle dictionary objects) are excluded from the check.

    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 check_exclude parameter. This means that no tables are excluded from processing.

    Default value: no exclusion

    You can use this option to exclude tables or indexes with exceptional space parameters or statistics handling.

    This option overrides the check_exclude parameter.

  • -i|-ignore: specifies that BRCONNECT ignores the settings in the control table DBCHECKORA. Instead, it uses the check conditions from the check_cond parameter of the initialization profile init<DBSID>.sap or the standard check conditions.

    Default value: none

  • -n|-igndbs: specifies that BRCONNECT ignores the settings in the control table DBSTATC. Instead, it uses the check conditions from the stats_special parameter of the initialization profile init<DBSID>.sap or the standard check conditions.

  • -o|-owner: defines the database owner of tables and indexes to be checked

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

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

    This option overrides the check_owner parameter.