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.

Author: Ararg Kazile
Country: Puerto Rico
Language: English (Spanish)
Genre: Health and Food
Published (Last): 4 May 2009
Pages: 373
PDF File Size: 1.98 Mb
ePub File Size: 13.2 Mb
ISBN: 127-1-95969-922-8
Downloads: 67523
Price: Free* [*Free Regsitration Required]
Uploader: Shakajar

The alternative to quick mode is main menu modein which you only sal the menus in BRSPACE to enter the options required to perform a function. The field for the object name is filled with your entry. Here is the example using brspace: The more you set the thread, the faster your process will be.

BRtools and DB02 information:

You can perform the following types of reorganization: The object — for example, a tablespace name if you want to inn a tablespace — varies according to the function that you choose. One of the strategy is to reorg certain table which can impact on system performance.

With these functions you should also enter an action to specify what kind of alter function you require. Enter table name in Table names table. 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.

This is the important question before we plan to reorganize table in SAP system. There are the following reasons for this: Choose continue to start processing.


You can now enter all required options and execute the function immediately. Be very careful with —c force because it forces default selection of all brtoolss options, which might lead to unexpected results. However, you might get errors if you change the command. This may be due to different character set, like copying text from Ms Word to command prompt.

BRTOOLS (SAP Library – SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Show database instance information Show database space information Show database object information Choose the category and then the class that you require. The following graphic illustrates in outline how quick mode works: You can force the tool to run in batch mode without any interactive component by entering the option —c force. Since Data Management Strategy is the key factor to boost system performance and and to keep data accessibility more efficient, we need to maintain or oraganize the data itself.

In this case, you have to type the command manually. Choose the category and then the class that you require.

To find out more, including how to control cookies, see here: This site uses cookies. Solution Run this command using root user to update authorization needed for running brtools: Exceptions to quick mode There are the following exceptions to quick mode: Unix system, with Oracle database.

Recent Posts

If the list is not what you require, you can go back and make a new selection. For more information, see: You use quick mode from: You can enter manually enter the command.

Run this command using root user to update authorization needed for running brtools: For example in DB13, you will have an error when you schedule job like check database and update optimizer. Set the required option like new destination tablespace or set the parallel thread which will be used to perform reorganization.


They jump directly to the final input menu to rbtools you enter the remaining required parameters and execute the function immediately. If you do not specify a function, the tool is called with the default function when you start it from the command line: If the command options are correct and complete, the SAP tool is executed immediately to perform a function on the database.

Software Configuration o Standby Database o init.

SAP® Basis Administration Handbook, NetWeaver Edition by Ranjit Mereddy

For quick mode, iin must specify at least the function and the object name. BRW Error message from likeywlib: In SAP Netweaver 7. 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. If you do not enter the class of the information to be displayed, you see a menu displaying the different categories of information class: This will make you brrtools to run some commands from SAP.

Here is the example using brspace:.