tablespace reorg failed

[Former Member]

After client deletion we have planned for re-org for which we created the new tablespace and than when we fire the BRSAPCE cmd (brspace -u / -f tbreorg -s PSAPSR3 -t "*" -n PSAPSR3NEW)for Reorganizing tables into the new online tablespace we encountered the error

C:\Users\r3dadm>brspace -u / -f tbreorg -s PSAPSR3 -t "*" -n PSAPSR3NEW

BR1001I BRSPACE 7.00 (51)

BR0154E Unexpected option value 'AppData' found at position 9

BR0154E Unexpected option value 'Application Data' found at position 10

BR0154E Unexpected option value 'Contacts' found at position 11

BR0154E Unexpected option value 'Cookies' found at position 12

BR0154E Unexpected option value 'Desktop' found at position 13

BR0154E Unexpected option value 'dev_dpmon' found at position 14

.

................

BBR0700E Fatal errors occurred - terminating processing...

BR1008I End of BRSPACE processing: segqtrqo.log 2011-08-29 14.37.22

BR0280I BRSPACE time stamp: 2011-08-29 14.37.22

BR1007I BRSPACE terminated with errors

Please help to resolve the above issue.

Thanks and regards,

R Mav.

[Former Member]

Hi,

I am able run query now.

What i did was ; prepared a bat file which includes all the 78000 table name,

like this:

brspace -u / -c force -f tbreorg -s PSAPSR3 -t SAPSR3.TIVORRSTP -n PSAPSR3NEW

Previously every time it was asking me a table name so i prepared a script which include all the table name.

and this solution works for me.

Thanks for all your support.

Regards,

R Mav

[former_member204746]

Joe is right,

it is parsed incorrectly as it is trying to analyze your local directory's contents. This is not OK and not expected. it is probably a brtools bug.

I used that command soooo many times and never had this problem.

I would advise to upgrade to BRTOOLS 7.20 with latest patch level and try again. I'm pretty sure it will fix your issue.

[Former Member]

It seems you are on Windows, and -t "*" is parsed incorrectly.

Instead try -t '*' or -t all.

Joe is right -t all correction worked for me

Thanks a lot

Regards,

R Mav

[Former Member]

Hi,

But this command ask me to put table number to be reorg

brspace -u / -f tbreorg -s PSAPSR3 -t all -n PSAPSR3NEW

BR0659I List menu 352 + please select one or more entries

-

---

List of tables for reorganization

Pos. Owner Table Pt. DgPk. Rows Space[KB] Data[KB:%]

1 - SAPSR3 /1CN/CPASAP00001 NO 1 0 8 0:0

2 - SAPSR3 /1CN/CPNSAP00001 NO 1 0 8 0:0

3 - SAPSR3 /1CN/CPTSAP00001 NO 1 0 8 0:0

4 - SAPSR3 /1CN/CPTSAP00004 NO 1 0 8 0:0

5 - SAPSR3 /1CN/CPTSAP00005 NO 1 0 8 0:0

6 - SAPSR3 /1CN/CPTSAP00006 NO 1 0 8 0:0

7 - SAPSR3 /1CN/CRMSAP_CARR NO 1 0 8 0:0

8 - SAPSR3 /1CN/CRMSAP_CONN NO 1 0 8 0:0

9 - SAPSR3 /1CN/CRMSAP_PART NO 1 0 8 0:0

10 - SAPSR3 /1CN/CTXSAPD0001 NO 1 0 8 0:0

11 - SAPSR3 /1CN/CTXSAPD0002 NO 1 0 8 0:0

12 - SAPSR3 /1CN/CTXSAPD0003 NO 1 0 8 0:0

13 - SAPSR3 /1CN/CTXSAPD0004 NO 1 0 8 0:0

14 - SAPSR3 /1CN/CTXSAPD0201 NO 1 0 8 0:0

15 - SAPSR3 /1CN/CTXSAPR0100 NO 1 0 8 0:0

16 - SAPSR3 /1CN/CTXSAPR0103 NO 1 0 8 0:0

17 - SAPSR3 /1CN/CTXSAPR0104 NO 1 0 8 0:0

18 - SAPSR3 /1CN/CTXSAPR0105 NO 1 0 8 0:0

19 - SAPSR3 /1CN/CTXSAPR0106 NO 1 0 8 0:0

20 - SAPSR3 /1CN/CTXSAPR0107 NO 1 0 8 0:0

Press <Rtn> - scroll, <n> - select, 'c' - cont, 'h' - header, 's' - stop ...

and this way i've to give each table number to be re org

Is there any correction need to be done in command?

Regards,

RMav

[former_member204746]

try this:

brspace -u / -c force -f tbreorg -s PSAPSR3 -t all -n PSAPSR3NEW

[volker_borowski2]

simply type "c" = Continue.

This will list all tables that fit your wildcard.

Volker

[Former Member]

Hi All,

No luck with below command

brspace -u / -c force -f tbreorg -s PSAPSR3 -t all -n PSAPSR3NEW

still unable to run reorg tablespace

BR0280I BRSPACE time stamp: 2011-09-30 17.01.19

BR0700E Fatal errors occurred - terminating processing...

BR1022I Number of tables processed: 0

BR1004E BRSPACE function 'tbreorg' failed

BR1008I End of BRSPACE processing: segwvmgu.tbr 2011-09-30 17.01.19

BR0280I BRSPACE time stamp: 2011-09-30 17.01.20

BR1007I BRSPACE terminated with errors

I've upgraded the brtools also.

Please suggest.

[former_member204746]

provide the full log. it looks like we are missing important error messages.

[Former Member]

It seems you are on Windows, and -t "*" is parsed incorrectly.

Instead try -t '*' or -t all.

[Former Member]

brspace command looks legit, but are you using sidadm instead of orasid there?

[Former Member]

Hello,

What is SAP/DB version ? Please try to update DBAtools with latest patch in kernel. This should resolve the problem.

Thanks