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):||20 March 2018|
|PDF File Size:||13.37 Mb|
|ePub File Size:||17.17 Mb|
|Price:||Free* [*Free Regsitration Required]|
Go to DB13 tcode. Database statistic need to be update in order to accelerate database query on your program or SAP standard program. Open your command prompt. Maintaining Collection and Reorganization Schemata The final letter indicates whether the entry represents an information message Ia warning message W or an error message E. 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.
BRTOOLS « SAP Basis Cafe
Displaying the Technical View: Improvements to handling of brtools sap basis statistics. Software Configuration o Standby Database o init. You can perform the following types of reorganization: Stay there and always connected.
Additional option available for table reorganization. To check your Oracle database, you can go to your SAP screen. Why do we need bryools reorganize table in SAP system?
Set the required option like new destination tablespace or set the parallel thread which will be used to perform reorganization.
Brtools is available on the servicemarket place at the following link. Critics and suggestion are welcomed.
You can perform the following types of reorganization: Press Space Statistic button to find out tablespace size and its brtooos. January 13, 2: Please feel free to contact me on devratt yahoo. One of activity that effect on its are table reorganization.
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 brtolos. This tutorial only show you simple and online reorganization. Just accept default option.
BR*TOOLS and SAP DBA
August 29, Tutorials What is Oracle? As of Version 7. By continuing to use this website, you agree to their use. DD is only used to backup large files, such as the Oracle data files. For your safety, use it on offline mode no user access SAP server. Execution with warning s Return Code 2: SAP tcode DB02 is use to check database size, tablespaces size, current statistic, checking freespace statistic, analyze detailed tablespace, checking missing nasis, and space critical objects.
It may be different if you are using old or new ones.
For example in DB13, you will have an error when you schedule job like check database and update optimizer. For Unix box user, use ora[sid] user. Now you know how to update your database statistic.
In this screen, you might need to input some zap about your database such as your SAP Database profile, your database user and password, database owner, and something you might not want to be checked. Where can I find information about Support Packages, installation and compatibility?
Double click on current date. Most Basis jobs are related with database server. They will mention and warn you if something wrong with your basid configuration. Database Administration — ardhian Run this command using root user to update authorization needed for running brtools: Yes, refer to for more information.
Since Data Management Strategy is basiss key factor to boost system performance and and to keep data accessibility brtools sap basis efficient, we need to maintain or oraganize the data itself.