Skip navigation


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.

Sama Ekstendnya :

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.

June 9, 2008 Posted by ardhian | Database Administration, SAP | , , , , , , , | 5 Comments

source : http://sapbasis.wordpress.com/2007/08/14/checking-sap-r3-tablespaces/#comments

Advertisements

Leave Your Text

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: