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.
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 |
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