Show TOC

Function documentationAdditional Functions with BR*Tools Locate this document in the navigation structure

 

You can perform additional functions for your Oracle database with . BR*Tools.

Integration

  • BRTOOLS normally calls the SAP tool BRCONNECT. You can also perform these functions directly by calling BRCONNECT from the command line.

    Recommendation Recommendation

    We recommend you to normally use BRTOOLS rather than BRCONNECT. This is because the BRTOOLS menus simplify entry of the correct parameters.

    End of the recommendation.

  • Make sure that you have set the necessary parameters for BRCONNECT in the Initialization Profile init<DBSID>.sap.

Features

You can perform the following additional functions with BR*Tools:

  • Show profiles and logs

  • Clean up DBA logs and tables

  • Adapt NEXT extents

  • Change password of database user

  • Create or change synonyms for DBA tables

Activities

  1. You choose the required function in BRTOOLS and check the displayed parameters, changing them as required.

    The default parameter values, which are set in the initialization profile init<DBSID>.sap, are as follows:

    • Clean up DBA logs that are older than 30 days

    • Clean up records in DBA tables that are older than 100 days

    • Adapt NEXT extents for all tables and indexes

  2. If required, you change the default values for the function parameters in the initialization profile init<DBSID>.sap and restart BRTOOLS.

  3. If required, you choose   Additional functions   Reset program status   to set the defaults used to the values in the initialization profile init<DBSID>.sap. For certain input values, there is no corresponding parameter in the initialization profile, in which case the default value from the BRTOOLS program is used.

  4. You start processing.

  5. You check the results in the BRCONNECT logs.