Home » 2008 » June

Monthly Archives: June 2008

Knowing your current SAP R3 SPAM Level

Some friends ask me how to get information about support package level on their current SAP R/3 server. Actually it is very simple. Just follow this next step :

Type SPAM on your SAPGUI command screen.

You this SPAM screen. SPAM program also has its level. You can see it on the top of it. My current SPAM version is 6.20 level 26.

To check other support package level, just press Package level button.

On the left side, you see support package component such as SAP_BASIS (SAP Basis Component), SAP_ABA (Cross Application Component), SAP_APPL (Logistics and Accounting), SAP_HR (Human Resources), etc.

For level package, just check level component. For example, SAP_BASIS has its level 64.

OK, that’s all you need to know about you current support package level. On the next tutorial, I’ll guide you about how to increase your support package level.

Create New Tablespace on SAP R3 server using BRTOOLS

By default, SAP R3 4.7 has 6 tablespace. You can check them using tcode  DB02. I already show you how to extend tablespace that already exist.

Now I want to show step by step adding new tablespace. I am going to use BRTOOLS, to add new tablespace. Open your MS-DOS prompt using user [sid]adm. Use ora[sid] user for your UNIX box.

To add new tablespace, choose option number 2 Space Management. Then ENTER.

Choose option number 2 to Create Tablespace. Then ENTER.

Enter option number 3 to propose tablespace name. Tablespace name must have prefix PSAPIDS (for my IDES box). Depend on your box. Here, I named it PSAPIDS_REORG (Coz I want to use it later for reorganization purpose).

After that, enter C then ENTER.

Tablespace creation is going to execute. You do not net to shutdown your SAP R3 nor Oracle DB to do this. You can do this online.

Additional information you need to supply such as datafile size, increment size, etc. Then type c to continue.

Tablespace creation is running. Wait for couple minutes.

Tablespace PSAPIDS_REORG has been created successfully. Type C to continue.

Back to Space Management menu. Next step, check the result using DB02 tcode.

You can see that tablespace PSAPIDS_REORG has been added in tablespace list.

Congratulations ! Now, you can continue your coffee break time :D…

Simple Table Reorganization for SAP R/3 using BRSPACE

SAP R/3 are ERP software that relied on database performance to support its performance. High performance database directly effect on SAP R/3 system performance. One of activity that effect on its are table reorganization. Reorganization improves the structure of the database and can result in improved database performance. BRSPACE performs the reorganization using the new Oracle feature, online table redefinition. The following graphic shows some of the reasons for reorganization:

One of the reason to reorganization are that large disk and RAID system with large and secure memory buffers reduce I/O hotspot. You can check more about reorganization for SAP R/3 here.

I’ll use my Windows box and use [sid]adm user. For Unix box user, use ora[sid] user. Let’s do simple table reorganization here. Open your MS-DOS prompt.

Type > brspace -f tbreorg -t MSEG

Explanation :

  • -f means function to do table reorganization
  • -t means refer to table  name. On this tutorial, MSEG table.


Additional option available for table reorganization. Just accept default option. Type C to continue.

Table reorganization is running.

Table reorganization has been completed succesfully. Type C to continue.

Now you can try to reoganization simple and little table. This tutorial only show you simple and online reorganization. Be carefull when you are using it. Test it first on your Develop system or Test system.

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.

Extending your SAP R/3 tablespaces

I am glad that a lot of Basis visiting my blog, asking me about Basis activity, tips, etc. Based on comments and email about how to extend SAP R/3 tablespace, I try to post this little notes. On this little tutorial, I am using Windows based SAP R/3 and Oracle 9.2. You can do it on UNIX based. Of course using different user. When you using UNIX  based R/3 system, you have to use ora[sid] user.

Login to your SAP R/3 DB instance Windows using [sid]adm user. Open your command prompt.

Type BRTOOLS to enter BRTOOLS menu.

Choose menu number 2 by typing 2 and then ENTER.

There are many menus on SPACE Management including Extend tablespace, Create tablespace, etc.

Type 1 to Extend tablespace. To get information about tablespace list, you can use DB02 on your SAPGUI screen. For this tutorial, I want to extend PSAPIDS tablespace.

Type c to continue this step.

On this screen, you can see information about last added tablespace including datafile size, datafile name, etc. I use default (datafile size about 2470 MB). Type C to continue.

If you want to add more datafile, you can specified now by typing y. Right now, I just want to add 1 datafile so I type c.

Extending tablespace process is running.

Tablespace PSAPIDS has been extended successfully. Type c to continue.

Back to BRTOOLS menus. Type 9 and ENTER to exit BRTOOLS program.

To check your new datafile has been added to your tablespace you can use DB02 and then press REFRESH button.

Now, you can extend your tablespace easily and have a nice day.

NB : You don’t need to shutdown your SAP R/3 system or Oracle DB to extend tablespace. You can do this online while your SAP R/3 system and Oracle DB running.