8/6/2019 sap dba

1/17

September 14, 2007

DB14 : Daily SAP Basis job log to be monitored

Filed under: Database Administration ardhian @ 10:23 am

SAP provides an excellent DBA tools (for Oracle DB) which is called BRTOOLS.

BRTOOLS is a compilation tools range from BRBACKUP (tools to maintain backupdatabase), 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, Ill show you how to monitored your database logs.

First, type DB14 on your SAPGUI screen. Youll have this screen :

To check yourBRCONNECT logs, just clickBRCONNECT button.

http://sapbasis.wordpress.com/2007/09/14/db14-daily-sap-basis-log-job-to-be-monitored/http://wordpress.com/tag/database-administration/http://www.sap.com/http://sapbasis.wordpress.com/2007/09/14/db14-daily-sap-basis-log-job-to-be-monitored/http://wordpress.com/tag/database-administration/http://www.sap.com/

8/6/2019 sap dba

2/17

Youll see some logs. The one which coloured grey is BRCONNECT job that had runwell or successfully. The other one which coloured yellow is BRCONNECT job that had

run but ended with warning. If yourBRCONNECT job hadnt run well then it will show

you red coloured log. To see whats really happened, justdouble click one of i logs.

For more detailed information, clickDetail Log button.

8/6/2019 sap dba

3/17

ForBRBACKUP job log, you can clickBRBACKUP button.

8/6/2019 sap dba

4/17

For more information about BRBACKUP activities, double click on one of its log.

To get more detailed information, click on Detail Log button.

8/6/2019 sap dba

5/17

ForBRARCHIVE log activities, click on BRARCHIVE button.

For detailed information, just double click on one of its lines and youll get this screen.

8/6/2019 sap dba

6/17

For detailed information, you have to clickDetail 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

8/6/2019 sap dba

7/17

wrong with your backup configuration. So, make sure that youll have this log check

every day to make your system has high availability and minimize your SAP production

downtime.

Comments (0)

August 29, 2007

Checking SAP R/3 Database via BRTOOLS

Filed under: Database Administration, SAP, Unix ardhian @ 10:31 am

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 databasethrough DB13 tcode. DB13 is database independent tcode to manage your database

whether youre 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 youll have this screen. For your information,

Iam using UNIX OS. It might be different when youre using Windows OS.

Choose number 6 option by typing 6 and then press ENTER.

http://sapbasis.wordpress.com/2007/09/14/db14-daily-sap-basis-log-job-to-be-monitored/#respondhttp://sapbasis.wordpress.com/2007/08/29/checking-sap-r3-database-via-brtools/http://wordpress.com/tag/database-administration/http://wordpress.com/tag/sap/http://wordpress.com/tag/unix/http://sapbasis.wordpress.com/2007/09/14/db14-daily-sap-basis-log-job-to-be-monitored/#respondhttp://sapbasis.wordpress.com/2007/08/29/checking-sap-r3-database-via-brtools/http://wordpress.com/tag/database-administration/http://wordpress.com/tag/sap/http://wordpress.com/tag/unix/

8/6/2019 sap dba

8/17

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

8/6/2019 sap dba

9/17

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 ENTERto

proceed to the next step.

8/6/2019 sap dba

10/17

Press ENTERto proceed.

Now, youll see that database check process is running. Wait until it finished.

8/6/2019 sap dba

11/17

Type S to stop and exit from BRTOOLS menu. Now you had learn how to check yourSAP R/3 database by using DB13 tcode and BRTOOLS command. In the next tutorial,

Ill 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.

Comments (5)

August 28, 2007

Checking SAP R/3 Database

Filed under: Database Administration ardhian @ 10:57 am

Most Basis jobs are related with database server. Whether youre using Microsoft SQL

server from Microsoft, Oracle Database from Oracle, DB2 Universal Database from IBMor 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 databasespecific related jobs such as rebuilding index, checking tablespace, checking whole

database, updating your database statistic, monitoring your database growth, etc.

mailto:devratt@yahoo.comhttp://sapbasis.wordpress.com/2007/08/29/checking-sap-r3-database-via-brtools/#commentshttp://sapbasis.wordpress.com/2007/08/28/checking-sap-r3-database/http://wordpress.com/tag/database-administration/http://www.microsoft.com/http://www.oracle.com/http://www.oracle.com/http://www.ibm.com/http://www.mysql.com/mailto:devratt@yahoo.comhttp://sapbasis.wordpress.com/2007/08/29/checking-sap-r3-database-via-brtools/#commentshttp://sapbasis.wordpress.com/2007/08/28/checking-sap-r3-database/http://wordpress.com/tag/database-administration/http://www.microsoft.com/http://www.oracle.com/http://www.ibm.com/http://www.mysql.com/

8/6/2019 sap dba

12/17

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.

8/6/2019 sap dba

13/17

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.

Comments (0)

August 14, 2007

Checking SAP R/3 tablespaces

Filed under: Database Administration ardhian @ 12:11 pm

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 :

mailto:devratt@yahoo.commailto:devratt@yahoo.comhttp://sapbasis.wordpress.com/2007/08/28/checking-sap-r3-database/#respondhttp://sapbasis.wordpress.com/2007/08/14/checking-sap-r3-tablespaces/http://wordpress.com/tag/database-administration/mailto:devratt@yahoo.comhttp://sapbasis.wordpress.com/2007/08/28/checking-sap-r3-database/#respondhttp://sapbasis.wordpress.com/2007/08/14/checking-sap-r3-tablespaces/http://wordpress.com/tag/database-administration/

8/6/2019 sap dba

14/17

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 usingold 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,

8/6/2019 sap dba

15/17

Press Space Statistic button to find out tablespace size and its growth. Tablespacesgrowth can be seen daily, weekly, or monthly.

To check tablespace current size, just clickCurrent Size button.

8/6/2019 sap dba

16/17

Click on PSAP[SID] tablespace and then, clickFreespace Analysis.

8/6/2019 sap dba

17/17