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: 

Trying to use brspace to do a reorg

Go to solution
vince_laurent
Active Participant

on ‎04-22-2008 5:58 PM

0 Kudos

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?

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
‎04-22-2008 6:15 PM
0 Kudos

> BR0657I Input menu 353 - please enter/check input values

> Why is it only doing 50 of the 353 tables?

"353" is not the number of tables but the menu path (3 - 5 -3) that you chose

Markus

Show replies
Show replies

Answers (4)

Answers (4)

vince_laurent
Active Participant
‎04-23-2008 6:01 AM
0 Kudos

I misread the screen. The number was infact the number of items in that TS. Doing another TS showed me the error of my ways.

Vince

Show replies
Show replies
vince_laurent
Active Participant
‎04-22-2008 7:51 PM
0 Kudos

And it just finished...

BR1141I 50 of 50 tables processed - 28149432 of 28149432 rows done

BR0204I Percentage done: 100.00%, estimated end time: 13:49

BR0001I **************************************************

BR0280I BRSPACE time stamp: 2008-04-22 13.49.59

BR1432I Number of tables moved successfully: 50

It went BIZARRO. FactD was 3G and FactI was 2 G before this attempt.

Fact2D is 3G but Fact2I is now 13G!!!

Show replies
Show replies
vince_laurent
Active Participant
‎04-22-2008 7:38 PM
0 Kudos

From DB02 then saved to an excel file:

Owner Object Type Tablespace KBytes Blocks Extents MaxExtents Next (K)

1 SAPR3 /BIC/EZQM_C50200509 TABLE PART PSAPFACTD 64 8 1 -1 0

2 SAPR3 /BIC/EZQM_C50200508 TABLE PART PSAPFACTD 64 8 1 -1 0

3 SAPR3 /BIC/EZQM_C50200507 TABLE PART PSAPFACTD 64 8 1 -1 0

4 SAPR3 /BIC/EZQM_C50200506 TABLE PART PSAPFACTD 64 8 1 -1 0

.

.

.

595 SAPR3 /BIC/EZRC_C5192003003 TABLE PART PSAPFACTD 64 8 1 -1 0

596 SAPR3 /BIC/EZRC_C5192003002 TABLE PART PSAPFACTD 64 8 1 -1 0

597 SAPR3 /BIC/EZRC_C5192003001 TABLE PART PSAPFACTD 64 8 1 -1 0

Show replies
Show replies
stefan_koehler
Active Contributor
‎04-22-2008 8:01 PM
0 Kudos

Hello Vince,

>1 SAPR3 /BIC/EZQM_C50200509 TABLE PART PSAPFACTD 64 8 1 -1 0

>2 SAPR3 /BIC/EZQM_C50200508 TABLE PART PSAPFACTD 64 8 1 -1 0

Yeah wait a second. You didn't count the tables.. you count the tables and the table partitions. Now i see that this is a BW system and this is using partitioned tables. DB02n is giving you a cumulative view for that too.

> It went BIZARRO. FactD was 3G and FactI was 2 G before this attempt.

>Fact2D is 3G but Fact2I is now 13G!!!

Please provide some values (from dba views or db02) about that, maybe you have counted only one partition at the first time.

Regards

Stefan

vince_laurent
Active Participant
‎04-23-2008 6:00 AM
0 Kudos

New user error.... see my new question.

Thanks for your patience on this issue

Vince

vince_laurent
Active Participant
‎04-22-2008 7:17 PM
0 Kudos

Oh, dopey me. OK then. WHy does it say '50 tables' when there are 597?

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

Show replies
Show replies
stefan_koehler
Active Contributor
‎04-22-2008 7:28 PM
0 Kudos

Hello Vince,

> Why does it say '50 tables' when there are 597?

Where do you see 597?

Try to verify via:

> SQL> select count(*) from dba_tables where TABLESPACE_NAME = 'PSAPFACT2D';

Regards

Stefan

Ask a Question