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.

First Intro to SAP

SAP is known as world largest business software company with its product such as SAP R/3, SAP NetWeaver, SAP Business Intelligent Warehouse, SAP Solution Manager, SAP Advanced Planner and Oprimizer, etc.

SAP was founded by five former IBM employees in Mannheim, Germany. SAP was stand for Systeme, Anwendungen und Produkte in der Datenverarbeitung (“Systems, Applications and Products in Data Processing”). Currently, SAP headquarters is on Walldorf, Germany.

SAP’s products focus on Enterprise Resource Planning (ERP) with its main product SAP ERP.

SAP R/3 implementation usually held by consutant company certified by SAP. SAP customers are spread widely all over the world. Some of Indonesian’s company that implement SAP solution are Astra, Indofood, Blue Bird, Sari Husada, etc.

First post on SAP Basis Cafe

Hi

This is my first post to SAP Basis Cafe. I also welcome to all SAP Basis-ers to contribute some stuff including dumb articles especially on SAP Basis field.

The main purpose of this weblog is to provide some information and articles about SAP R/3, SAPGUI, Basis to all Basis level from newbie till expert one.

For contributing articles and SAP Basis stuff, feel free to register and contact me.