You can perform additional functions for your Oracle database with BR*Tools.
BRTOOLS normally calls the SAP tool BRCONNECT. You can also perform these functions directly by calling BRCONNECT from the command line.
We recommend you to normally use BRTOOLS rather than BRCONNECT. This is because the BRTOOLS menus simplify entry of the correct parameters.
Make sure that you have set the necessary parameters for BRCONNECT in the Initialization Profile init<DBSID>.sap.
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
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
If required, you change the default values for the function parameters in the initialization profile init<DBSID>.sap and restart BRTOOLS.
If required, you choose 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.
to set the defaults used to the values in the initialization profileYou start processing.
You check the results in the BRCONNECT logs.