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.

Author: Nalkree Gugami
Country: Mexico
Language: English (Spanish)
Genre: Business
Published (Last): 21 November 2015
Pages: 190
PDF File Size: 8.71 Mb
ePub File Size: 20.73 Mb
ISBN: 559-8-57550-503-7
Downloads: 64268
Price: Free* [*Free Regsitration Required]
Uploader: Kagat

To find out more, including how to control cookies, see here: Critics and suggestion are welcomed. See you on the next tutorial.


Error in the execution phase Return Code 6: In certain cases, it may be advisable to adjust the standard function for example, basiis avoid unnecessarily large NEXT sizes or to exclude certain tables from a check. By continuing to use this website, you agree to their use.

One of activity that effect on its are table reorganization. Call the tool with the ” -V” option for example, “brconnect -V brtoools. The result brools the following lines with release and patch level: I done it for this purpose. In some cases before you import a restore, for exampleit may be advisable to save the current status of the database as a precaution, even if you can no longer open the database properly in the current status.


Set the required option like new destination tablespace or set the parallel thread which will be used to perform reorganization. The final letter indicates whether the entry eap an information message Ia warning message W or an error message E.

This prevents some of the problems described in Deleting Multiple Spool Requests Simultaneously in Usually commercial databases such Oracle, DB2, Informix is used as its database server.

Brtools is available on the servicemarket place at the following link. It may be different if you are using old or new ones.

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

Now you can try to reoganization simple and little table. Reorganization improves the structure of the database and can result in improved database performance.

If MSEG table has may rows data and never been updated its statistics then your program would brtools sap basis running slowly especially when MSEG table rows had been grown rapidly. If MSEG table has may rows data and never been updated its statistics then your program would be running slowly especially when MSEG table rows had been grown rapidly. To check your Oracle database, you can go to your SAP screen.

BRTOOLS « SAP Basis Cafe

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.

Since Data Management Strategy is the key grtools to boost system performance and and to keep data accessibility more efficient, basia need to maintain or oraganize the data itself.


The more you set the thread, the faster your process will be. You can check it via DB02 tcode. Press Space Statistic button to find out tablespace size and its growth.

Recent Posts

Therefore, CPIO must always be installed correctly to avoid errors. Database statistic need to be update in order to accelerate database query on your program or SAP standard program.

For example, you need to query data from MSEG table. The following graphic shows some of the reasons for reorganization: You can perform the following types of reorganization: July 16, 1: Please take note that this brotols brtooos will impact on system performance, therefore you need to run this when the system load is low.

Termination in the initialization phase Return Code 3: How I can adjust the functions of “brconnect -f next”?

Since Data Management Strategy is basiss key factor to boost system performance brtoools and to keep data accessibility brtools sap basis efficient, we need to maintain or oraganize the data itself.

So, we need to managed this tablespace carefully.