Home » Posts tagged 'BRCONNECT'

Tag Archives: BRCONNECT

Update Database Statistics using BRTOOLS and BRCONNECT

On this tutorial, you’ll see how to update your database statistic. Database statistic need to be update in order to accelerate database query on your program or SAP standard program. For example, you need to query data from MSEG table. If MSEG table has may rows data and never been updated its statistics then your program would be running slowly especially when MSEG table rows had been grown rapidly.

To update database statistic, you could use BRCONNECT or BRTOOLS. Actually, BRCONNECT is part of BRTOOLS. I’ll explain how to use both of them. I use my Windows box and use [sid]adm. If you use UNIX box, use ora[sid].

First, let’s try to use BRCONNECT to update MSEG table. Open your MSDOS prompt.

Type command : > brconnect -u / -c -f stats -t MSEG

Explanation :

  • – u means using user root (/)
  • – c means force without using password
  • – f means using function statistics. Another option is checks.
  • – t means which table is going to update its statistics. Another option is ALL for all tables.

Now, we are going to look at BRTOOLS to do this task. BRTOOLS are menu based program. Open your MS-DOS prompt. Type BRTOOLS.

Type 7 to choose Database Statistics. Press ENTER.

Type 1 to update database statistics. Press ENTER.

To update MSEG table choose 9 to enter MSEG table name and then press ENTER.

Type C to continue to next step, running update database statistic process.

You’ll see summary of what you are going to do. Type C to continue.

Last confirmation before running update database statistics. Type C to continue.

BRTOOLS update database statistics has been completed successfully. Type C to continue and back to update database statistic menu.

Type B to go back to BRTOOLS main menu.

Type 9 and then ENTER to exit from BRTOOLS menu.

That’s all for now. Now you know how to update your database statistic. Hope this tutorial work for you. See you on the next tutorial.

DB14 : Daily SAP Basis job log to be monitored

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.

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.