21 Aug 1) SAP delivers the “BR*Tools” to provide an interactive Oracle database administration tools 3) Different between BR*Tools and BRTOOLS. 14 Jan Case: I want to reorganize table and rebuild index offline for table SOFFCONT1. Table SOFFCONT1 contains SAP Business. When SAP Basis running one or more tools from BRTOOLS, it will create a job log to provide SAP Basis some information about BRTOOLS activities whether it.
|Published (Last):||6 May 2008|
|PDF File Size:||6.12 Mb|
|ePub File Size:||2.34 Mb|
|Price:||Free* [*Free Regsitration Required]|
For example, you need to query data from MSEG table. To check tablespace current size, just click Current Size button. To find out more, including how to control cookies, see here: Now you can try to reoganization simple and little table.
I use my Windows box and use [sid]adm. Various administration tasks see such as creation of statistics see or database checks BRGUI: The following graphic shows some of the reasons for reorganization: This is the important question before we plan to reorganize table in SAP system.
Press Space Statistic button to find out tablespace size and its growth. How I can adjust the functions of “brconnect -f next”? If you cannot find a solution in the SAP s, you should check whether a current patch for the tool still returns the same error.
Database Configuration and Administration Using SAP BRTOOLS – SAP Basis Administration – page
You can start reorganize othe table. Usually commercial databases such Oracle, DB2, Informix is used as its database server.
By continuing to use this website, you agree to their use. 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: Improvements to handling of brtools sap basis statistics.
BRTOOLS SAP BASIS EBOOK
How to Earn Rs. Open your command prompt.
Why do we need to reorganize table in SAP system? August 29, Create a free website brtools sap basis blog at WordPress. January 13, 2: Error in the initialization phase Return Code 4: Standby Database Requires Recovery.
If you want to add more datafile, you can specified now by typing y. Newer Post Older Post Home. If you use UNIX box, use ora[sid]. This will make you unable to run some commands from SAP. Happy checking your database. One of the strategy is to reorg certain table which can impact on system performance. Where can I find information about Support Packages, installation and compatibility?
Choose Segement Management or run from the command prompt brspace —f tbreorg. Hope this tutorial work for you.
Send your suggestion to me on devratt yahoo. Solution Run this command using root user to update authorization needed for running brtools: They will mention and warn you if something wrong with your backup configuration.
Seventy percent of all installed SAP production systems run on Oracle databases.