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):||15 February 2010|
|PDF File Size:||9.33 Mb|
|ePub File Size:||2.43 Mb|
|Price:||Free* [*Free Regsitration Required]|
With these functions you should also enter an action saap specify what kind of alter function you require. Exceptions to quick mode There are the following exceptions to quick mode: You can perform the following types of reorganization: The following graphic illustrates in outline how quick mode works: You can enter manually enter the command.
For more information, see: Choose the category and then the class that you require.
Show database instance information. The more you set the thread, the faster your process will be. Show database instance information Show database space information Show database object information Choose the category and then the class that you require.
Show database space information.
SAP® Basis Administration Handbook, NetWeaver Edition by Ranjit Mereddy
brtoools The object — for example, a tablespace name if you want to extend a tablespace — varies according to the function that you choose. Be very careful with —c force because it forces default selection of all unspecified options, which might lead to unexpected results. Here is the example using brspace:. 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 brtoools the data itself. Otherwise, the appropriate menus are shown for the function you select.
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. You use quick mode from: The alternative bdtools quick mode un main menu modein which you only use the menus in BRSPACE to enter the options required to perform a function. Choose Segement Management or run from the command prompt brspace —f tbreorg. There are the following reasons for this: BRW Error message from likeywlib: By continuing to use this website, you agree to brtiols use.
You can also enter additional options in quick mode. One of the strategy is to reorg certain table which can impact on system performance. Here is the example using brspace: Solution Run this command using root user to update authorization needed nrtools running brtools: This is the command to change password of Oracle Database User: 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.
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.
The field for the object name is filled with your entry. Choose continue i start processing. Why do we need to reorganize table in SAP system? Show database object information.
Set the required option like new destination tablespace or set the parallel thread which will be used to perform reorganization. Please take note that this online reorganization will impact on system performance, therefore you need to run this when the system load is low.
BRTOOLS (SAP Library – SAP Database Guide: Oracle (BC-DB-ORA-DBA))
Software Configuration o Standby Database o init. You can force the tool to run in batch mode without any interactive component by entering the option —c force. If the command options are correct and complete, the SAP tool is executed immediately to perform a function on the database.
In this case, you have to type the command manually. All other confirmation prompts and so on are skipped.
However, you might get errors if you change the btrools. Improvements to handling of database statistics. If the list is not what you require, you can go back and make a new selection.
BRtools and DB02 information:
Run this command using root user to update authorization needed for running brtools: This is the important question before we plan sqp reorganize table in SAP system. You can now enter all required options and execute the function immediately. Unless you know the object name, we recommend you to use main menu mode.
This may be due to different character set, like copying text from Ms Word to command prompt. There are the following exceptions to quick mode: In SAP Netweaver 7. This will make you unable to run some commands from SAP. For quick mode, you must specify at least the function and the object name. Enter table name in Table names table. For example in DB13, you will have an error when you schedule job like check database and update optimizer.