Published by on November 22, 2021
Categories: Music

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: Zugami Goltir
Country: Philippines
Language: English (Spanish)
Genre: Literature
Published (Last): 2 January 2005
Pages: 155
PDF File Size: 19.39 Mb
ePub File Size: 19.96 Mb
ISBN: 615-5-14570-495-2
Downloads: 60311
Price: Free* [*Free Regsitration Required]
Uploader: Tuzilkree

However, you might get errors if you change the command. With these functions you should also enter an action to specify what kind of alter function you require. BRW Error message from likeywlib: You can perform the following types of reorganization: Show database space information.

BRtools and DB02 information:

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 the command options are correct and complete, the SAP tool is executed immediately to perform a function on the database. If you do not enter the class of the information to be displayed, you see a menu displaying the different categories of information class: You can enter manually enter the command.


Unix system, with Oracle database. Exceptions to quick mode There are the following exceptions to quick mode: 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. One of the strategy is to reorg certain table which can impact on system performance.

The more you set the thread, the faster your process will be. In SAP Netweaver 7. Here is the example using brspace: The field for the object name is filled with your entry.

Recent Posts

For example in DB13, you will have an error when you schedule job like check database and update optimizer. You use quick mode from: Unless you know the object name, we recommend you to use main menu mode.

vrtools Run this command using root user to update authorization needed for running brtools: Why do we need to reorganize table in SAP system? To find out more, including how to control cookies, see here: If the list is not what you require, you can go back and make a new selection.

Be very careful with —c force because it forces default selection of all unspecified options, which might lead to unexpected results. This may be due to different character set, like copying text from Ms Word to command prompt.


Otherwise, the appropriate menus are shown for the function you select. BRSPACE starts by rbtools the function main menu for the function that you entered, which is Alter database parameter in this example. There are the following exceptions to quick mode: There are the following reasons for this: Improvements to handling of database statistics.

BRtools and DB02 information:

Enter table name in Table names table. They jump directly to the brtolos input menu to let you enter the remaining required parameters and execute the function immediately. By continuing to use this website, you agree to their use. 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.