Show TOC

StatisticsLocate this document in the navigation structure

Use

When writing, deleting, reading, or reloading, the system automatically generates statistical data on each archiving run (such as the storage space that has been freed in the database by deletions, or the number of deleted data objects), and stores it persistently in the database.

Data archiving administrators can analyze these key figures so that they can better plan future archiving projects and provide the necessary resources. Statistics also provide pertinent information on the role of data archiving in reducing the volume of data in the database.

Features

Statistics are collected by the Archive Development Kit (ADK). This occurs during the write, delete, and reload processes. In other archiving contexts, for example execution of preprocessing, postprocessing, or conversion programs, no statistical data is collected.

You can call the analysis transaction either directly from the initial Archive Administration screen (transaction SARA), or from the Management screen in Archive Administration, using the Statistics pushbutton. Alternatively, you can use the SAR_DA_STAT_ANALYSIS transaction.

As well as being displayed directly in the analysis transaction, the statistical information flows into the standard log of the write, delete, read, and reload program. You can analyze it there as well. As a prerequisite, the relevant application must call the standard log. In the programs mentioned, the standard log is output in the write program only, in both test mode and productive mode. In other programs, it is only output in productive mode. In other archiving contexts, such preprocessing, postprocessing, or conversion programs, no standard log is issued.

Selection

Statistical information is displayed on the basis of the selection data entered here. This includes:

  • The client in which the archiving session was executed

  • The name of the archiving object

  • The date on which the archiving session data was created

  • The status of the archiving session

Archiving Session Status

When selecting the archiving sessions for reporting, you can choose between archiving sessions with the following statuses:

  • Incomplete

  • Complete

  • Replaced

To select a status, enter the corresponding code. You can mark one indicator, or a combination of several.

The status used here is the same as the archiving session status in the management part of Archive Administration. You can find more information under Archiving Session Details.

Displaying Statistical Information

To display statistical information, choose the Display Statistics pushbutton.

Note

Via Choose Layout, you can change various statistics display settings, such as column width, column order, or column selection. You can also save this changed display as a user-specific layout variant. For a display that is easier to use, for example, you can hide columns that do not interest you.

In the full display (that is, if a user-layout has not been defined), the following information is displayed:

Column

Explanation

Session number

Number of archiving session

Object

Name of archiving object

Client

Client in which the archiving session was executed

Date

Date on which the archiving session was executed

Status

Status of the archiving session (incomplete, complete, replaced)

Disk space

Space on the (hard) disk occupied by the archiving session

Header data

Proportion of header data in the archiving session that classifies and describes the actual data

Total DB storage space (write)

Virtual storage space in MB that an incomplete archiving session occupies in the database

DB table storage space (write)

Occupied table storage space in the database in MB

DB index storage space (write)

Occupied index storage space in the database in MB

DB cluster storage space (write)

Occupied cluster storage space in the database in MB

DB structure storage space (write)

Occupied structure storage space in the database in MB

Total DB storage space (delete)

Virtual storage space in MB that was deleted from the database by a completed archiving session

DB table storage space (delete)

Deleted table storage space in the database in MB

DB index storage space (delete)

Deleted index storage space in the database in MB

DB cluster storage space (delete)

Deleted cluster storage space in the database in MB

DB structure storage space (delete)

Deleted structure storage space in the database in MB

Total DB storage space (reload)

Virtual storage space in MB that was reloaded into the database by a replaced archiving session

DB table storage space (reload)

Reloaded table storage space in the database in MB

DB index storage space (reload)

Reloaded index storage space in the database in MB

DB cluster storage space (reload)

Reloaded cluster storage space in the database in MB

DB structure storage space (reload)

Reloaded structure storage space in the database in MB

Written data objects

Number of data objects that were written for an incomplete archiving session

Deleted data objects

Number of data objects that were deleted from the database for a complete archiving session

Reloaded data objects

Number of data objects that were reloaded into the database for a replaced archiving session

Number of delete jobs

Number of executed delete jobs for an archiving session

Length of write job

Length in hours of the write job for an archiving session

Length of delete job

Average length in hours of the delete job for an archiving run

Length of reload job

Length in hours of the reload job for an archiving session

Caution

When calculating storage space in the database, the system uses the length of the respective object types in the ABAP dictionary. The value determined in this way can therefore only be an indication of the actual storage space in the database.

Archiving Statistics Information

Statistics information is saved persistently in the database table ADMI_STATS. You can archive it together with archive management data using the archiving object BC_ARCHIVE.

Activities

Creating Statistics