Skip to Content
0
Apr 22, 2008 at 04:58 PM

Trying to use brspace to do a reorg

57 Views

I am trying to reorg ALL the tables in one tablespace at once:

brspace -f tbreorg -a reorg -i psapfact2i -m offline -n psapfact2d -s psapfactd -t "*"

I get this back:

BR1001I BRSPACE 7.00 (33)

BR1002I Start of BRSPACE processing: sdxtkjdu.tbr 2008-04-22 11.57.42

BR0484I BRSPACE log file: /oracle/BQA/sapreorg/sdxtkjdu.tbr

BR0280I BRSPACE time stamp: 2008-04-22 11.57.45

BR1009I Name of database instance: BQA

BR1010I BRSPACE action ID: sdxtkjdu

BR1011I BRSPACE function ID: tbr

BR1012I BRSPACE function: tbreorg

BR0280I BRSPACE time stamp: 2008-04-22 11.57.47

BR1039I Selecting information about tables and indexes...

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

BR0280I BRSPACE time stamp: 2008-04-22 11.57.49

BR0814I Number of tables/partitions in schema of owner SAPR3: 15948/1024

BR0280I BRSPACE time stamp: 2008-04-22 11.57.56

BR0815I Number of indexes/partitions in schema of owner SAPR3: 21106/6021

BR0280I BRSPACE time stamp: 2008-04-22 11.57.56

BR0660I List display 352 - no selection possible

-


List of tables for reorganization

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

1 - SAPR3 /BI0/E0BWTC_C02 NO 1 0 72 0:0

2 - SAPR3 /BI0/E0BWTC_C03 NO 1 0 72 0:0

3 - SAPR3 /BI0/E0BWTC_C04 NO 1 0 72 0:0

4 - SAPR3 /BI0/E0BWTC_C05 NO 1 0 72 0:0

5 - SAPR3 /BI0/E0BWTC_C06 NO 1 0 72 0:0

6 - SAPR3 /BI0/E0BWTC_C07 NO 1 0 72 0:0

7 - SAPR3 /BI0/E0BWTC_C09 NO 1 0 72 0:0

8 - SAPR3 /BI0/E0BWTC_C11 NO 1 0 72 0:0

9 - SAPR3 /BI0/E0PCA_C01 YES 1 0 584 0:0

10 - SAPR3 /BI0/E0PCA_C02 NO 1 0 72 0:0

11 - SAPR3 /BI0/F0BWTC_C02 YES 1 5405 1040 713:69

12 - SAPR3 /BI0/F0BWTC_C03 YES 1 0 72 0:0

13 - SAPR3 /BI0/F0BWTC_C04 YES 1 0 72 0:0

14 - SAPR3 /BI0/F0BWTC_C05 YES 1 128 144 6:4

15 - SAPR3 /BI0/F0BWTC_C06 YES 1 0 72 0:0

16 - SAPR3 /BI0/F0BWTC_C07 YES 1 0 72 0:0

17 - SAPR3 /BI0/F0BWTC_C09 YES 1 0 72 0:0

18 - SAPR3 /BI0/F0BWTC_C11 YES 1 0 72 0:0

19 - SAPR3 /BI0/F0PCA_C01 YES 1 9985560 715472 565588:79

20 - SAPR3 /BI0/F0PCA_C02 YES 1 3964200 144840 100654:69

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

21 - SAPR3 /BIC/E100000 NO 1 289140 18440 13836:75

22 - SAPR3 /BIC/E100001 NO 1 147720 9224 7069:77

23 - SAPR3 /BIC/E100002 NO 1 587930 50184 40191:80

24 - SAPR3 /BIC/EMMPUR_C01 NO 1 0 72 0:0

25 - SAPR3 /BIC/EZCO_C50 NO 1 0 72 0:0

26 - SAPR3 /BIC/EZCO_C51 NO 1 0 72 0:0

27 - SAPR3 /BIC/EZECCS_C04 NO 1 0 72 0:0

28 - SAPR3 /BIC/EZMMPURC01 NO 1 0 72 0:0

29 - SAPR3 /BIC/EZPCA_C03 YES 1 0 488 0:0

30 - SAPR3 /BIC/EZPURC001 YES 1 0 2664 0:0

31 - SAPR3 /BIC/EZPURC002 YES 1 0 296 0:0

32 - SAPR3 /BIC/EZQM_C50 YES 1 0 16488 0:0

33 - SAPR3 /BIC/EZRC_C50 NO 1 0 72 0:0

34 - SAPR3 /BIC/EZRC_C51 YES 1 0 488 0:0

35 - SAPR3 /BIC/F100000 YES 1 0 72 0:0

36 - SAPR3 /BIC/F100001 YES 1 0 72 0:0

37 - SAPR3 /BIC/F100002 YES 1 0 72 0:0

38 - SAPR3 /BIC/FMMPUR_C01 YES 1 590150 53328 42648:80

39 - SAPR3 /BIC/FZCO_C50 YES 1 478120 55552 41555:75

40 - SAPR3 /BIC/FZCO_C51 YES 1 32610 4176 2898:69

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

41 - SAPR3 /BIC/FZECCS_C04 YES 1 744980 34696 25463:73

42 - SAPR3 /BIC/FZMMPURC01 YES 1 9719 976 655:67

43 - SAPR3 /BIC/FZPCA_C03 YES 1 11251680 741872 593350:80

44 - SAPR3 /BIC/FZPURC001 YES 1 0 72 0:0

45 - SAPR3 /BIC/FZPURC002 YES 1 0 8 0:0

46 - SAPR3 /BIC/FZQM_C50 YES 1 0 72 0:0

47 - SAPR3 /BIC/FZRC_C50 YES 1 62090 4576 1819:40

48 - SAPR3 /BIC/FZRC_C51 YES 1 0 8 0:0

49 - SAPR3 RSDMFACTAB NO 1 0 72 0:0

50 - SAPR3 RSMDMCNVTAB NO 1 0 72 0:0

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

-


BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2008-04-22 11.58.02

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2008-04-22 11.58.02

BR0657I Input menu 353 - please enter/check input values

-


Options for reorganization of tables: SAPR3./BI0/E0BWTC_C02,... (50 tables)

1 ~ New destination tablespace (newts) ........ [PSAPFACT2D]

2 ~ Separate index tablespace (indts) ......... [PSAPFACT2I]

3 - Parallel threads (parallel) ............... [1]

4 ~ Table/index parallel degree (degree) ...... []

5 # Create DDL statements (ddl) ............... [yes]

6 ~ Category of initial extent size (initial) . []

7 # Sort by fields of index (sortind) ......... []

8 - Table reorganization mode (mode) .......... [offline]

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

-


BR0662I Enter your choice:

Why is it only doing 50 of the 353 tables?