Show TOC

Function documentationReorganization and Compression Locate this document in the navigation structure

 

The Reorganization and Compression function simulates technical data volume reduction processes, such as reorganization and compression of database tables and indexes. You can also simulate the impact of migrating your database to SAP HANA. The function then uses the results of the simulation to generate a graphical overview of the potential data volume reductions to help you decide which processes to perform.

The Analysis List displays previously created analyses. The Result tab page displays completed system analyses.

Prerequisites

You have set up DBA Cockpit connection in the Managed System Configuration scenario of SAP Solution Manager Configuration. Otherwise, no systems are available for selection.

Features

  • Simulate data volume management to identify the most suitable reduction method

  • Generate statistical information to see how much data you could save

  • Filter objects to prioritize which objects most need data volume management

Activities

To create a new analysis, you have the following options:

  • To perform a basic compression and reorganization analysis (CRA) or HANA migration analysis of selected systems, choose New Analysis and follow the guided procedure. In this basic analysis, you can only perform an analysis of the entire system; you cannot select specific tables to analyze.

  • To perform an analysis for specific tables in each system, choose New Analysis Expert Mode and follow the guided procedure.

In the Metrics screen area, a pie chart shows the total size of the selected system and the potential data reduction if you perform the corresponding process. Only one chart is displayed for each system. Each time you perform a new analysis using different metrics, the results are added to the existing pie chart. You can also display the results in a stacked chart or table.

You generate a list of specific objects to reduce and filter the list according to certain criteria, for example, you can display the 25 largest objects.

More Information

For more information, see the help texts displayed in each step of the guided procedures.