After oracle 11g upgrade, how compress table in SAP ECC 6.0

[Former Member]

Hi,

Can you help me after oracle 11g upgrade, how compress table in SAP ECC 6.0?

Thanks,

Manas

[markus_doehr2 · Accepted solution]

Start reading the following notes:

Note 1289494 - FAQ: Oracle compression

Note 1436352 - Oracle 11g Advanced Compression for SAP Systems

Note 1431296 - LOB conversion and table compression with BRSPACE 7.20

Markus

[Former Member · Accepted solution]

Hi Marks,

Thanks for your reply.

I already read your mention notes.

Please help me one things that brspace syntax for compress all the tables.

Thanks,

Manas

[markus_doehr2 · Accepted solution]

As mentioned in the notes it is not advised to compress "all" tables. If you use the newest brtools 7.20 you can set up the compression menu driven. Did you try that?

Markus

[Former Member · Accepted solution]

yes I uses brtools 7.20 but i can not understand for set up the compression menu driven.

-

---

Manas

Edited by: manassahoo on Sep 17, 2011 8:42 PM

[Former Member · Accepted solution]

Hi,

At the first stage, tablespace should be created with compressed attribute, in order to set compressed attribute on newly created tables. If you are planning to compress the table with the data, it must be exported, first. Then, table should be created with compressed attribute and import the data into the table back.

Do not forget to create the statistics, after the respective import into the table.

Please note that if the table already contains the data before you alter it, only new records will be compressed.

Another point is, LONG RAW fields must be converted to LOB type.

Find the command, below;

brspace -u / -f tbreorg -a long2lob -o sap<sid> -s <src_tsp> -t allsel -n <new_tsp> -c ctablob -lc medium -SCT

Please read the note "1436352 - Oracle 11g Advanced Compression for SAP Systems" very carefully. Everything is explained very well in the note.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hi

After oracle 11g upgrade , I try to compress one table by the following command

brspace -f tbreorg -a lob2lob -c ctablob -l 2 -t PCL2

but after reorganization completed i not found any difference between the old table size & after re-org table size.

Please send syntax of brspace for tablespace creation with compressed attribute.

I want to compress the existing table which contain the data of PSAPSR3 table space i.e. how compress the table of PSAPSR3 table space . Please mention the step.

Thanks

Manas

Edited by: manassahoo on Sep 18, 2011 7:25 AM

[Former Member · Accepted solution]

Hi Markus/Orkun

when i execute the following command for Compressing the tables without LONG and LOB fields:

brspace -u / -p reorgEXCL.tab -f tbreorg -a reorg -o SAPSR3 -s PSAPSR3 -t allsel -n PSAPSR3IPD -c ctablob -SCT -m offline

it showing the below error----

BR1001I BRSPACE 7.20 (16)

BR0252E Function fopen() failed for '/oracle/IPD/112_32/dbs/reorgEXCL.tab' at location BrInitSapRead-1

BR0253E errno 2: No such file or directory

BR0159E Error reading BR*Tools profile /oracle/IPD/112_32/dbs/reorgEXCL.tab

BR0700E Fatal errors occurred - terminating processing...

BR1008I End of BRSPACE processing: segvdpyq.log 2011-09-21 18.52.45

BR0280I BRSPACE time stamp: 2011-09-21 18.52.45

BR1007I BRSPACE terminated with errors

Thanks

Manas

[volker_borowski2 · Accepted solution]

> BR0252E Function fopen() failed for '/oracle/IPD/112_32/dbs/reorgEXCL.tab' at location BrInitSapRead-1
> BR0253E errno 2: No such file or directory

Hi,

obviously you did not create this file "reorgEXCL.tab" as explained in the note!

Volker

[Former Member · Accepted solution]

Hi Volker,

Can you help me how I create this file "reorgEXCL.tab". Please specify the note number.

Thanks

Manas

[Former Member · Accepted solution]

Hi Manas,

Since you use brtools 720

Note 1431296 - LOB conversion and table compression with BRSPACE 7.20

Read the section - To handle RFC tables

Thanks

[Former Member · Accepted solution]

Hi,

Thanks for your reply. Problem resolved.

Thanks

Manas

[Former Member · Accepted solution]

Hi all,

Any one cal tell me after compression of SAP IDES ECC 6.0 how many size reduce?

Thanks

Manas

[Former Member · Accepted solution]

Hello Manas,

how big is your IDES system? Maybe 200 GB? I think it contains only realtively few transactional data. ABAP sources and loads are stored in cluster tables which should not be compressed, therefore the compression rate of an empty (newly installed) system or an IDES system will be pretty bad. So check your system whether your largest tables are SAP pool or cluster tables (which won't be compressed).

Regards,

Mark

[Former Member · Accepted solution]

Thanks Mark.

[Former Member · Accepted solution]

Hi All,

After oracle 11g upgrade can I compress all the table space or only PSAPSR3 required to compress?

Please help me.

Thanks,

Manas

[Former Member · Accepted solution]

Hi All,

Any one can tell me after oracle 11g upgrade which tablespace compress only PSAPSR3 or any other tablespace????

Thanks

Manas

[Former Member · Accepted solution]

Hello Manas,

if you have the default SAP tablespace layout then compress PSAPSR3, PSAPSR3USR and PSAPSR3<REL>.

Obviously you cannot compress PSAPTEMP and PSAPUNDO. And the SAP tools won't touch SYSTEM and SYSAUX.

If you have manually created some PSAP<whatever> tablespaces containing tables and/or indexes then compress them as well.

Regards,

Mark

[Former Member · Accepted solution]

Thanks Mark.

Can i compress all the tablespace in same procedure which mention the sapnote_0001431296 ???

Thanks

Manas

[Former Member · Accepted solution]

Hello Manas,

yes of course. This procedure works the same on all tablespaces. You can use the procedure from SAP note 1431296 for all SAP data tablespaces you have.

Regards,

Mark

[Former Member]

Dear All,

I am also having the query that i am having the below tablespace

PSAPSR3

          PSAPSR3700

          PSAPSR3FACT

          PSAPSR3ODS

          PSAPSR3USR

          PSAPTEMP

          PSAPUNDO

          SYSAUX

          SYSTEM

I have created new sapdata5 to 8 .....

i will run the 6 command which is mention in sap note 1431296

for

PSAPSR3Z,PSAPSR3700Z,PSAPSR3FACTZ,PSAPSR3ODSZ,PSAPSR3USRZ,

PSAPTEMPZ, and PSAPUNDOZ

then how to move sysaux and system to sapdata5 to 8 .....

please help me on the same

Rableen