Statistics

Use

When writing, deleting, reading, or reloading, 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) is automatically generated and is persistently stored in the database The data archiving administrators can analyze these figures so that they can better plan future archiving projects and request the necessary resources. Statistics also provided pertinent information on the role of data archiving in reducing the data volume in the database.

Features

The statistics are collected by the Archive Development Kit (ADK). This occurs during the write, deleted, and reload processes. In other archiving contexts, such preprocessing, postprocessing or conversion programs, no statistics are collected.

You can call the analysis transaction, either directly from the initial screen of Archive Administration (transaction SARA), or from the management part of Archive Administration: To do so, choose Statistics. Alternatively, you can use transaction SAR_DA_STAT_ANALYSIS.

In addition to the analysis transaction, in which the statistics can be directly displayed, the statistics are also sent to the standard log for the write, delete, read and reload programs, from where they can also be analyzed. As a prerequisite, the relevant application must call the standard log. The standard log can be run in both test mode and production mode in the write program only. In all other programs it can be run in production mode only. In other archiving contexts, such preprocessing, postprocessing or conversion programs, no standard log is issued.

Selection

The statistical information is displayed on the basis of the selection data entered here. Selection data includes the client in which the archiving session was run, the name of the archiving object, the date on which the archiving session data was run, and the status of the archiving session. Multiple selection is also possible.

Archiving Session Number

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 status in the management part of Archive Administration. For more information, see Details on the Archiving Session.

Displaying Statistical Information

To display statistical information, choose Display Statistics.

The display uses the SAP List Viewer functions (formerly the ABAP List Viewer ALV). For a general description of the comprehensive functions of the SAP List Viewer and how to use this tool, see SAP List Viewer (ALV) Grid Control (BC-SRV-ALV).

To make settings that affect how the statistics are displayed, choose Select Layout. Here, you can, for example, set the column width, the column sequence, or column selection and then save the changed display as a user-specific layout variant. For a display that is easier to use, you can also 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

Notes

Archiving Session number

Archiving session number

Object

Archiving object name

Client

Client in which the archiving session was carried out

Date

Date on which the archiving session was carried out

Status

Status of the session number

  • 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. In addition to the actual data, an archive file also contains header data that classifies and describes the business data. An archiving session’s header data should be as small as possible.

DB Space (Write)

"Virtual" storage space in MB that is occupied by an incomplete archiving session in the database

  • DB Space (Write)

Occupied table storage spec in the database in MB;
Storage Space Category

  • DB Index Space (Write)

Occupied index storage space in the database in MB, storage space category "Indexes" in the column DB Space (Write)

  • DB Cluster Space (Write)

Occupied cluster storage space in the database in MB, storage space category "Cluster" in the column DB Space (Write)

  • DB Structure Space (Write)

Occupied structure storage space in the database in MB, storage space category "Structures" in the column DB Space (Write)

DB Storage Space (Delete)

"Virtual" storage space in MB that is occupied by an incomplete archiving session in the database

  • DB Table Space (Delete)

Deleted table storage space in the database in MB. Storage space category "Tables" in the column DB Space (Delete)

  • DB Space (Write)

Deleted table storage space in the database in MB. Storage space category "Tables" in the column DB Space (Delete)

  • DB Table Space (Delete)

Deleted cluster storage space in the database in MB, storage space category "Cluster" in the column DB Space (Delete)

  • DB Table Space (Delete)

Deleted structure storage space in the database in MB. Storage space category "Structures" in the column DB Space (Delete)

DB Space (Reload)

"Virtual" storage space in MB that is occupied by a reloaded archiving session in the database

  • DB Space (Reload)

Reloaded table storage space in the database in MB. Storage space category "Tables" in the column DB Space (Reload)

  • DB Index Space (Reload)

Reloaded index storage space in the database in MB. Storage space category "Indexes" in the column DB Space (Reload)

  • DB Cluster Space (Reload)

Reloaded cluster storage space in the database in MB, storage space category "Cluster" in the column DB Space (Reload)

  • DB Space (Reload)

Reloaded structure storage space in the database in MB. Storage space category "Structures" in the column DB Space (Reload)

Written Data Objects

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

Deleted Data Objects

Number of data objects that were deleted for an complete archiving session in the database

Reloaded Data Objects

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

Number of delete jobs

Number of delete jobs that have run for an archiving session

Write job duration

Duration of a write job for an archiving session in hours

Delete job duration

Average duration of an archiving session in hours

Reload job duration

Duration of a reload job for an archiving session in hours

To calculate database storage space, the system uses the length of the relevant object types as defined in the ABAP Dictionary. The value that is determined in this way can therefore only be seen as an approximation for the actual storage space in the database.

For more information on the calculation of database storage space and the storage space categories, see How Is Database Storage Space Calculated?.

Archiving Statistical Information

Statistical information is stored persistently in database table ADMI_STATS and can be archived together with the Archive Administration data using archiving object BC_ARCHIVE. For more information on BC_ARCHIVE, see Archiving Administration (BC-CCM-ADK).

Activities

Creating Statistics

See also:

How Is Database Storage Space Calculated?