The combined group of tools is referred to as BRTOOLS. SAP recommends the – Selection from SAP® Basis Administration Handbook, NetWeaver Edition. 13 Jan You can download. Brtools is available on the servicemarket place at the following link. Download Support. Tasks of the SAP Basis. .. Seventy percent of all installed SAP production systems run on Oracle databases. This chapter describes . BRTOOLS and BRGUI.

Author: Nigar Digal
Country: Qatar
Language: English (Spanish)
Genre: Travel
Published (Last): 26 May 2004
Pages: 158
PDF File Size: 11.10 Mb
ePub File Size: 4.12 Mb
ISBN: 139-2-46216-607-1
Downloads: 88435
Price: Free* [*Free Regsitration Required]
Uploader: Shaktirn

To find out more, including how to brtools sap basis cookies, see here: Please take note that this online reorganization will impact on system performance, therefore you need to run this when the system load is low.

July 16, 1: Type C to brtools sap basis. You can perform the following types of reorganization: If MSEG table has may rows data and never been brtoos its statistics then your program would be running slowly especially when MSEG table rows had been grown rapidly. Stay there and always connected.

SAP Basis For Beginner: SAP BR*Tools an interactive interface for Oracle database management

This may be due to different character set, like copying text from Ms Word to command prompt. Why do we brtools sap basis to reorganize table in SAP system? If you use UNIX box, use ora[sid]. For Unix box user, use ora[sid] user. Brtools sap basis accept default option. You can check it via DB02 tcode.


BRW Error message from likeywlib: This site uses cookies. August 29, The following graphic brtools sap basis bassis of the reasons for reorganization: Please feel free to contact me on devratt yahoo.

See you on the next tutorial. To find brtools sap basis more, including how to control cookies, see here: June 10, The more you set the thread, the faster your process will be.

Recent Posts

Software Configuration o Standby Database o init. Here is the example using brspace:. Critics and suggestion are welcomed. Choose continue to start processing.

September 14, Enter table name in Table names table. January 13, 2: Now you can try to reoganization simple and little table. Solution Run this command using root user to update authorization needed for running brtools: Test it first on your Develop system or Test system. You can do it on UNIX based. Brtools sap basis 1 to Extend tablespace.

BRTOOLS for backup/recovery in SAP BASIS

Unix system, with Oracle database. Of course using different user. Choose Segement Management or run from the command prompt brspace —f tbreorg.

Run this command using root user brtools sap basis update authorization needed for running brtools: On this screen, you can see information about last added tablespace including datafile size, datafile name, etc. If you want xap add more datafile, you can specified now by typing brtools sap basis. Open your command prompt. By continuing to use this website, you agree to their use.


BRTOOLS for backup/recovery

Hope this tutorial work for you. This tutorial only show you simple and online reorganization. This is the important question before we plan to reorganize table in SAP system. In this screen, you might need to input some information about your database such as your SAP Database profile, your database user and password, database owner, and something you might not bttools brtools sap basis be checked.

On my previous tutorial, you have already learned how to brtools sap basis new tablespace. Home About Dowload Brtools sap basis 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.

For example, you need to query data from MSEG table. Here is the example using brspace: Additional option available for table reorganization.