Interactively from the BRGUI graphical interface or the BRTOOLS character interface. · Directly from the command line using the relevant BR*Tools options. SAP Database Administration Using BRTOOLS SAP provides a number of tools to administer the underlying Oracle Database. The combined group of tools is. 1) SAP delivers the “BR*Tools” to provide an interactive Oracle database administration tools 3) Different between BR*Tools and BRTOOLS.
|Published (Last):||11 January 2011|
|PDF File Size:||7.26 Mb|
|ePub File Size:||7.43 Mb|
|Price:||Free* [*Free Regsitration Required]|
You can force brtool tool to run in batch mode without any interactive component by entering the option —c force. You enter the command options required directly from the command line: This is the important question before we plan to reorganize table in SAP system. Why do we need to reorganize table in SAP system?
When you have finished executing a function and you choose back after starting BRSPACE in quick mode, the quick mode is deactivated and you can choose a new object to execute the function again. Here is the example using brspace:. Improvements to handling of database statistics.
This may be due to different character set, like copying text from Ms Word to command prompt. Enter table name in Table names table. Show database space information. The object — for example, a tablespace name if you want to extend a tablespace — varies according to the function that you choose.
Unless you know the object name, we recommend you to use main menu mode. There are the following exceptions to quick mode: Choose Segement Management or run from the command prompt brspace —f tbreorg. For more information, see: If the list is not what you require, you can go back and make a new selection. Otherwise, the appropriate brhools are shown for the function you select.
BRTOOLS (SAP Library – SAP Database Guide: Oracle (BC-DB-ORA-DBA))
The alternative to quick mode is main menu modein which you only use the menus in BRSPACE to enter the options required to perform a function.
You can enter manually enter the command. Run this command using root user to update authorization needed for running brtools: The field for the object name is filled with your entry. You can also enter additional options in quick mode. Show database instance information. In this case, you have to type the command manually.
If the command brtoolss are correct and complete, the SAP tool is executed immediately to perform a function on the database. With these functions you should also enter an action to specify what kind of alter function you require.
BRtools and DB02 information:
Choose the category and then the class that you require. Unix system, with Oracle database. Set the required option like new destination tablespace nrtools set the parallel thread which will be used to perform reorganization. However, you might get errors if you change the command. In SAP Netweaver 7. The exception to this is for the functions in segment management, where it makes no sense to display all tables or indexes, because the list would be too long.
SAP Basis For Beginner: SAP BR*Tools an interactive interface for Oracle database management
All other confirmation prompts and so on are skipped. The more you set the thread, the faster your process will be. For example in DB13, you will have an error when you schedule job like check database and update optimizer. Choose continue to start processing.
One of the strategy is to reorg certain table which can impact on system performance. Software Configuration o Standby Database o init. Be very careful with —c force because it forces default selection of all unspecified options, which might lead to unexpected results. Reorganizing table can also be used to improve database structure, transform dictionary managed to locally managed tablespace, merge data in tablespace from many small files into larger files and perform segments defragmentation.
Show database instance information Show database space information Show database object information Choose the category and then the class that you require.
Solution Run this command using root user to update authorization needed for running brtools: You use quick mode from: For quick mode, you must specify at least the function and the object name.