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.
|Published (Last):||17 May 2014|
|PDF File Size:||8.83 Mb|
|ePub File Size:||5.92 Mb|
|Price:||Free* [*Free Regsitration Required]|
SAP® Basis Administration Handbook, NetWeaver Edition by Ranjit Mereddy
Deleting Multiple Spool Requests Simultaneously in The more you set the thread, the faster your process will be. Solution Run this basls using root user to update authorization needed for running brtools: Usually commercial databases such Oracle, DB2, Informix is used as its database server. As of Version 7. Yes, refer to for more information.
Here is the example using brspace: In the last tutorial, I had shown you how to check your database through DB13 tcode. This may be due to different character set, like copying brtpols from Ms Word to command prompt.
Newer Post Older Post Home. Actually, we can do more than that. Refer to SAP Termination in the execution phase Return Code 5: Software Configuration o Standby Database o init.
Database Configuration and Administration Using SAP BRTOOLS – SAP Basis Administration – page
Happy checking your database. 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.
How can I find out which release and patch level belong to an installed tool? Abort Return Code 9: Tutorials What is Oracle? This is the important question before we plan to reorganize table in SAP system.
The following parameter files exist:. For example in DB13, you will have an error when you schedule job like check database and update optimizer. SAP are design its database very complex and beatiful. For detailed information, you have to click Detail Brtoools button.
SAP Basis For Beginner: SAP BR*Tools an interactive interface for Oracle database management
The following parameter files exist: Here are name of their tablespaces: Here is the example using brspace:. Standby Database Requires Recovery.
Execution with warning s Return Code 2: Database Administration — ardhian Where can I find information about Support Packages, installation and compatibility? Enter table name basix Table names table.
What is OSS Notes number? To check your Oracle database, you can go to your SAP screen. Please feel free to contact me on devratt yahoo. In this case, you must use other tools for a backup or execute a simple file system backup. Error in the execution phase Return Code 6: They will mention and warn you if something wrong with brtool backup configuration. In this case, you have to type the command manually. In SAP Netweaver 7.
In this screen, you might need to input some information about your database such brtpols your SAP Database profile, your database user and password, database owner, and something you might not want to be checked.
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. Kn in the initialization phase Return Code 3: This is the command to change password of Oracle Database User: Site Status Computers shorten url blogarama.
Therefore, CPIO must always be installed correctly to avoid errors. Send your suggestion to me on devratt yahoo. Please take note that this online reorganization will impact on system performance, therefore you need to run this when the system load is brtooos. Displaying the Technical View: Press Space Statistic button to find out tablespace size and its growth.
Improvements to handling of database statistics. Choose continue to start processing. By default, logs that are older than brgools days are deleted. Go to DB13 tcode.