The combined group of tools is referred to as BRTOOLS. SAP recommends the – Selection from SAP® Basis Administration Handbook, NetWeaver Edition. 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: Kagara Bajin
Country: Portugal
Language: English (Spanish)
Genre: Automotive
Published (Last): 13 June 2013
Pages: 334
PDF File Size: 20.57 Mb
ePub File Size: 12.42 Mb
ISBN: 198-5-46658-352-6
Downloads: 95303
Price: Free* [*Free Regsitration Required]
Uploader: Morisar

We strongly recommend that you only use Version 6. Set the required option like new destination tablespace or set the parallel thread which will eap used to perform reorganization. In this case, you must use other tools for a backup or execute a simple file system backup.

For detailed information, you have to click Detail Log button. Refer to SAP In certain cases, it may be advisable to adjust the standard function for example, to avoid unnecessarily large NEXT sizes or to exclude certain tables from a check.


SAP also develop database tools to accompany you as Basis in order free you saap complicated and frustated database specific related jobs such as rebuilding index, checking tablespace, checking whole database, updating your database statistic, monitoring your database growth, etc. Execution with warning s Return Code 2: Usually commercial databases such Oracle, DB2, Informix is used as its database server.

Deleting Multiple Spool Requests Simultaneously in Displaying the Technical View: Unix system, with Oracle database. To check your Oracle database, you can go to your SAP screen. Termination in the execution phase Return Code 5: Therefore, CPIO must always be installed correctly to avoid errors. 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.


This is the important question before we plan to reorganize table in SAP system. Send your suggestion to me on devratt yahoo.

Recent Posts

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.

Site Status Computers shorten url blogarama.

This prevents some of the problems described in SAP tcode DB02 is use to check database size, tablespaces size, current statistic, checking freespace statistic, analyze detailed tablespace, checking missing indexes, and space critical objects. Solution Run this command using root user to update authorization needed for running brtools: Abort Return Code 9: The following parameter files exist: It may be different if you are using old or new ones.

In the case of MDM, see Newer Post Older Post Home. This may be due to different character set, like copying text from Ms Word to command prompt.

BR*TOOLS and SAP DBA in Oracle

If you want to run check database command now, just choose Start Immedietly. Most Basis jobs are related btrools database server. For example in DB13, you will have an error when you schedule job like check database and update optimizer. By default, logs that are older than 30 days are deleted.


Choose Segement Management or run from the command prompt brspace —f tbreorg. Successful execution Return Code 1: Enter table name in Table names table. So, we need to managed this tablespace carefully.

Happy checking your database. Here are ln of their tablespaces: Please feel free to contact me on devratt yahoo. Please take grtools that this online reorganization will impact on system performance, therefore you need to run this when the system load is low.

In the last tutorial, I had shown you how to check your database through DB13 tcode. Yes, refer to for more information. How to apply OSS notes number?

You can perform the following types of reorganization: Why do we need to reorganize table in SAP system? Error in the execution phase Return Code 6: Double click on current date.

Getting Started with BR*Tools

Go to DB13 tcode. Critics and suggestion are welcomed. Database Administration — ardhian Press Space Statistic button to find out tablespace size and its growth. Maintaining Collection and Reorganization Schemata Call the tool with the ” -V” option for example, “brconnect -V “.

Tutorials What is Oracle?

This site uses cookies. How can I find out which release and patch level belong to an installed tool?