Quick Mode for BRSPACE

You can use quick mode to skip the higher-level menus in BRSPACE, including the menu to select the object of your chosen function.

You use quick mode from:

• BRGUI or BRTOOLS menus with the title BRSPACE options for

• The command line at operating system level

For quick mode, you must specify at least the function, the object name, and/or the action. The object – for example, a tablespace name if you want to extend a tablespace – varies according to the function that you choose. You can also enter additional options in quick mode.

Note

The alternative to quick mode is main menu mode, in which you only use the menus in BRSPACE to enter the options required to perform a function. Unless you know the object name, we recommend you to use main menu mode.

End of the note.

In quick mode, BRSPACE skips the menus in which you normally specify the function, the action, and/or the object name. They jump directly to the final input menu to let you enter the remaining required parameters and execute the function immediately.

The following graphic illustrates in outline how quick mode works:

Exceptions to quick mode

There are the following exceptions to quick mode:

• Function dbshow to show database information.

  If you do not enter the class of the information to be displayed, you see a menu displaying the different categories of information class:

  Show database instance information

  Show database space information

  Show database object information

  Choose the category and then the class that you require.

  BRSPACE displays the requested information.

• Alter functions:

  • dbalter to alter the database instance

  • dbparam to alter database parameters

  • tsalter to alter tablespaces

  • dfalter to alter data files

  • tbalter to alter tables

  • idalter to alter indexes

  With these functions, you should also enter an action to specify what kind of alter function you require. If you do not enter an action in quick mode, BRSPACE prompts you to select an action before you can continue.

• Multiple Objects

  If you select multiple objects in quick mode, BRSPACE displays a list of objects for confirmation. If the list is not what you require, you can go back and make a new selection.

  Example

  • The following example shows quick mode from the command line:

    brspace -f tsextend -t psapprd

    BRSPACE starts by displaying the input menu for the function Extend tablespace. The field for the object name is filled with your entry.

    You can now enter all required options and execute the function immediately.

  • The following example shows a command line entry for an alter function where the object (here, the database parameter) is specified, but not the action:

    brspace -f dbalter -p audit_trail

    BRSPACE starts by displaying the function main menu for the function that you entered, which is Alter database parameter in this example.

    You must first select the action before BRSPACE can display the input menu to let you execute the function.

  End of the example.

  Note

  When you have finished executing a function and you choose back after starting BRSPACE in quick mode, the quick mode is deactivated and you can choose a new object to execute the function again. If you choose reset program status, BRSPACE restores your original object selection.

  The exception to this is for the functions in segment management, where it makes no sense to display all tables or indexes, because the list would be too long.

Command options for BRSPACE

This section describes the command options for the BRSPACE tool.

If you use BRSPACE with command options, these override the corresponding values in the initialization profile init.sap. To use the options, you can specify either the letter indicated or the complete word.

Syntax

The syntax of a BRSPACE command is:

brspace [] -f|-function []

brspace -f dbparam –p circuits -v 24

Options

brspace

[-c|-confirm [force]]

[-h|-help []|[version]]

[-l|-language E|D]

[-o|-output [detail|process|summary|[,]time]]

[-p|-profile ]

[-s|-scroll ]

[-u|-user [[/]]]

[-V|-VERSION [ALL]]

-f|-function []

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.

Type ENTER.

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.