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):||4 November 2018|
|PDF File Size:||2.12 Mb|
|ePub File Size:||16.59 Mb|
|Price:||Free* [*Free Regsitration Required]|
Otherwise, the appropriate menus are shown for the function you select. 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. Since Data Management Strategy is the key brtols to boost system performance and and to keep data accessibility more efficient, we need to maintain or oraganize the data itself.
BRtools and DB02 information:
This may be due to different character set, like copying text from Ms Word to command prompt. In this case, you have to type the command manually. For quick mode, you must specify at least the function and the object name. Be very careful with —c force because it forces default selection of all unspecified options, which might lead to unexpected results. You can now enter all required options and execute the function immediately.
If the command options are correct and complete, the SAP tool is executed immediately to perform a function on the database. Please take note that this online reorganization will impact on system performance, therefore you need to run this when the system load is low.
Software Configuration o Standby Database o init.
SAP® Basis Administration Handbook, NetWeaver Edition by Ranjit Mereddy
Solution Run this command using root user to update authorization needed for running brtools: Set the required option like new destination tablespace or set the parallel thread which will be used to perform reorganization. You can perform the following types of reorganization: BRW Error message from likeywlib: With these functions you should also enter an action to specify what kind of alter function you require. The field for the object name is filled with your entry.
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.
There are the following exceptions to quick mode: Choose the category and then the class that you require. You use quick mode from: One of the strategy is to reorg certain table which can impact on system performance.
How to Use BR*Tools (SAP Library – SAP Database Guide: Oracle (BC-DB-ORA-DBA))
Here is the example using brspace: This is ij command to change password of Oracle Database User: For example in DB13, you will have an error when you schedule job like check database and update optimizer. To find out more, including how to control cookies, see here: You can enter manually enter the command. The more you set the thread, the faster your process will be. By continuing to use this website, you agree to their use.
You enter the command options inn directly from the command line: Why do we need to reorganize table in SAP system?
You can force the tool to run in batch mode without any interactive component by entering the option —c force. Exceptions to quick mode There are the following exceptions to quick mode: If the list is not what you require, you can go back and make a new selection.
Show database instance information. You can also enter additional options brtoolls quick mode.
Show database object information. BRSPACE starts by displaying the function main menu for the function that you entered, which is Alter database parameter in this example. Run this command using root user to update authorization needed for running brtools: However, you might get errors if you change the command.
If you do not specify a function, the tool is called with the bttools function when you start it from the command line: There are the following reasons for this: 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.