-f check

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 table 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.