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: Vill Vurr
Country: Philippines
Language: English (Spanish)
Genre: Love
Published (Last): 11 July 2009
Pages: 71
PDF File Size: 16.30 Mb
ePub File Size: 12.72 Mb
ISBN: 811-6-19132-296-3
Downloads: 38473
Price: Free* [*Free Regsitration Required]
Uploader: Taut

For Unix gasis user, use ora[sid] user. For example, you need to query data from MSEG table. Hope this tutorial work for you. Since Data Management Strategy is the key factor to boost system performance and and to keep data accessibility more efficient, we need to maintain or oraganize the data itself. You can do it on UNIX based.

In SAP Netweaver 7. Database statistic need to be update in order to accelerate database query on your program or SAP standard program.

Database Configuration and Administration Using SAP BRTOOLS – SAP Basis Administration – page

How to apply OSS notes number? Solution Run this command using root user basid update authorization needed for running brtools: Run this command using root bttools to update authorization needed for running brtools: June 9, Set the required option like new destination tablespace or set the parallel thread which will be used to perform reorganization. Actually, we can do more than that.

TOP Related Articles  INFOCUS IN3114 PDF

If you want to run check database command now, just choose Start Immedietly. This prevents some of the problems described baxis This is the important question before we plan to reorganize table in SAP system. The following graphic shows some of the reasons for reorganization: In this case, you have to type the command manually.


To check tablespace current size, just click Current Size button. On my previous tutorial, you have already learned how to create new tablespace. This is the important question before we plan to reorganize table in SAP system. If you want to add more datafile, you can specified now by typing y.

Why do we need to reorganize table in SAP system? Software Configuration o Standby Database o init. For your safety, use it on offline mode no user access SAP server. Where can I find more information? Run this command using root user to update authorization needed for running brtools: This may be due to different character set, like copying text from Ms Word to command prompt.

So, we need to managed this tablespace carefully.

On this screen, you can see information about last added tablespace including datafile size, datafile name, etc. One of activity that effect on its are table reorganization. I use default datafile size about MB.



For detailed information, you have to click Detail Log button. Happy checking your database.

DD is only used to backup large files, such as the Oracle data files. This is the command to change password of Oracle Database User: Test it first on your Develop system or Brtokls system. Software Configuration o Standby Database o init.

SAP also develop database tools to accompany you as Basis in order free you from 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.

Now you can try to reoganization simple and little table. I am glad that a lot of Basis visiting my blog, asking me about Basis activity, tips, etc. August 29, Create a free website brtools sap basis blog at WordPress. Here is the example using brspace:.

Wait until it finished. Open your command prompt. 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.