cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

rebuild the index

Go to solution
Former Member

on ‎04-21-2009 12:30 PM

0 Kudos

Dear all

I am rebuild the index in production serevr in follwing way ,

please advise , this is the right way , any loose data .

C:\>brtools

BR0651I BRTOOLS 7.00 (16)

BR0280I BRTOOLS time stamp: 2009-04-21 16.37.42

BR0656I Choice menu 1 - please make a selection

-

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

4

BR0280I BRTOOLS time stamp: 2009-04-21 16.37.46

BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2009-04-21 16.37.46

BR0656I Choice menu 9 - please make a selection

-

Backup and database copy

1 = Database backup

2 - Archivelog backup

3 - Database copy

4 - Non-database backup

5 - Backup of database disk backup

6 - Verification of database backup

7 - Verification of archivelog backup

8 - Additional functions

9 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

1

BR0280I BRTOOLS time stamp: 2009-04-21 16.37.47

BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2009-04-21 16.37.47

BR0657I Input menu 15 - please check/enter input values

-

BRBACKUP main options for backup and database copy

1 - BRBACKUP profile (profile) ....... [initQAS.sap]

2 - Backup device type (device) ...... [tape]

3 ~ Tape volumes for backup (volume) . []

4 # BACKINT/Mount profile (parfile) .. []

5 - Database user/password (user) .... [/]

6 - Backup type (type) ............... [offline]

7 - Disk backup for backup (backup) .. [no]

8 # Delete disk backup (delete) ...... [no]

9 ~ Files for backup (mode) .......... [all]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

b

BR0280I BRTOOLS time stamp: 2009-04-21 16.37.52

BR0663I Your choice: 'b'

BR0673I Going back to the previous menu...

BR0280I BRTOOLS time stamp: 2009-04-21 16.37.52

BR0656I Choice menu 9 - please make a selection

-

Backup and database copy

1 = Database backup

2 - Archivelog backup

3 - Database copy

4 - Non-database backup

5 - Backup of database disk backup

6 - Verification of database backup

7 - Verification of archivelog backup

8 - Additional functions

9 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

b

BR0280I BRTOOLS time stamp: 2009-04-21 16.37.55

BR0663I Your choice: 'b'

BR0673I Going back to the previous menu...

BR0280I BRTOOLS time stamp: 2009-04-21 16.37.55

BR0656I Choice menu 1 - please make a selection

-

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

3

BR0280I BRTOOLS time stamp: 2009-04-21 16.37.58

BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2009-04-21 16.37.58

BR0656I Choice menu 7 - please make a selection

-

Database segment management

1 = Reorganize tables

2 - Rebuild indexes

3 - Export tables

4 - Import tables

5 - Alter tables

6 - Alter indexes

7 - Additional segment functions

8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

2

BR0280I BRTOOLS time stamp: 2009-04-21 16.38.06

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2009-04-21 16.38.06

BR0657I Input menu 92 - please check/enter input values

-

BRSPACE options for rebuild of indexes

1 - BRSPACE profile (profile) ...... [initQAS.sap]

2 - Database user/password (user) .. [/]

3 ~ Rebuild action (action) ........ []

4 ~ Tablespace names (tablespace) .. []

5 ~ Index owner (owner) ............ []

6 ~ Table names (table) ............ []

7 ~ Index names (index) ............ []

8 - Confirmation mode (confirm) .... [yes]

9 - Extended output (output) ....... [no]

10 - Scrolling line count (scroll) .. [20]

11 - Message language (language) .... [E]

12 - BRSPACE command line (command) . [-p initQAS.sap -s 20 -l E -f idrebuild]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

6

BR0280I BRTOOLS time stamp: 2009-04-21 16.38.15

BR0663I Your choice: '6'

BR0280I BRTOOLS time stamp: 2009-04-21 16.38.15

BR0681I Enter string value for "table" []:

mkpf

BR0280I BRTOOLS time stamp: 2009-04-21 16.38.20

BR0683I New value for "table": 'mkpf'

BR0280I BRTOOLS time stamp: 2009-04-21 16.38.20

BR0657I Input menu 92 - please check/enter input values

-

BRSPACE options for rebuild of indexes

1 - BRSPACE profile (profile) ...... [initQAS.sap]

2 - Database user/password (user) .. [/]

3 ~ Rebuild action (action) ........ []

4 ~ Tablespace names (tablespace) .. []

5 ~ Index owner (owner) ............ []

6 ~ Table names (table) ............ [mkpf]

7 ~ Index names (index) ............ []

8 - Confirmation mode (confirm) .... [yes]

9 - Extended output (output) ....... [no]

10 - Scrolling line count (scroll) .. [20]

11 - Message language (language) .... [E]

12 - BRSPACE command line (command) . [-p initQAS.sap -s 20 -l E -f idrebuild -t

"mkpf"]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2009-04-21 16.38.22

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initQAS.sap -s 20 -l E -f idreb

uild -t "mkpf"'

BR0280I BRTOOLS time stamp: 2009-04-21 16.38.22

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2009-04-21 16.38.23

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 7.00 (16)

BR1002I Start of BRSPACE processing: seakenfs.idr 2009-04-21 16.38.24

BR0280I BRSPACE time stamp: 2009-04-21 16.38.26

BR1009I Name of database instance: QAS

BR1010I BRSPACE action ID: seakenfs

BR1011I BRSPACE function ID: idr

BR1012I BRSPACE function: idrebuild

BR0280I BRSPACE time stamp: 2009-04-21 16.38.26

BR0656I Choice menu 354 - please make a selection

-

Rebuild indexes main menu

1 = Rebuild indexes

2 - Show indexes

3 - Show tables

4 - Show tablespaces

5 * Exit program

6 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

1

BR0280I BRSPACE time stamp: 2009-04-21 16.38.28

BR0663I Your choice: '1'

BR0280I BRSPACE time stamp: 2009-04-21 16.38.38

BR0659I List menu 355 + please select one or more entries

-

List of indexes for rebuild

Pos. Owner Table Index Pt. Dg. Tablespace

1 - SAPPRD MKPF MKPF~0 NO 1 PSAPPRD

2 - SAPPRD MKPF MKPF~BUD NO 1 PSAPPRD

3 - SAPPRD MKPF MKPF~BVO NO 1 PSAPPRD

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your selection:

thanks

with best regrads

venkat

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎04-21-2009 5:02 PM
0 Kudos

check this out

[http://help.sap.com/saphelp_nw70/helpdata/en/75/95536a63b44b4a9e7f278c7d9c2b67/content.htm]

Show replies
Show replies

Answers (1)

Answers (1)

lbreddemann
Active Contributor
‎04-21-2009 12:55 PM
0 Kudos

use the CODE tag ...use the CODE tag ...use the CODE tag ...use the CODE tag ...

If your goal is to rebuild all indexes of table MKPF then you're doing it correctly.

Anyhow - why don't simply use the documentation to find the answer yourself?

regards,

Lars

Show replies
Show replies
Ask a Question