We can better understand the concept of main menu mode of BR*Tools by considering an example function of BRSPACE. For suppose, If we need to extend tablespace of the underlying oracle database in SAP system, we have to follow the steps as mentioned below.

1. Start BRTOOLS from command prompt
2. BRTOOLS Main Menu will be displayed
3. Choose the menu item Space Management
4. Database space management menu will be displayed
5. Choose the menu item Extend tablespace
6. BRSPACE options for tablespace extension menu will be displayed
7. Just continue in this screen by pressing c
8. After continue, the message ‘BR0291I BRSPACE will be started with options ‘-p initSM1.sap -s 20 -l E -f tsext
   end’ will be displayed
9. Again continue by presssing c
10. Tablespace extension Main Menu will be displayed

All of the steps mentioned above are captured in the screen shots and inserted in this post below. I think you will better understand from the screen shots.

BRTOOLS Main Menu

Database Space Management

BRSPACE Options for tablespace extension

Tablespace Extension Main Menu

Following are the list of other BRSPACE options available. We can get this list by using command BRSPACE -h functions

1. dbstart – start up database
2. dbshut – shut down database
3. dbalter – alter database instance
4. dbparam – alter database parameter
5. dbcreate – recreate database
6. dbshow – show database infos (default)
7. tsextend – extend tablespace
8. tscreate – create tablespace
9. tsdrop – drop tablespace
10. tsalter – alter tablespace
11. dfalter – alter data file
12. dfmove – move data file
13. tbreorg – reorganize tables
14. idrebuild – rebuild indexes
15. tbexport – export tables
16. tbimport – import tables
17. tbalter – alter tables
18. idalter – alter indexes
19. mstats – manage statistics

This entry was posted on February 18, 2012 at 4:29 PM. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Posted in SAP Basis Notes by Raj No Comments Yet