Skip to Content
0
Former Member
Jun 05, 2009 at 11:41 AM

Rebuild the index form brtools ended with error

84 Views

Dear all,

I am getting error in db13 Update Stats there error is

BR0884I Statistics collected for table: SAPDEV.TCX00, rows old/new: 24117/24117

BR0986W Index SAPDEV.TCX00~0 is unbalanced - please rebuild the index

I have try to rebuild for brtools

BR0656I Choice menu 354 - please make a selection

Rebuild indexes main menu

1 = Rebuild indexes

2 - Show indexes

3 - Show tablespaces

4 * Exit program

5 - Reset input values and segment infos

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2009-06-05 16.44.41

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2009-06-05 16.44.43

BR1039I Selecting information about tables and indexes...

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRSPACE time stamp: 2009-06-05 16.44.52

BR0814I Number of tables in schema of owner SAPDEV: 44138

BR0280I BRSPACE time stamp: 2009-06-05 16.44.58

BR0815I Number of indexes in schema of owner SAPDEV: 52801

BR0065E Tablespace TCX00~0 not found

BR0182E Checking parameter/option '-s -tablespace' failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRSPACE time stamp: 2009-06-05 16.44.58

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Please suggest how to solve the probem

Regards,