Why do we need to reorganize table in SAP system ?
This is the important question before we plan to reorganize table in SAP system. Since Data Management Strategy is the key factor to boost system performance and and to keep data accessibility more efficient, we need to maintain or oraganize the data itself. One of the strategy is to reorg certain table which can impact on system performance. Reorganizing table can also be used to improve database structure, transform dictionary managed to locally managed tablespace, merge data in tablespace from many small files into larger files and perform segments defragmentation.
What types of reorganization is provided by SAP using BR*Tools?
You can perform the following types of reorganization:
- Reorganize tables online
- Check tables for reorganization
- Clean up tables after aborted reorganization
- Convert LONG and LONG RAW fields to CLOB or BLOB online (Oracle 10g or higher)
- Stop reorganization (command-line mode only)
- Suspend reorganization (command-line mode only)
- Resume reorganization (command-line mode only)
What is the procedure to perform reorganization using BR*Tools ?
- Run BRTOOLS. Choose Segement Management or run from the command prompt brspace –f tbreorg.
- Enter table name in Table names (table).
- Choose Reorganize Tables.
- Set the required option like new destination tablespace or set the parallel thread which will be used to perform reorganization. The more you set the thread, the faster your process will be. But this limited to the CPU specification in OS level.
- Choose continue to start processing.
- Check the detail log in s<encoded timestamp>.tbr.
Please take note that this online reorganization will impact on system performance, therefore you need to run this when the system load is low.
Filed under: BRTOOLS, SAP - Oracle, SAP DATABASE TOOLS, SAP Tips and Tricks Tagged: | BRSPACE, BRTOOLS, reorg, SAP, table reorganization, tbreorg
hello,
to you know how i can select more then one table for the reorganision?
the normal syntax ist:
brspace -f tbreorg -t CDCLS (example)
My challenge is to reorg a list of tables like
cdls
bsis
edi40
tst30
and so on – but not the whole tablespace!
thank you for your answer and thank you for this wonderful blog!
thomas
hello,
i got a solution from the sap:
create a text_file with this syntax
reorg_table =
,
,
and start the brspace with the option -p text_file
maybe someone needs this also!
best regards
thomas
Hi Thomas,
Thanks for another option, I agree that’s useful for numbers of table.
Cheers,
Hi Thomas,
Very good question! You can use double quotes to select multiple table like this :
brspace -f tbreorg -t “cdls,bsis,edi40,tst30″
This will show a list of those tables, then you can continue by enter : 1-4
It means you select all those table to be executed.
Cheers,
but then how to reorg a tablespace?
Hi Marjan,
To organize tablespace use this command :
brspace -f tbreorg -s|-tablespace
for example :
brspace -f tbreorg -s “PSAPUSR”
or you can go through BRTOOLS and put tablespace name on the options.
Cheers,