Show TOC

Background documentationAnalyzing Locate this document in the navigation structure

 

The analysis phase is primarily for analyzing the size of the database and the growth of the database tables to determine whether and which table contents are to be archived. You must then set up a suitable archiving. To do this, you must set parameters for adequate archiving. You need to determine which archiving objects to use to archive the contents of the critical database tables.

The following tools are available for these tasks. It is assumed that you are familiar with the specified tools and are able to interpret the values they provide.

  • Database Monitor

    With the Database Monitor (transaction DB02), you can check the size of database tables and determine their growth behavior in the past. The transaction provides important database-specific indicators. The presentation of the Database Monitor depends on the database system you are using. For Oracle, for example, the number of free tablespaces or the size and growth of the individual tables and indexes is shown.

    In addition to the Database Monitor, you can also use SAPDBA and the Performance Monitor (transaction ST04). These tools provide you with additional indicators that can help you make decisions concerning data archiving. The Tables and Archiving Objects function (see below) also provides you with storage space statistics (Space Statistics pushbutton).

  • Table Analysis

    You can use this function (transaction TAANA) to perform the analyses of database tables and examine their contents. During this analysis, the number of associated entries is assigned to particular field value combinations. Different analysis variants containing corresponding field lists are provided for this purpose. The generated analyses help you to determine the required archiving objects and provide information about which selection criteria would be most effective for archiving. In this way, you can avoid examining archiving objects or organizational units that contribute little to the data volume.

    For more information, see Table Analysis.

  • Tables and Archiving Objects

    After you have identified the critical tables, you need to find out which archiving objects they have been assigned to. You can use the function Tables and Archiving Objects (transaction DB15) to do this.

    You can use this function to find out about which tables are assigned to which archiving objects and vice versa. This means that you can assign the tables that you identified in the first analysis phase to a concrete archiving object with which the table contents can be archived.

    For more information, see Tables and Archiving Objects.