Reorg /BIC* tables BW

[former_member209959]

Hi,

For performance reasons, we want to reorganize two /BIC/* tables in our
system. Do we have to take in account some special considerations for
this tables or the reorganization is the same than for the rest of
Basis tables?

Best Regards.

[former_member209959]

Hi, finally I've reorganised the tables in a usual way, like any other tables and it seems everything is ok.

Another question I have is: do you think to reorganise this /BIC/* tables can improve the performance in a BW system?

Best regards again

[former_member420327]

Hello,

Not having found other post and following the links may not match the problems encountered during
the reorganization of TB PSAPSR3ODS.

http://scn.sap.com/message/6355081#6355081

http://scn.sap.com/thread/3396620

I continue in this discution.

My BW system is 7.31 and SP 10 for abap/basis.

The database server is RAC + ASM on Oracle version 12.1.0.2.0 with the latest SBP for Exadata and GRID 12c.

The BRTOOLS installed version 7.40 SP 21 in a volume ACFS (ASM cluster file system)
is the shared volume for sapmnt across all the RAC DB servers.

My only porblem is to reorganize tables and indexes partitioned.

This reorganization is to pass a small file  (32Gb per datafile) in bigfile
a datafile can go up to 32 To and the benefit performance of the ASSM (automatic storage segement management ).

I created a temporary TB (PSAPSR3TMP) in bigfile to reorganize the tables and indexes not-partitionned, this step is OKEY.

when I want to reorganize 2 tables and indexes partionned , I have a SQL error and glibc.

I have already made a ticket to the SAP support, but I've also seek solutions via the SAP Forum.

I have try with one parallel process

brspace -u // -f  tbreorg -a reopart -s PSAPSR3ODS  -tp "*" -n PSAPSR3TMP -m online  -p 1

The log of Brsapace :

BR1001I BRSPACE 7.40 (21)
BR1002I Start of BRSPACE processing: seucejpc.tbr 2016-09-19 12:35:56
BR0484I BRSPACE log file: /oracle/DWO/sapreorg/seucejpc.tbr

Bla,bla,bla .....

BR0280I BRSPACE time stamp: 2016-09-19 12:36:56
BR0814I Number of tables/partitions in schema of owner SAPSR3: 35786/13012
BR0836I Number of tables treated as info cubes for owner SAPSR3: 212

BR0280I BRSPACE time stamp: 2016-09-19 12:37:15
BR0660I List display 372 - no selection possible
-------------------------------------------------------------------------------
List of table partitions for reorganization

  Pos.  Owner    Table              Partition                Rows  Tablespace

    1 - SAPSR3   /BIC/B0000772000   /BIC/B00007720000000000004     996499  PSAPSR3ODS
    2 - SAPSR3   /BIC/B0000772000   /BIC/B00007720000000000005     931044  PSAPSR3ODS

Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
BR0280I BRSPACE time stamp: 2016-09-19 12:37:17
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0657I Input menu 353 - please enter/check input values

-------------------------------------------------------------------------------

Options for reorganization of table partitions: SAPSR3./BIC/B0000772000./BIC/B00007720000000000004,... (2 partitions)

1 * Reorganization action (action) ............ [reopart]

2 - Reorganization mode (mode) ................ [online]

3 - Create DDL statements (ddl) ............... [yes]

4 ~ New destination tablespace (newts) ........ [PSAPSR3TMP]

5 ~ Separate index tablespace (indts) ......... []

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

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

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

9 ~ Sort by fields of index (sortind) ......... []

10 # Index for IOT conversion (iotind) ......... [FIRST]

11 - Compression action (compress) ............. [none]

12 # LOB compression degree (lobcompr) ......... [medium]

13 # Index compression method (indcompr) ....... []

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

-------------------------------------------------------------------------------

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2016-09-19 12:37:19

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2016-09-19 12:37:23

BR1108I Checking tables for reorganization...

BR0280I BRSPACE time stamp: 2016-09-19 12:37:23

BR1112I Number of table partitions selected/skipped for reorganization: 2/0

BR0280I BRSPACE time stamp: 2016-09-19 12:37:23

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

BR0280I BRSPACE time stamp: 2016-09-19 12:37:26

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0370I Directory /oracle/DWO/sapreorg/seucejpc created

BR0280I BRSPACE time stamp: 2016-09-19 12:37:26

BR1101I Starting 'online' table partition reorganization...

BR0280I BRSPACE time stamp: 2016-09-19 12:37:26

BR1147I Creating DDL statements for table SAPSR3./BIC/B0000772000 ...

BR0280I BRSPACE time stamp: 2016-09-19 12:37:26

BR1118I DDL statements created for table SAPSR3./BIC/B0000772000

BR0280I BRSPACE time stamp: 2016-09-19 12:37:26

BR1124I Starting 'online' reorganization of table partition SAPSR3./BIC/B0000772000./BIC/B00007720000000000004 ...

BR0280I BRSPACE time stamp: 2016-09-19 12:37:27

BR0301E SQL error -907 at location tab_onl_reorg-122, SQL statement:

'ALTER TABLE "SAPSR3"."/BIC/B0000772000#$" ADD ("/BIC/ZGCTPIMPC" VARCHAR2(3) DEFAULT ' ' NOT NULL ENABLEA)'

ORA-00907: missing right parenthesis

BR0280I BRSPACE time stamp: 2016-09-19 12:37:27

BR1106E Reorganization of table partition SAPSR3./BIC/B0000772000./BIC/B00007720000000000004 failed

BR0280I BRSPACE time stamp: 2016-09-19 12:37:27

BR1124I Starting 'online' reorganization of table partition SAPSR3./BIC/B0000772000./BIC/B00007720000000000005 ...

*** glibc detected *** brspace: malloc(): memory corruption: 0x0000000003280940 ***

*** glibc detected *** brspace: malloc(): memory corruption: 0x0000000003280940 ***

Killed

Regards,

Hervé

[kaus19d]

Hi ,

I would suggest in this kind of scenarios, as because this is an old discussion thread & you feel that you matter is different, so why do not you start a new discussion by going in the below,

Start a Discussion Button is there on the top right corner of this page. According to your issue, you check for the reorg for the PSAPTEMP & also do check for available space before doing that. I also take that you have checked the below,

Try Offline-Re-org, its better actually.

Thanks,

Kaushik

[former_member209959]

Hi,

In brtools 7.20 --> Segment management --> Reorganize tables, I have the usual option 6 - Table names (table) and with the output of brspace: -s 20 -l E -f tbreorg -t "/BIC/E100067" and the option 7 - Table partitions (tabpart) with output -s 20 -l E -f tbreorg -tp "/BIC/E100067".

My question is: is there any differences between use the option 6 (tbreorg -t) o option 7 (tbreorg -tp) for the /BIC/* tables or I can use both?

Regards.

[Reagan]

Read this SAP note

1360603  - Reorganizing and rebuilding individual partitions

Regards

RB

[AtulKumarJain]

Hi Maximino,

Please check below thread

http://scn.sap.com/message/6355081

it will sure help you.

BR

Atul