Reorganize Tables in SAP

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 to keep data accessibility more efficient, we need to maintain or organize 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 table space, merge data in table space 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 ?

1. Run BRTOOLS. Choose Segment Management or run from the command prompt brspace –f tbreorg.
2. Enter table name in Table names (table).
3. Choose Reorganize Tables.
4. Set the required option like new destination table space 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.
5. Choose continue to start processing.
6. 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.