SAP provides an excellent DBA tools (for Oracle DB) which is called BRTOOLS. BRTOOLS is a compilation tools range from BRBACKUP (tools to maintain backup database), BRARCHIVE (tools to maintain archive files backup), BRCONNECT (tools to maintain checking database, updating database statistics, etc), BRRESTORE (tools to maintain database restoration), and some specific and useful tool.
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 succeed, succeed with warning, or failed. We can access those log from SAP R/3 through SAPGUI.
SAP provides DB14 tcode for SAP Basis to access those database logs. Through this article, I’ll show you how to monitored your database logs.
First, type DB14 on your SAPGUI screen. You’ll have this screen :
To check your BRCONNECT logs, just click BRCONNECT button.
You’ll see some logs. The one which coloured grey is BRCONNECT job that had run well or successfully. The other one which coloured yellow is BRCONNECT job that had run but ended with warning. If your BRCONNECT job hadn’t run well then it will show you red coloured log. To see what’s really happened, justdouble click one of i logs.
For more detailed information, click Detail Log button.
For BRBACKUP job log, you can click BRBACKUP button.
For more information about BRBACKUP activities, double click on one of its log.
To get more detailed information, click on Detail Log button.
For BRARCHIVE log activities, click on BRARCHIVE button.
For detailed information, just double click on one of its lines and you’ll get this screen.
For detailed information, you have to click Detail Log button.
SAP through Going Live Check event will check this log to make sure that your SAP production system is ready to go live. They will mention and warn you if something wrong with your backup configuration. So, make sure that you’ll have this log check every day to make your system has high availability and minimize your SAP production downtime.
August 29, 2007
Checking SAP R/3 Database via BRTOOLS
BRTOOLS is a database tool developed by SAP to help SAP Basis manage his Oracle based SAP R/3 database. In the last tutorial, I had shown you how to check your database through DB13 tcode. DB13 is database independent tcode to manage your database whether you’re using MS SQL, Oracle, DB2, or SAPDB.
Here, I am going to demonstrate how to use BRTOOLS to check your Oracle 9i database. You need to logon to your SAP R/3 server using ORA[SID] user.
Type BRTOOLS on your console and then you’ll have this screen. For your information, I’am using UNIX OS. It might be different when you’re using Windows OS.
Choose number 6 option by typing 6 and then press ENTER.
To check your database choose number 1 option and then press ENTER.
In this screen, you might need to input some information 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. For this moment, I am using default properties and press ENTER.
This screen show you BRTOOLS confirmation. Just type C and then press ENTER to proceed to the next step.
Press ENTER to proceed.
Now, you’ll see that database check process is running. Wait until it finished.
Type S to stop and exit from BRTOOLS menu. Now you had learn how to check your SAP R/3 database by using DB13 tcode and BRTOOLS command. In the next tutorial, I’ll show you another tips and trick that might be useful and helpful. Stay there and always connected.
Critics and suggestion are welcomed. Please feel free to contact me on devratt@yahoo.com.
August 28, 2007
Checking SAP R/3 Database
Most Basis jobs are related with database server. Whether you’re using Microsoft SQL server from Microsoft, Oracle Database from Oracle, DB2 Universal Database from IBM or SAPDB from MySQL AB, all your job are facing with them closely.
SAP are design its database very complex and beatiful. 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.
I just going to explain about BRTOOLS for Oracle because I only have Oracle database right now. BRTOOLS has numerous tools inside it.
To check your Oracle database, you can go to your SAP screen. Go to DB13 tcode.
Double click on current date.
Choose Check Database.
If you want to run check database command now, just choose Start Immedietly. But if you wan to run it later, just schedule it on appropriate time.
Happy checking your database. Send your suggestion to me on devratt@yahoo.com.
August 14, 2007
Checking SAP R/3 tablespaces
SAP R/3 are ERP software using large database. Usually commercial databases such Oracle, DB2, Informix is used as its database server. Mine using Oracle 9.2.0.6.
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. Actually, we can do more than that.
SAP R/3 installation created 6 tablespaces by default. Here are name of their tablespaces :
- PSAPTEMP
- PSAPUNDO
- PSAP[SID]
- PSAP[SID]620
- PSAP[SID]UDR
- SYSTEM
I am using SAP R/3 Enterprises 4.7 ext 200 version. It may be different if you are using old or new ones.
SAP R/3 data is saved on PSAP[SID] tablespace. So, we need to managed this tablespace carefully.
When you type DB02,
Press Space Statistic button to find out tablespace size and its growth. Tablespace’s growth can be seen daily, weekly, or monthly.
To check tablespace current size, just click Current Size button.
Click on PSAP[SID] tablespace and then, click Freespace Analysis.
If your PSAP[SID] tablespace size is reaching 95% level, you should consider increasing its size. You can use BRTOOLS to increase tablespace size. We’ll talk about BRTOOLS later.
No comments:
Post a Comment