Scribd Logo
Upload

Welcome to Scribd!

  • 393 views

    DB02 Create Table Space

    Uploaded by

    Surya Nanda
    The document describes how to create a new tablespace called PSAPIDS_REORG on an SAP R3 server using BRTOOLS. It provides step-by-step instructions for opening BRTOOLS, choosing the option to create a tablespace, entering the tablespace name, and supplying additional configuration details. It notes that the tablespace creation will run online without needing to shutdown SAP R3 or the Oracle database. It then confirms the new tablespace was successfully created and can be seen in the tablespace list using transaction code DB02.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    DB02 Create Table Space

    Uploaded by

    Surya Nanda
    393 views15 pages
    The document describes how to create a new tablespace called PSAPIDS_REORG on an SAP R3 server using BRTOOLS. It provides step-by-step instructions for opening BRTOOLS, choosing the option to create a tablespace, entering the tablespace name, and supplying additional configuration details. It notes that the tablespace creation will run online without needing to shutdown SAP R3 or the Oracle database. It then confirms the new tablespace was successfully created and can be seen in the tablespace list using transaction code DB02.

    Original Description:

    h

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes how to create a new tablespace called PSAPIDS_REORG on an SAP R3 server using BRTOOLS. It provides step-by-step instructions for opening BRTOOLS, choosing the option to create a tablespace, entering the tablespace name, and supplying additional configuration details. It notes that the tablespace creation will run online without needing to shutdown SAP R3 or the Oracle database. It then confirms the new tablespace was successfully created and can be seen in the tablespace list using transaction code DB02.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    393 views15 pages

    DB02 Create Table Space

    Uploaded by

    Surya Nanda
    The document describes how to create a new tablespace called PSAPIDS_REORG on an SAP R3 server using BRTOOLS. It provides step-by-step instructions for opening BRTOOLS, choosing the option to create a tablespace, entering the tablespace name, and supplying additional configuration details. It notes that the tablespace creation will run online without needing to shutdown SAP R3 or the Oracle database. It then confirms the new tablespace was successfully created and can be seen in the tablespace list using transaction code DB02.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 15

    DB02

    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

    Extending your SAP R/3 tablespaces

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

    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. Tablespaces 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. Well talk about BRTOOLS later.

    You might also like