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.
|Genre:||Health and Food|
|Published (Last):||3 May 2016|
|PDF File Size:||15.2 Mb|
|ePub File Size:||1.66 Mb|
|Price:||Free* [*Free Regsitration Required]|
Enter table name in Table names table. However, you might get errors if you change the command. Unix system, with Oracle database.
BRtools and DB02 information:
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. You can force the tool to run in batch mode without any interactive component by entering the option —c force.
Here is the example using brspace: You can enter manually enter the command. Exceptions to quick mode There are the following exceptions to quick mode: The following brtlols illustrates in outline how quick mode works: This is the important question before we plan to reorganize table in SAP system.
Show database instance information Show database space information Show database object information Choose the category and then bdtools class that you require.
One of the strategy is to reorg certain table which can impact on system performance. Improvements to handling of database statistics. You use quick mode from: Choose continue to start processing.
BRTOOLS | MY SAP BASIS
You can now enter all required options and execute the function immediately. BRW Error message from likeywlib: Hrtools are the following bdtools to quick mode: Be very careful with —c force because it forces default selection of all unspecified options, which might lead to unexpected results. If you do not specify a function, the tool is called with the default function when you start it from the command line: For example in DB13, you will have an error when you schedule job like check database and update optimizer.
If bryools command options are correct and complete, the SAP tool is executed immediately to perform a function on the database. This may be due to different character set, like copying text from Ms Word to command prompt. Run this command using root user to update authorization needed for running brtools: Show database instance information. 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.
Show database object information. Why do we need to reorganize table in SAP system?
If the list is not what you require, you can go back and make a new selection. Unless you know the object name, we recommend you to use main menu mode.
Solution Run this command using root user to update authorization needed for running brtools: Brhools starts by displaying the function main menu for the function that you entered, which is Alter database parameter in this example.
SAP Basis For Beginner: SAP BR*Tools an interactive interface for Oracle database management
You can also enter additional inn in quick mode. In SAP Netweaver 7. You can perform the following types of reorganization: If you do not enter the class of the information to be displayed, you see a menu displaying the different categories of information class: 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 brtoops new object to execute the function again.
Sqp these functions you should also enter an action to specify what kind of alter function you require. To find out more, including how to control cookies, see here: You enter the command options required directly from the command line: Choose the category and then the class that you require.
They jump directly to the final input menu to let you enter the remaining required parameters and execute the function immediately.